Search results for query: *

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

Can you show me some code to open a session in Extra....maybe I can compare the code to Reflections and see if I can find something similar? Thanks

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

It is an existing table

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

sorry.....but the same unit number can appear on mulitple lines...

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

Skip........what does "NO BANG.between table and field" mean? Thanks for all of the help!

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