Search results for query: *

I have previously saved sessions for each cost center in "R:\Cost Centers\Sessions\. If I don't use these sessions at least once every ninety days, they are automatically disabled. I would like to set up a little VBA macro to open each session and logon in. Once the session is open, I will be...

I have an Excel macro that is used to insert records into one table and update another table in an Access database. An Excel form is loaded with data, the user reviews the info, makes any changes, and then pushes a button. The button kicks off code to create accounting lines which are inserted...

I have an Excel macro that inserts and updates records in an Access Database using ADO. Users have commented about the performance when these tasks are completed. I have found some commands for Access (BeginTrans, CommitTrans) that may speed up the performance. My question is (1) can I use...

OK.......I'm offiicially stuck at this point. I have this sql statement to insert a new record with 67 fields. Following is the sql code: vsql = "INSERT into [GpDataDownloadFile] ([FTPFileDate], [GroupA], [Region], [UNIT], [TAXABLE], [BTName], [BTAddress], [BTCityStateZip], [ServiceLoc]...

I have an Excel workbook with several sheets. One of the sheets has 67 columns. I need to export this data into a table in Access. In the past, I have created an access object and used the transfer spreadsheet command. I'm wondering if there is a better or easier way to get the data into...

When the user pushes a button a form is displayed with all of the invoice details. The user can scroll through all of the invoices. When they find the one they want, they can click on a number of buttons and enter data in various fields. When the user clicks on the "Pay It" button, the...

Good Morning.........I'm writing a sql (ACCESS) statement to insert records into a table. There are 2 criteria: (1) Group and (2) Cost Center. The problenm I having is I'm not sure how to write the sql statement to extract the records where the cost center does not have a value. xSQL =...

I need to insert "distinct" records in one table with a sql statement. Following is the statement: xSQL = "INSERT INTO HeaderFile ([Date], [Grp], [Reg], [ServLoc], [AcctNo], [InvNo], [Unit]) IN '\\C:\MyDB.mdb' SELECT DLFile.Date, DLFile.Grp, DLFile.Region, DLFile.ServLoc, DLFile.AcctNo...

I created a query in Access and it runs fine. I copied the sql because I want to run it from Excel. However, I can't get it to run. Below is the sql code I'm using. When I kick it off, I get a "No Value provided for one or more required parameters". The connectionstring and data source have...