how do I schedule a .mdb to run?

[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

 

[Douglas J. Steele]

What's your code to autorun the report? Does it work if you just
double-click on the MDB?

 

[Rover]

"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.

 

[Douglas J. Steele]

How are you scheduling it?

Schedulers usually run under a specific security context. Has a printer been
defined for that ID?

 

[Rover]

I got it to work
Thanks

 

[Larry Linson]

I got it to work
Thanks

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

 

[Rover]

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

 

[Larry Linson]

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