Running an Access report from a link

[Airbiskit]

Is this possible to access an Access report by using a link from say Word? I know you can have a startup menu in Access that can have buttons to the reports but I was after a link that could go straight into the report.

Any ideas?

Thanks

 

[mp9]

Create a macro in your db that runs the report.

Then, in your Word document you need a link to a full Access command line which takes the form:

[Location of Access EXE] [Location of db] /x [Name of created macro]

e.g.

"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\mydbs\db1.mdb" / mcrRunRpt

Then your link will open the db and run the report.

Hope this helps.

http://www22.brinkster.com/accessory/

 

[mp9]

Oops, missed the x from the example - it should be:

e.g.

"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\mydbs\db1.mdb" /x mcrRunRpt

http://www22.brinkster.com/accessory/