If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hiding Access
Is the any way that I can hide the access window to just leave up the form,
but on a certain key stroke for it to reappear. I am a basic user so if you answer please please keep it simple Thank you -- Jessybloke in the UK |
#2
|
|||
|
|||
Hiding Access
Hi Jessy,
I'm not sure this is something that a basic user should be attempting, but here you go: Manipulate Access Window http://www.mvps.org/access/api/api0019.htm Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Jessybloke" wrote: Is the any way that I can hide the access window to just leave up the form, but on a certain key stroke for it to reappear. I am a basic user so if you answer please please keep it simple Thank you -- Jessybloke in the UK |
#3
|
|||
|
|||
Hiding Access
Tom many thanks for this but just a quick question how do I make it work
Thanks again -- Jessybloke in the UK "Tom Wickerath" wrote: Hi Jessy, I'm not sure this is something that a basic user should be attempting, but here you go: Manipulate Access Window http://www.mvps.org/access/api/api0019.htm Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Jessybloke" wrote: Is the any way that I can hide the access window to just leave up the form, but on a certain key stroke for it to reappear. I am a basic user so if you answer please please keep it simple Thank you -- Jessybloke in the UK |
#4
|
|||
|
|||
Hiding Access
Create a new module. If you do not see the two words "Option Explicit" as the
second line of code in this new module, then follow the instructions shown in this "Gem Tip" to configure your VBA editor: Always Use Option Explicit http://www.access.qbuilt.com/html/ge...tml#VBEOptions While you are there, I suggest deselecting the options to Compile on Demand. Copy the code shown in the page, and paste it into your new module. Save the module, giving it a name *different* from the name of the function that you just pasted. For example, you might name it: basManipulateAccessWindow Click on Debug Compile {ProjectName}. Hopefully, your code will compile without any errors. You'll know right away if you get a compile error. If the option appears to be greyed out the second time you try it, then this is a good sign--it means that your code compiled without an error. To test it, try opening a switchboard type form first, so that you'll have a form open. Then press the Ctrl G at the same time, to open the Immediate Window. Copy the following command shown in this procedure, and paste it into the Immediate Window: ?fSetAccessWindow(SW_HIDE) Then hit the Enter key and see what happens. If you like the effect after you've had a chance to experiment with it, then you could add a call to this function in an Autoexec macro. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Jessybloke" wrote: Tom many thanks for this but just a quick question how do I make it work Thanks again -- Jessybloke in the UK |
#5
|
|||
|
|||
Hiding Access
As a follow-up to this discussion, I found that when I actually tried my
suggestion that it did not work. Sorry about that. As you might guess, I have never attempted to hide the Access application window in any of my apps. It turns out that in later versions of Access (after this code was posted several years earlier), that one must apparently set both the Modal and Popup properties to Yes for all forms, and then use code like this: Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub This seems like too much of a PITA for me to want to deal with! I'd like to refer you to an excellent discussion on this topic in the Utter Access discussion group. Pay particular attention to the posts made by "AccessJunkie" (Jeff Conrad) and "mishei" (John Mishefske). Jeff makes some excellent points in his second reply as to why you may want to reconsider implementing this functionality. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html |
#6
|
|||
|
|||
Hiding Access
And here's the link to the posting on Utter Access that I forgot to include:
http://www.utteraccess.com/forums/sh...Number=1164944 Time for me to go grab another cup of coffee! Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Tom Wickerath" wrote: As a follow-up to this discussion, I found that when I actually tried my suggestion that it did not work. Sorry about that. As you might guess, I have never attempted to hide the Access application window in any of my apps. It turns out that in later versions of Access (after this code was posted several years earlier), that one must apparently set both the Modal and Popup properties to Yes for all forms, and then use code like this: Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub This seems like too much of a PITA for me to want to deal with! I'd like to refer you to an excellent discussion on this topic in the Utter Access discussion group. Pay particular attention to the posts made by "AccessJunkie" (Jeff Conrad) and "mishei" (John Mishefske). Jeff makes some excellent points in his second reply as to why you may want to reconsider implementing this functionality. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html |
#7
|
|||
|
|||
Hiding Access
Tom
I used your suggestion to hide the application window using :- Manipulate Access Window http://www.mvps.org/access/api/api0019.htm Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub It works just great, however, now I cant get it back when I want to carry out additions or modifications to the database, can you tell me how to do this please. Thanks Joe "Tom Wickerath" wrote: And here's the link to the posting on Utter Access that I forgot to include: http://www.utteraccess.com/forums/sh...Number=1164944 Time for me to go grab another cup of coffee! Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Tom Wickerath" wrote: As a follow-up to this discussion, I found that when I actually tried my suggestion that it did not work. Sorry about that. As you might guess, I have never attempted to hide the Access application window in any of my apps. It turns out that in later versions of Access (after this code was posted several years earlier), that one must apparently set both the Modal and Popup properties to Yes for all forms, and then use code like this: Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub This seems like too much of a PITA for me to want to deal with! I'd like to refer you to an excellent discussion on this topic in the Utter Access discussion group. Pay particular attention to the posts made by "AccessJunkie" (Jeff Conrad) and "mishei" (John Mishefske). Jeff makes some excellent points in his second reply as to why you may want to reconsider implementing this functionality. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html |
#8
|
|||
|
|||
Hiding Access
Try holding down the shift key while you open the application. Unless
you have done something to the AllowByPassKey property that should open your database application in design mode. '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === Joe Coulter wrote: Tom I used your suggestion to hide the application window using :- Manipulate Access Window http://www.mvps.org/access/api/api0019.htm Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub It works just great, however, now I cant get it back when I want to carry out additions or modifications to the database, can you tell me how to do this please. Thanks Joe "Tom Wickerath" wrote: And here's the link to the posting on Utter Access that I forgot to include: http://www.utteraccess.com/forums/sh...Number=1164944 Time for me to go grab another cup of coffee! Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Tom Wickerath" wrote: As a follow-up to this discussion, I found that when I actually tried my suggestion that it did not work. Sorry about that. As you might guess, I have never attempted to hide the Access application window in any of my apps. It turns out that in later versions of Access (after this code was posted several years earlier), that one must apparently set both the Modal and Popup properties to Yes for all forms, and then use code like this: Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub This seems like too much of a PITA for me to want to deal with! I'd like to refer you to an excellent discussion on this topic in the Utter Access discussion group. Pay particular attention to the posts made by "AccessJunkie" (Jeff Conrad) and "mishei" (John Mishefske). Jeff makes some excellent points in his second reply as to why you may want to reconsider implementing this functionality. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html |
#9
|
|||
|
|||
Hiding Access
Thankyou John worked like a treat.
Regards Joe "John Spencer" wrote: Try holding down the shift key while you open the application. Unless you have done something to the AllowByPassKey property that should open your database application in design mode. '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === Joe Coulter wrote: Tom I used your suggestion to hide the application window using :- Manipulate Access Window http://www.mvps.org/access/api/api0019.htm Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub It works just great, however, now I cant get it back when I want to carry out additions or modifications to the database, can you tell me how to do this please. Thanks Joe "Tom Wickerath" wrote: And here's the link to the posting on Utter Access that I forgot to include: http://www.utteraccess.com/forums/sh...Number=1164944 Time for me to go grab another cup of coffee! Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Tom Wickerath" wrote: As a follow-up to this discussion, I found that when I actually tried my suggestion that it did not work. Sorry about that. As you might guess, I have never attempted to hide the Access application window in any of my apps. It turns out that in later versions of Access (after this code was posted several years earlier), that one must apparently set both the Modal and Popup properties to Yes for all forms, and then use code like this: Private Sub Form_Open(Cancel As Integer) Me.Visible = True DoEvents fSetAccessWindow SW_HIDE End Sub This seems like too much of a PITA for me to want to deal with! I'd like to refer you to an excellent discussion on this topic in the Utter Access discussion group. Pay particular attention to the posts made by "AccessJunkie" (Jeff Conrad) and "mishei" (John Mishefske). Jeff makes some excellent points in his second reply as to why you may want to reconsider implementing this functionality. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html |
Thread Tools | |
Display Modes | |
|
|