Starting an access app with Scheduler

[hetherg]

We can successfully start Access 97 and run a macro from the Run command. However when the same command line and switches are used with scheduler, Access starts (autoexec runs) , the macro specified with /x starts (it only has to open a form and send an {Enter}) but only the form is opened and then the Properties dialog for the scheduled task comes up and that is the last thing to happen. Maybe someone can shed some light on using Scheduler to start Access with ad /x switch.

 

[Twin]

Hi there,
I do not know what is /x switch, but the following works for me:
i have several databases running overnight through the scheduler.
Upon openning, I have an Autoexec macro running that takes care of everything.
Can you tell us more details like what is {ENTER} supposed to do?
Chris

 

[andrewvranjes]

macro for emailling a outputted query

Hi twin/ fellow accesser's

if you have the time, can you point me in the right direction on this issue.

I have a query which needs to be run every hour during business hours.

I have setup a scheduler to run this.

The query has a marco that emails the query output to the call centre at my work. Which is exactly what i require, but my collegues are asking that the email be embedded so that instead of recieving a emial with a excell attachment, that the query be displayed ion there outlook msg's rather than them having to open a attachment to view the data.

I have tried changing the output file options between rich text, html, etc etc to no avail, it still comes as an attachment.

Is there anyway that i can make this outputted data embedded in the email without having to resort to visual basic?

thanks mate

Andrew