Search results

  1. R

    resources on vba and macros for importing text files into Access

    thanks for the information. RD
  2. R

    resources on vba and macros for importing text files into Access

    Need to do some research - I was looking to be able to open the db, select tools->macro->run macro and select it
  3. R

    resources on vba and macros for importing text files into Access

    make vba macro available - can only run it in VBA editor This one is driving me batty - I finally got the vba code to work, but I can only run the VBA macro from within the VBA editor. When ever I try to run it form anywhere else the run button is greyed out.
  4. R

    resources on vba and macros for importing text files into Access

    After sniffing around different sites I put together this macro. The DoCmd is very slick and easy...as stated several times on this forum VBA is the way to go. Sub importSeasonalSales() DoCmd.RunSQL "delete from Gr_orddtl2" DoCmd.RunSQL "delete from Gr_ordhdr" DoCmd.TransferText...
  5. R

    resources on vba and macros for importing text files into Access

    Thanks - I'll check it out!
  6. R

    processing a text file currently being brought into MS Access via macros and queries

    Mr Lee, Could you tell me how you created the macro to read in the data for the db? Thanks. Richard
  7. R

    resources on vba and macros for importing text files into Access

    Hi to all, I found this forum while searching the Internet in frustration on the process of updating Access databases. So far I've found out that macros in Access aren't as east to create as they are in Excel; which I've been doing successfully for years. Could someone suggest a good "soups to...
Back
Top Bottom