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

    VBA Access Delete Number 0 on import

    Thanks, I might go that route instead.
  2. Mrogersy

    VBA Access Delete Number 0 on import

    I do not care, and would not like anything there (not even spaces). AFter I import the file, I am matching that number to another table which shows the number as 264522, instead of 264522, as it is being imported. My vendor sends the data two different ways, 264522 and 000264522. Thanks, Mike
  3. Mrogersy

    VBA Access Delete Number 0 on import

    I am trying to import a file into a table that has the field set as a text field. It is importing the number 00026422 as this, and I need to remove any preceeding 0's before import to read 264222. Anybody know how to do this?
  4. Mrogersy

    MS Access Subdata Sheet Filter+

    I have a query that is generated off Table A. I am trying to create a Subdata sheet that filters by a code. QueryA: Name, Reason Code, Date, CSR, Notes. They are all totalled (Summary). Subdata Sheet should show the details of the same table by "Reason Code". Reason Codes have a value of 1- 10...
  5. Mrogersy

    MS Access Back using VBA

    I am trying to automatically create a back up of a database on form load. I am not having any luck with the code I have found, I am only a intermediate programmer. Does anybody have any code to create a back up on form load? Here is the code I was trying to use: Dim strRootPath Dim strFileName...
  6. Mrogersy

    Exporting multiple access reports to e-mail

    Is the add method in the MS Access VB code, or in MS Outlook VB code?
  7. Mrogersy

    Exporting multiple access reports to e-mail

    I am trying to export 5 reports (.xls format) from Access to a new e-mail message in outlook. I am struggling on the code (VB) to add multiple files to one e-mail. Does anybody know if this can be done, if so, do you have some sample code that may be of assitance? Mrogersy

Part and Inventory Search

Back
Top