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 derfloh 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: AThom10731
  • Content: Threads
  • Order by date
  1. AThom10731

    Code sends duplicate emails

    On form open I have code that I want to send a report as an email attachment each time the form is opened. The below code runs correctly and builds the email and attachment only it sends duplicate copy of the email each time I run it. Please help!!! Ann Private Sub Form_Load() Dim...
  2. AThom10731

    When I run the code without exiting the database I receive an error

    An error is received when I run the following code if I do not exit MS Access after running it. The code runs a query, exports results to an Excel file and formats the worksheets. If I exit Access each time it runs fine. I have a command button on a form that executes the code. Any...
  3. AThom10731

    Export Access into multiple excel tabs and conditionally format

    I have a MS access database and am able to export the data to a single excel file with multiple worksheets. Each worksheet is labeled with a site name. When I export the data, I would like to be able to format the data in VBA code or export to a template. I run the code from a command button...
  4. AThom10731

    Prevent a user from updating data in a subform

    I am collecting the Active Directory user name using Environ and am able to keep a subset of user from updating data in the main form but not a sub form. Anyone have any hints.

Part and Inventory Search

Back
Top