Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Location
    Brooklyn
    Posts
    25

    Unanswered: How to automate manual process

    Hello,
    I have a number of Sql queries that I have to re run daily and weekly to produce tables with data, and than I have to move that data to the reports, and than I have to move that reports to the local drive to send them via e-mail.
    Is there a way in ms access to automate this process, and if so how to do that?

    Thank you so much

    A.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Yes, access can automate this process.

    I have a number of Sql queries that I have to re run daily and weekly to produce tables with data
    Short answer:
    DoCmd.Execute

    Long answer:
    Are you SURE you want to store your queries as tables? Why do you want to duplicate data that's already in your database. There are a couple reasons one might want to do this, but you don't come across them very often.

    I have to move that data to the reports
    Data doesn't get "moved" to a report, ever. Reports are based on either a table or a query, the report never owns the data it's pointing at and data is certainly never "moved into" a report.

    Maybe you should be looking at a parameter report...

    I have to move that reports to the local drive to send them via e-mail.
    Short Answer: DoCmd.SendObject

    Long Answer: Again, ARE YOU SURE you want to be saving your reports to the hard drive? There aren't many scenarios where one would want to do this...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jan 2005
    Location
    Brooklyn
    Posts
    25
    Thank you so much for an answers, but I never used the DoCmd before. I do not have a programming backgrnd, but I would like to learn the automation steps.

    A.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •