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!

Search results for query: *

  • Users: 3pmilk
  • Content: Threads
  • Order by date
  1. 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...
  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 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 3pmilk

    ACCESS VBA SQL

    Hi all, here's my problem: When I execute my sql againast Oracle server via sql navigator, it works well. However, when executing the same query in Access, the JET engine doesn't like the Oracle reserved key words such as START WITH, CONNECT BY PRIOR, and ORDER SIBLINGS BY. Any ideas how I...
  12. 3pmilk

    ACCESS VBA SQL

    Hi all, here's my problem: When I execute my sql againast Oracle server via sql navigator, it works well. However, when executing the same query in Access, the JET engine doesn't like the Oracle reserved key words such as START WITH, CONNECT BY PRIOR, and ORDER SIBLINGS BY. Any ideas how I...
  13. 3pmilk

    Need help on ODBC connection

    Hi all, I use access as the front-end and Oracle as the backend I have a form that has a button; when click it, it will produce and export the result set to a excel spreadsheet. The problem I have is that when user clicks the button, they have to manually select the datasource of the...
  14. 3pmilk

    append result sets from 2 different queries to excel

    Hi, I have 2 queries. Each query gives me a result set. What I need is to append the result from the 2nd query to the first one. How would I do that? The following is a sample of my code. First, I use VBA to ouput the result from query 1 to an excel spreadsheet, and it did work... what I want...
  15. 3pmilk

    how to find tables?

    Hi all, If I have a value, let's say "ABCDE," and I know this value exists in a field of a table, but I don't know which table or field that this value is in. How do I go about using Oracle's data dictionary to search for the field and the table in which this value "abcde" is in? I have...
  16. 3pmilk

    How to write Reverse Code Engineering Documents?

    Hi all, My boss has given me a new assignment today. She wants me document an existing application that I have no clue on. Apparently, the developer who created this VB application is leaving and is not going to provide any documentation for our department, so it’s my job to interview, gather...
  17. 3pmilk

    Trying to create DDF files through pcc/sqldm 8.6.

    Hi all, I have bunch of btr files and I'm trying to create ddf files through PCC/sqlDM 8.6 These are the steps I took: under my my machine ->Database(engine), I did it right-click to create new database. I enter "mydatabase" without quotes in the Name field In directory field, I have...
  18. 3pmilk

    Import btr files & establish odbc conn with Pervasive SQL Data manager

    Hi All, I'm totally new with Pervasive Btrieve. I need to know how do I establish an odbc connection with the data manager and import bunch btr files without defining their table structures. Is this possible? Right now when I log into sql data manger, it doesn't have any database to which I...
  19. 3pmilk

    Import btr files & establish odbc conn with Pervasive SQL Data manager

    Hi All, I'm totally new with Pervasive Btrieve. I need to know how do I establish an odbc connection with the data manager and import bunch btr files without defining their table structures. Is this possible? Right now when I log into sql data manger, it doesn't have any database to which I...
  20. 3pmilk

    Starting out in VC++

    Hi, I wrote a simple "Hello world" program in VC++ and when I executed the program, it gave me the following error message: --------------------Configuration: Hello - Win32 Debug-------------------- Compiling... Helloworld.cpp c:\program files\microsoft visual...

Part and Inventory Search

Back
Top