K
Karl
Is there any way of displaying the forms etc without access at the back
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Van T. Dinh
K
Karl
Have tried this but get Cannot hide Access unless a form is on screen every
time
Have made the form popup and put the hide command in form open
any ideas?
time
Have made the form popup and put the hide command in form open
any ideas?
A
Albert D. Kallal
You might want to complete hide the ms-access interface, but not remove the
back ground?
There is two separate issues going on here:
1) complete hide the ms-access interface
2) Hide the grey background, or the so called MIDI interface.
Depending on your application, you might find it better to simply hide the
ms-access interface. This "hiding" can be done via the tools->start-up
options, and no code is required.
If you want to see a neat example of how well this works, try downloading
the 3rd example at the following web page:
Once you try it a bit, to "get in" to the ms-access interface and see how
this mdb was setup, simply hold down the shift-key during start-up, and you
will by-pass all those settings in the tools->start-up.
Check out:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
Remember, Excel, Word, and most applications have child windows, so it might
no be so bad that ms-access also uses child windows.
back ground?
There is two separate issues going on here:
1) complete hide the ms-access interface
2) Hide the grey background, or the so called MIDI interface.
Depending on your application, you might find it better to simply hide the
ms-access interface. This "hiding" can be done via the tools->start-up
options, and no code is required.
If you want to see a neat example of how well this works, try downloading
the 3rd example at the following web page:
Once you try it a bit, to "get in" to the ms-access interface and see how
this mdb was setup, simply hold down the shift-key during start-up, and you
will by-pass all those settings in the tools->start-up.
Check out:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
Remember, Excel, Word, and most applications have child windows, so it might
no be so bad that ms-access also uses child windows.
V
Van T. Dinh
Won't work in Form_Open Event since the Form is not yet officially active
(according to Windows OS). It depends on which Access version you are using
whether you can use one of the later Form Events, i.e. Activate or Current.
IIRC, the Autoexec Macro to open the Form (OpenForm action) & then run the
code (RunCode action) in the link I posted seemed to work fine.
Beware that Access database applications are supposed to work in the Access
window. There are other problems when you hide the Access window, most
notably:
* If an untrapped error happens, the Access Form may disappear from the
screen even though Access is still in the memory. This will be confusing
for your users. If you hide the Access window, make sure that you have
error-trapping in *every* bit of code.
* There are problems with previewing Reports as I don't think anyone worked
out how to make the Preview window "pop-up" properly yet. Actually, I think
Dirk Goldgar managed to do this but Access crashed when the Preview window
is closed.
Personally, I never hid the Access application window since I advised my
clients I used Access to develop their applications.
(according to Windows OS). It depends on which Access version you are using
whether you can use one of the later Form Events, i.e. Activate or Current.
IIRC, the Autoexec Macro to open the Form (OpenForm action) & then run the
code (RunCode action) in the link I posted seemed to work fine.
Beware that Access database applications are supposed to work in the Access
window. There are other problems when you hide the Access window, most
notably:
* If an untrapped error happens, the Access Form may disappear from the
screen even though Access is still in the memory. This will be confusing
for your users. If you hide the Access window, make sure that you have
error-trapping in *every* bit of code.
* There are problems with previewing Reports as I don't think anyone worked
out how to make the Preview window "pop-up" properly yet. Actually, I think
Dirk Goldgar managed to do this but Access crashed when the Preview window
is closed.
Personally, I never hid the Access application window since I advised my
clients I used Access to develop their applications.