Search results for query: *

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

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

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

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

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

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

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

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

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

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

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