Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I have Access open a Report on open 1

Status
Not open for further replies.

chrisgeek

Technical User
Oct 16, 2008
25
US
I have a form/query/report all together and I'm wondering if I can have Access open this report automatically on open. I can't seem to figure out the VBA that will do this.

Thanks in advance,

Chris
 
Create a macro called autoexec or autoexec.bat (can't remeber which) that does a Do.Cmd OpenReport action for the report you want. If it doesn't pop up, try calling the macro as the startup object under the tools dropdown menu.

Ever notice how fast Windows runs? Me neither.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top