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!

Register Log in
  • Congratulations John Tel 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: *

  • Users: Mrogersy
  • Content: Threads
  • Order by date
  1. 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?
  2. 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...
  3. 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...
  4. 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