Reply to thread

Message

<blockquote data-quote="Sir Whiskers" data-source="post: 846540" data-attributes="member: 6941">I'll second Davin on this. Creating a simple interface for novices is a great idea whenever using Access. I'm assuming your report is tied to the query, so you don't have to manually merge tables or anything to run it (in other words, you just run the report, print it, then close it). If so, consider:Create three macros, named &quot;mcrRunRptZZZ&quot; (where ZZZ is the name of the report), &quot;mcrCloseForm&quot;, &quot;mcrExitAccess&quot;. Each macro will have just one command.mcrRunRptZZZ:&nbsp; Open Report (specify the report name and whether you want it to print or appear in print preview)mcrCloseForm:&nbsp; Close (this will close the menu form you'll create in a minute)mcrExitAccess:&nbsp; Exit (this will close Access completely)Create a simple form with just three command buttons for now (use the toolbox to place them on the form).&nbsp; The three buttons will be named (caption property): Run Report ZZZ, Close Form, Exit. Tie the proper macro to each button with its OnClick event property.Then just set the startup properties in the database to display this menu form when the db opens. Your boss can click a button to run his report, then click Exit to exit the db. You can use the Close button to close this form when you want to get into the db.I can't tell from your posting how familiar you are with macros and command buttons, so the directions I listed above may be unnecessary. On the other hand, if you decide to do this and need any help, feel free to contact me at <a href="mailto:sirwhiskers@worldnet.att.net">sirwhiskers@worldnet.att.net</a>, or just post on this board.Good luck.</blockquote>

[QUOTE="Sir Whiskers, post: 846540, member: 6941"] I'll second Davin on this. Creating a simple interface for novices is a great idea whenever using Access. I'm assuming your report is tied to the query, so you don't have to manually merge tables or anything to run it (in other words, you just run the report, print it, then close it). If so, consider: Create three macros, named "mcrRunRptZZZ" (where ZZZ is the name of the report), "mcrCloseForm", "mcrExitAccess". Each macro will have just one command. mcrRunRptZZZ: Open Report (specify the report name and whether you want it to print or appear in print preview) mcrCloseForm: Close (this will close the menu form you'll create in a minute) mcrExitAccess: Exit (this will close Access completely) Create a simple form with just three command buttons for now (use the toolbox to place them on the form). The three buttons will be named (caption property): Run Report ZZZ, Close Form, Exit. Tie the proper macro to each button with its OnClick event property. Then just set the startup properties in the database to display this menu form when the db opens. Your boss can click a button to run his report, then click Exit to exit the db. You can use the Close button to close this form when you want to get into the db. I can't tell from your posting how familiar you are with macros and command buttons, so the directions I listed above may be unnecessary. On the other hand, if you decide to do this and need any help, feel free to contact me at [email]sirwhiskers@worldnet.att.net[/email], or just post on this board. Good luck. [/QUOTE]

Verification