how to hide access window

[bee55]

Dears,
i would like to hide the access window and only startup form should be appear.
your care will be apprciated

 

[Alansidman]

What version of Access are you using. The steps are slightly different depending upon the version.

 

[speakers_86]

Hmm, thats funny I found this thread, because just a few minutes ago, I posted this.

 

[vbaInet]

Your form has to be a Pop-Up and I believe Modal form, plus you will struggle to open more than one form at once. Also, you will struggle to open a report.

Bottom line is don't waste your time trying to implement this.

Attached is an example (Access 2007).

 

[Alansidman]

Here is another option.

http://www.accessforums.net/access/disable-editing-options-18536.html

Alan

 

[speakers_86]

I think you gave us the wrong link Alan. I don't see anything there about the db window.

 

[bee55]

What version of Access are you using. The steps are slightly different depending upon the version.

i use access 2003

 

[Alansidman]

Read this on how to do it.

http://msdn.microsoft.com/en-us/library/aa662934(v=office.11).aspx

 

[evanark]

How do you set up the function to work with 64 systems? I am running window 8 pro and Access 2010. I want just my user forms to show and not the access window.

Here it the code but I don't know how to set the function API to 64 bit users

Private Declare Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long

Changing the "user32" to user64 does not work? Anyone have suggestions on 64 bit systems?

 

[speakers_86]

Is Access 32? If so, I think it is the same.

Edit- I think it is the same either way.

 

[evanark]

yeah my bad, I meant how do I adapt the function to work on a 64 bit OS

 

[evanark]

I found it, I have to use ptrSafe in the function declaration.


Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long
Dim dwReturn As Long