how do I schedule a .mdb to run?

  • Thread starter Thread starter Rover
  • Start date Start date
R

Rover

I'm trying to auto run a report. I have a database that can be double
clicked and without further intervention it prints my report. If I
schedule it, Windows scheduler will say "running" but nothing happens.

I'm running a2k on a win XP Pro machine.

Any help would be appreciated.

Jim
 
What's your code to autorun the report? Does it work if you just
double-click on the MDB?
 
"I have a database that can be double clicked and without further
intervention it prints my report."

Yes, if I just double click on it it works fine. The mdb has only one
form and it is in the startup for that mdb.
 
How are you scheduling it?

Schedulers usually run under a specific security context. Has a printer been
defined for that ID?
 
I got it to work
Thanks
Click to expand...

If you'd say _how_ you got it to work, it might help someone in the
future -- and that's what newsgroups are about. They aren't just for getting
immediate answers to our questions, though it'd be hard to find a better
source for those immediate answers.

In fact, there are some excellent suggestions for effective use of
newsgroups in the FAQ at http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP
 
Truth of the matter is... it was working all the time. If I would
double click on the .mdb, it would appear on my screen and show the
report as it was supposed to. When I would schedule it, it would never
appear (I was testing in the report in acViewPreview) but in Explorer I
could see the .ldb and scheduler would say it was running. I changed
the report to acViewNormal and the report printed on the printer nicely.
I included a DoCmd.Quit and all is now well.

Jim
 
Thanks for the details... you did change something... acViewPreview to
acViewNormal.
 
Back
Top