Opening a report on startup (1 Viewer)

[Scottigus]

I have been checking all over online but I cannot find it...so I thought I would ask here since you guys have been so helpful so far.

My question is, how do I have a report start up when the database is opened. All I can find online is how to get forms to start upon opening the database, but I would like a report to start up. The reason is because we have employees who need interviews every so often (a set time away). The report would open up showing the Employee names, what review they are needing, and the date the review. Example:

John Adams Salary Review 2/25/2009

It would only show up on the report if it was within a certain criteria.

So, that is the background, and I guess my question was is there a way to startup a "report" upon startup and not a "form"?

I have been looking for the answer for 2 days. Any help would be great!!

Thanks,

Scott

 

[boblarson]

Just create a macro called AutoExec and set the action to open the report.

 

[Scottigus]

Wow that was a fast response...lol

Okay, so I am unfamiliar with macros and such. I had training in access about 4 years ago and it unfortunately didn't work out so well as the school went bankrupt.

Any help on how to actually accomplish this would be great. Thank you again for the quick response Bob!

-Scott

 

[boblarson]

1. Go to your database window

2. Click on the category MACROS

3. Select NEW

4. Go to ACTIONS and select from the drop down OpenReport

5. Select the report from the drop down in the arguments list below

6. Save the macro with the name AutoExec

That should do it (there may be some minor "tweaks" to the process).

 

[Scottigus]

Thank you very much bob. I am very grateful! You have been a VERY big help!

-Scott

 

[boblarson]

Thank you very much bob. I am very grateful! You have been a VERY big help!

-Scott

Glad we could assist