Hide Access - api0019.htm

[TinleyParkILGal]

I am trying to apply the following article to one of my databases and I am
not sure how to put what I need to into the on open event of the form. My
database is one table and one form. It is employee's names and phone
extensions. What it does is when you enter a portion of the name or extension
and hit enter, a report opens showing all the records. Eventually I would
like to make a form and subform so that as the user types the portion of the
name the records meeting those qualification will show below the combo box
but I am not there yet. I am now just curious about having the small form sit
on the desktop with Access hidden. Thanks in advance.

http://www.mvps.org/access/api/api0019.htm

I am using the following in my code:

Private Sub Form_Open(Cancel As Integer)

Call fSetAccessWindow

End Sub

 

[Brendan Reynolds]

I haven't personally used that code, but from looking at the web page, I
believe that you need to pass one of the constants declared at the start of
the code, e.g. to hide the Access window I believe your code should be 'Call
fSetAccessWindow(SW_HIDE)'.

You can also use just 'fSetAccessWindow SW_HIDE', that is to say that 'Call'
is not necessary, but if you don't use call you should also not use the
parentheses.