Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    19

    Unanswered: Automating a report to produce a report or email,

    All,

    I'm getting savvy at creating batch files from the command prompt. I have a query tool I use to pull information down through an ODBC connection from our vendor's database. I have placed several batch jobs into the windows scheduler. These jobs run, and the output is linked to a table in MS Access. I have built a query that takes the "max" information from the output of the batch file because it just appends all new data to the csv location. All this works, and gives me what I need.

    Here is where I get stuck. I want to create a report that will either save out to the shared network drive, or attach a report to an email and send every time the query is updated with new information (probably monthly).

    The purpose here is to automate this report all together. I don't want to have to create a macro button to build the report, and have to remember to run it or send it.

    Anyone have any thoughts???

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I want to create a database that will either save out to the shared network drive or attach a report to an email and send as soon as the database is opened. I then want to launch this database from my savvy batch files.

    ^^

    Signed,
    Mr Cryptic
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Maybe try using scheduled tasks in Windows;

    How To Schedule Tasks in Windows XP
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  4. #4
    Join Date
    May 2009
    Posts
    19
    I'm familiar with task scheduler. I will ultimately use it to run the reports, but seems like there would probably be some sort of code that I would need to add stating "when value in report changes....produce report." That is what I'm trying to get at. Currently I use the scheduler to run the batch files (sql statements).

Posting Permissions

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