Recent content by 3pmilk

Thanks, Randy, for the example. What I'm interested in is what if I want to select the top 10 records that don't match from in table 1 and 2. How do I do that?

Hi all, I'm creating a VBA/ACCESS app that contains two listview boxes: listview box A and ListView B. Each Listview box contains a list of project IDs. The user has the option of choosing a project from each listview box and compare their results. I have written a query to retrieve data from...

Hi all, I'm creating a VBA/ACCESS app that contains two listview boxes: listview box A and ListView B. Each Listview box contains a list of project IDs. The user has the option of choosing a project from each listview box and compare their results. I have written a query to retrieve data from...

Hi all, I'm creating a VBA/ACCESS app that contains two listview boxes: listview box A and ListView B. Each Listview box contains a list of project IDs. The user has the option of choosing a project from each listview box and compare their results. I have written a query to retrieve data from...

Hi all, I have a progress bar and I want to show users the percentage completion process when executing sql and generating a report. The following code snippet is consists of a function that indicates percentage completion and a procedure that calls the function. However, I'm getting object...

Hi cmmrfrds, It worked! THANK YOU..THANK YOU..THANK YOU...SO MUCH. You're a genius :)

Hi cmmrfrds, Thanks again for your help. I implemented your advice exactly, but I'm still getting an error that says "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." And the offending code is at conn.open connectionstring...

Hi cmmrfrds, when I use rs.Open strSQL, conn,3,3 it says "operation is not allowed when the object is closed" And if I put conn.open after my conn.connectionstring line it says " " multipule-step OLE DB operation generated errors. Check each OLE DB status vaule, if available. No work...

Hi cmmrfrds, Thank you very much for your advice. I followed your steps of creating the connection and the connection was successful. However, I'm running into other problems. Somehow I can load the data into a recordset. Here's my code: When I execute this code, it stopped at set rs =...

Thanks again, cmmrfrds, for your help. I will give it a try tomorrow. Quick question: can recordset's open method execute a pass-thru query object in access? If it can't then I'm not sure how to implement your advice into the works, because I have tried to convert my "pass-thru" query into...

actually it's T-SQL (it has INNER JOIN clauses) plus oracle keywords like start with and connect by. I don't think it's PL/sql because it doesn't have keywords like begin and end

Thanks cmmrfrds. Would this work for pass-thru query?

Hi cmmrfrds, I'm not binding the query to anything. I have a pass-thru query (with oracle reserved key words) in Access 2003, so I can't covert it into sql statements in VBA programmatically, because there's no direct equivalent in T-SQL for Oracle's START WITH...CONNECT BY. My first...

Hi all, Any help would be much appreciated. I would like to know if there is a way to call a pass-thru query via ADO connection object? for start, I have a pass-thru query (with oracle reserved key words) in Access 2003, so I can't covert the pass-thru query into sql statements in VBA...

Hi all, Any help would be much appreciated. I would like to know if there is a way to call a pass-thru query via ADO connection object? for start, I have a pass-thru query (with oracle reserved key words) in Access 2003, so I can't covert the pass-thru query into sql statements in VBA...