Open report w/o opening DB

D

Debbiedo

I am wondering if I can create an application that when you click on
it (say a shortcut), it opens a report parameter box to query a set
of
parameters, and then opens the report based on these selections
without actually opening the access database window.

In other words, can I have the end user only see (i.e. have access
to)
the report in the print preview mode after selecting a set of
parameters?

If so, any suggestions as to how to go about this? I am using Access
2003 for XP

Many thanks

Debbie
 
A

Aaron Kempf

long term-- move to Reporting Services

short -term move to Access Data Projects
 
A

Al Campagna

Debbie,
Create a macro called AutoExec, use the OpenReport action to open the report.
Autoexec has special meaning to Access, and always runs first. From there the report's
parameters and the report will take over.
Also, you can select Tools/Startup, and deselect Display Database Window. That will
hide the Access database screen itself.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Report skips through form with parameters 7
How do I open my report in print preview mode in Access? 2
access report 0
Access 2007-Report opens by default in Print Preview mode 2
Prevent users from accessing report design mode 1
Set report criteria in code? 2
report doesn't print 0

Top