Sorry for the delayed response. That is exactly what I am doing. Running a macro and screen scraping data for end users. I'm going to work with this next week to see if I can get it to work for me. The only difference is that I haven't used EXTRA. Thanks for all of the help with this........
Skip...........When I refer to session, I'm referring to a specific "rd5x" file that was previously saved. Our company uses different machines / mainframes for different cost centers. The macros I write generally start with a "rd5x" file already open. However, in this case, I want to open a...
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...
Here is the code I'm using. Do you see anything that could speed this up. The database is on a network drive and the users are saying it takes up to 30 seconds to update the database.
Dim Connection As New ADODB.Connection
Dim RecSet As New ADODB.Connection
Set Connection = New...
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 have checked and all of the field names are spelled correctly? Any other suggestions?
Can you look at the "Mid" expresssions and tell me if something isgoing on there? Thanks
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.