i know nothing about access (almost) v.need to create some reports

Discussion in 'OT Technology' started by keleko, Nov 22, 2006.

  1. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
    specifially, access 97 (i know i know i know, somewhere around april they'll be migrating to sql)

    i have about 50+ reports that need to be run, copied to another folder, then about 14 emails sent (different reports to different addresses)

    currently, it's :
    radmin (remote desktop) to open database on server, run a report, open database local, run another report
    alternate between the two as they finish, save as *****.snp to a specific directory, overwriting current file #^
    and there's 3 different databases
    save all the newly created files to a new folder with that day's date (i.e. 11-22-06)
    make new email, use distribution list, copy shortcuts to a specific file or set of files (the .snp) and send
    make another new email, repeat process with different list and different files


    #^ as you read that, and then read more, you might ask why create a new folder and then copy those new reports there instead of just making the final folder and saving to that
    i don't know, that's just how they want it, so we'll keep it like that


    takes about 2 hours to do right now, would like to make it take 2 minutes (excluding time to actually run the reports, some take up to 5 minutes and some take 2 seconds) but i have no idea how to make a script to do this
    i need my time available for other things that need to be done around here, not running reports that can and should be done automatically

    obtw, these are critical reports, otherwise they managers in various depts. of the plant have no idea what needs to be done that day
    they HAVE to be emailed by ~8am (i get up at 5 and start running them by 6am)

    in the past to do some automated tasks i have used a program called AutoIT, but i haven't used it in several years, and this is all access anyway so it SHOULD be able to do this itself


    so, where do i start?
     
  2. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
    aaaaaaaaaaaaaaaaaanyone?
     
  3. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Uh, why not start with macros? It's built into Access. Outside of the macro commands, you can use vba script (very similar to vbscript) to do everything else (macros's can call custom functions). VBA can solve all of your problems - you just have to take the time to learn it.
     
  5. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
    durrrrrrrrrrr

    that's REAL helpful there :rolleyes:
     
  6. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Actually it is. You want a quick fix - not going to happen. The help for access 97 is very good so it's really not hard. You're frustrated that someone doesn't sit down and write out the macros for you.
     
  7. michelin man

    michelin man IDB Construction

    Joined:
    Jul 22, 2001
    Messages:
    11,660
    Likes Received:
    0
    Location:
    Austin
    VBA is REAL easy to learn.

    you might want to also look at:
    www.utteraccess.com
    www.dbforums.com
     
  8. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
    maybe not write them out, but at least give examples maybe
     
  9. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Alright - look up this command:

    docmd.SendTo
     
  10. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
    thanks, but that means nothing to me

    maybe if i could get an example of opening said database, running a report, saving the file as .snp - then i can expand on it and make it do what i want

    :dunno:
     
  11. couchlock

    couchlock OT Supporter

    Joined:
    Apr 8, 2002
    Messages:
    40,825
    Likes Received:
    301
    Location:
    The Highway
    did you get a jerb kelelo>?
     
  12. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
    posting from it now :wavey:


    gawd i hate 5am....
     
  13. couchlock

    couchlock OT Supporter

    Joined:
    Apr 8, 2002
    Messages:
    40,825
    Likes Received:
    301
    Location:
    The Highway
    sweet what are you doin, for how much, and for who?
     
  14. keleko

    keleko yes, he is

    Joined:
    May 22, 2005
    Messages:
    28,741
    Likes Received:
    0
    Location:
    lauderhill, fl
    network admin, i am teh bofh :big grin:
    for not enough, of course
    i won't say for who, online - but i will say we make something everyone who has gone to school in the usa has used ;)
     

Share This Page