A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hiding Access



 
 
Thread Tools Display Modes
  #1  
Old November 18th, 2007, 09:37 AM posted to microsoft.public.access
Jessybloke
external usenet poster
 
Posts: 9
Default 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  
Old November 18th, 2007, 10:25 AM posted to microsoft.public.access
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default 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  
Old November 18th, 2007, 10:56 AM posted to microsoft.public.access
Jessybloke
external usenet poster
 
Posts: 9
Default 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  
Old November 18th, 2007, 11:21 AM posted to microsoft.public.access
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default 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  
Old November 18th, 2007, 11:14 PM posted to microsoft.public.access
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default 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  
Old November 18th, 2007, 11:23 PM posted to microsoft.public.access
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default 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  
Old July 8th, 2009, 12:13 PM posted to microsoft.public.access
Joe Coulter
external usenet poster
 
Posts: 24
Default 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  
Old July 8th, 2009, 12:35 PM posted to microsoft.public.access
John Spencer
external usenet poster
 
Posts: 2,364
Default 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  
Old July 8th, 2009, 01:43 PM posted to microsoft.public.access
Joe Coulter
external usenet poster
 
Posts: 24
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.