Search results for query: *

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...

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...

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...

Thank you, appelq. I took your advice and it kinda worked. Unfortunately, the connection string doesn't STAY saved. The connection would only work at the time it was saved. subsequent times when executing the sam query, it would generate an ODBC failure error and I would have to re-set and...