Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 3pmilk

  1. 3pmilk

    How to select the top 10 non-matching records using SQL

    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?
  2. 3pmilk

    How to select the top 10 non-matching records using SQL

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

    How to select the top 10 non-matching records using SQL

    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...
  4. 3pmilk

    How to select the top 10 non-matching records using SQL

    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...
  5. 3pmilk

    How to Indicate percentage completion on progress bar

    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...
  6. 3pmilk

    ACCESS VBA SQL

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

    ACCESS VBA SQL

    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...
  8. 3pmilk

    ACCESS VBA SQL

    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...
  9. 3pmilk

    ACCESS VBA SQL

    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 =...
  10. 3pmilk

    ACCESS VBA SQL

    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...
  11. 3pmilk

    Pass-thru query via ADO connection in VBA

    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
  12. 3pmilk

    Pass-thru query via ADO connection in VBA

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

    ACCESS VBA SQL

    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...
  14. 3pmilk

    Pass-thru query via ADO connection 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...
  15. 3pmilk

    Pass-thru query via ADO connection 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...
See more

Part and Inventory Search

Back
Top