?
Solved

Microsoft Access 2007 - Trigger a Access Report from Word

Posted on 2011-09-28
1
Medium Priority
?
286 Views
Last Modified: 2012-05-12
Hi Experts,

I need assistance with triggering a Basic Access Report from MS Word via a Hyperlink.
By Clicking on the hyperlink, this will automatically run a pre-defined report and display the generated report.

Is this possible?

Many thanks.
0
Comment
Question by:starfishjen
1 Comment
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 36716052
You can call Access from the commandline with a Macro. That Macro could then run your report.

So your hyperlink in Word could point to this:

"full path to your Access database /x NameOfYourMacro"

You'd have to add a Macro to the Access database, and then setup that Macro to open your report.

I'm not sure if Word has the same syntax, but in Access you can use FollowHyperlink:

Application.FollowHyperlink ""full path to your Access database /x NameOfYourMacro"

Note that if your Access database has a startup form or Macro, this will run in addition to the Macro you specify above, so you may find this to be not usable. If so, you'll have to automate Access to do this, which is a bit more difficult.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question