How can I use my Access DB like a program. I have a Formwhere users will input informtaion which is queried to a report, which in turn gets printed out. I would like to run it like a program so they cannot see any toolbars or editing options. I only want the end user to be able to see the form and report. Any ideas would be greatly appreciated.
Run Form as a program
- Thread starter chaps632
- Start date
Mile-O
Back once again...
- Local time
- Today, 00:49
- Joined
- Dec 10, 2002
- Messages
- 11,316
Lookup the options in Tools -> Startup to hide toolbars, etc.
To completely hide the menu you may wish to look at the blank menu bar solution I posted on this thread.
To completely hide the menu you may wish to look at the blank menu bar solution I posted on this thread.
report behind popup
I appreciate your help greatly and it works but I have a query set up that sends all my info from a form to a report. I have a button on my form to preview the report. When I try to preview it the window is behind the popup form and users will not know that . Is there a way to make that report come up over the form popup window?
Thanks.
I appreciate your help greatly and it works but I have a query set up that sends all my info from a form to a report. I have a button on my form to preview the report. When I try to preview it the window is behind the popup form and users will not know that . Is there a way to make that report come up over the form popup window?
Thanks.
Mile-O
Back once again...
- Local time
- Today, 00:49
- Joined
- Dec 10, 2002
- Messages
- 11,316
Why not hide the form while the Report is open?
In the report's Activate() event:
and in its Deactivate() event:
You'd need to put this extra bit of code into a module:
In the report's Activate() event:
Code:
Forms("frmMyForm").Visible = Falseand in its Deactivate() event:
Code:
If IsFormLoaded("frmMyForm") Then Forms("frmMyForm").Visible = TrueYou'd need to put this extra bit of code into a module:
Code:
Function IsFormOpen(strFormName As String) As Boolean
IsFormOpen = (SysCmd(acSysCmdGetObjectState, acForm, strFormName) = acObjStateOpen)
End Function
IMO
Now Known as ___
- Local time
- Today, 00:49
- Joined
- Sep 11, 2002
- Messages
- 723
Or place the report on another popup form
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51078
IMO
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51078
IMO
cannot find Macro
Thanks again for your help Mile but when I inserted that code into a module and changed the activate and deactivate events in the report it still did not work.
I am new at this (Brand new) so please excuse my ignorance. Could it have anything to do with the fact that the Function is names "IsFormOpen" and the events call "IsFormLoaded"? That's just a stab in the dark. I am getting two error messages that say, "can't find the macro If IsFormOpen(frmInput) Then Forms(frmInput)"
and "can't find the macro Forms(frmInput)"
should there be a macro, because I put them in a module like you suggested.
Thanks again.
Thanks again for your help Mile but when I inserted that code into a module and changed the activate and deactivate events in the report it still did not work.
I am new at this (Brand new) so please excuse my ignorance. Could it have anything to do with the fact that the Function is names "IsFormOpen" and the events call "IsFormLoaded"? That's just a stab in the dark. I am getting two error messages that say, "can't find the macro If IsFormOpen(frmInput) Then Forms(frmInput)"
and "can't find the macro Forms(frmInput)"
should there be a macro, because I put them in a module like you suggested.
Thanks again.
Similar threads
