Search results for query: *

Hello All, I had made a VB program to update some tables using ODBC connection. The VB codes works great when its ran from the VB mode. I want to make an exe out of it so I can make it a Scheduled process to run from Windows XP. When I made the exe, it created the exe successfully. But when I...

Hello All, I have a Access SQL query that I am running from VB, but for some reason it doesnt come right from VB but the query works great from Access. Now I can run it from Access but the problem is the query fetches over 3.5 million records. So I had set a incremental run code in VB. Can I do...

Hello all, Here is a portion of query I am running from DB2. Would like to convert it to Access (Jet) sql. Please help SELECT A.CUSTOMER_NBR, A.CONTRACT_ID, A.BRANCH_CO_NBR, A.BRANCH_NBR, C.BRANCH_NAME, D.DEALER_NBR, D.DEALER_NM, D.SOG_NBR, E.SOG_NAME, A.CNTR_BILL_ADDR, VALUE(I.LAST_NAME,'?')...

Hello All, I am working on a ASP application which connects to a access db to get user login information and store data. The connection timesout after 20 minutes once the user logs in a leaves the session idle. Is there anyway to increase the timeout range without changing anything on the IIS...

Hello All, What I am tryin to accomplish is run a DB2 SQL query and save the results to a Access table. I was suggested to use a pass through query. What are my options to do a insert in a pass through query. Please advise. Thanks, Miller 1975

Hello All, I am trying to write a query where the date value can be checked with a previous date. Right now my code picks real date values eg:4/21/2005 But I want to have option to use previous dates..for example 3 days from today or 2 days from today.. How do I do that.. WHERE (((TEST.VALUE <>...

Hello, I had written this query for importing some data. I made some changes to it but now its not working. This is written to VB to update a Access DB Please advice whats wrong SELECT A.CUSTOMER_NBR, A.CONTRACT_ID, A.BRANCH_CO_NBR, A.BRANCH_NBR, C.BRANCH_NAME, D.DEALER_NBR, D.DEALER_NM...

Hello All, I am running a VB batch code to get some data in Access. What I want to do is capture the date when the batch ran and store that value in a table. For example the table where this date should stored will be called "UpdateDate" and it will have just one field called "ProcessDate". Can...

Hello All, How do you move/transfer data from one table to other using a query assuming both tables have same field structure.

Hello All, I am attempting to do the following. I have 2 tables, I am going to call it Tbl_Old (has old data) and Tbl_New (has new data). Both the tables have same field names and structure. I need to compare these 2 tables and show the difference in a new table, which I will call Tbl_Result...

I been having problems with this query for couple of days. I was trying to convert this from Db2 to access but something is missing. [code] Db2 Version SELECT B.CUSTOMER_NBR, B.CONTRACT_ID, A.LEGAL_NAME, (CASE WHEN E.TEAM IS NULL THEN C.TEAM...

Does VB recognize ANSI SQL. The reason I am asking is I got a code in ASNI (from DB2) and want to run it to get data into Access (which run on Jet). I am having trouble after trying to converting query to Jet. So if Vb can run ASNI SQL then its good. Please advice.

Hello all, I have this query in ASNI (written for my DB2 database) and I want it converted to Jet as I am going to now run it in Access. Please help SELECT B.CUSTOMER_NBR, B.CONTRACT_ID, A.LEGAL_NAME, (CASE WHEN E.TEAM IS NULL THEN C.TEAM...

I had posted a thread yesterday to import a .txt file to excel and then move it to a new location. But for some reason the code was not working. So I made a macro in excel to import the txt file. But I still cant automatic it in Vb. Can anyone please help me figure this out. I need to import...

Hello all, I am trying to extract data to a excel spreadsheet and move the file to a new location. I am getting data in text format from a query and the text file is getting saved in a folder. I am attempting to pick the text file from that location import it to excel and them move the excel to...