Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Thanked 0 Times in 0 Posts

    Access Macro (2000)

    I have managed to write my very first macro to output a report in Access 2000 to a Word File. I have a few questions... is there a way to schedule the macro to run? Also, I have it outputting to a specific folder. But of course, after the macro runs each time after the first inital, I get a popup that reads "file already exists, Do you want to replace the file?" Is there a way to avoid this. Like put a condition that says to overwrite it? Any help would be much appreciated. Thanks so much!!

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Indianapolis, Indiana, USA
    Thanked 0 Times in 0 Posts

    Re: Access Macro (2000)

    A quick search of the lounge for "schedule macro" turns up this post.

    As for your question about a file existing - you can handle conditions to some extent in macros, but most people find it easier to use a simple if/then statement in a VBA module. You can use the Save As Module option to export your macro into VBA code.

    If you need any help with your code feel free to post what you have on the lounge and someone will be able to help you from there...

    Once you get your function written in a module, you can run it from a macro by using the "RunCode" macro with the function name as the argument.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

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