Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Shaves

    Open previously saved sessions with Visual Basic

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

    Open previously saved sessions with Visual Basic

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

    Open previously saved sessions with Visual Basic

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

    Open previously saved sessions with Visual Basic

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

    Updating Access From Excel

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

    Excel / Access / Begin Trans

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

    Excel / Access / Begin Trans

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

    syntax error in INSERT INTO statement

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

    exporting data into access

    It is an existing table
  10. Shaves

    exporting data into access

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

    form on top of a form

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

    Extract records with no value

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

    insert distinct records in a table (Access VBA)

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

    insert distinct records in a table (Access VBA)

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

    sql error

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

    sql error

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

    sql error

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

Part and Inventory Search

Back
Top