Solved

Microsoft Access 2007 - Trigger a Access Report from Word

Posted on 2011-09-28
1
269 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

749 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