show only form

  • Thread starter Thread starter Dsperry101 via AccessMonster.com
  • Start date Start date
D

Dsperry101 via AccessMonster.com

Hello

Is it possible to start access and display only the
form and not the access window ? I know about the
startup options and autoexec but I can't find a way
to show only my form and not theaccess task window.
 
Dsperry101 said:
Hello

Is it possible to start access and display only the
form and not the access window ? I know about the
startup options and autoexec but I can't find a way
to show only my form and not theaccess task window.
Click to expand...

Code at the link below allows for this. Note that it places a lot of
restrictions on what you can do in your app.

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

Did what the instructions said but it doesn't hide the
access window
 
Dsperry101 said:
Rick

Did what the instructions said but it doesn't hide the
access window
Click to expand...

Did you follow all of the instructions? Your form has to have its Popup
property set to true and the behavior is a bit different depending on the
version of Access. In Access 97 I found that I had to put the code into the
Timer event with a small interval and have the code set the TimerInterval to
zero so it only runs once. Using the code in the Open event didn't work (though
it did in Acess 2000 and newer).
 
Rick

I put the code in a separate module I called
hide access ,made the form popup
and put in the following code:

Private Sub Form_Open(Cancel As Integer)
Dim ncmdshow, returnval As Long
ncmdshow = 0
fSetAccessWindow (ncmdshow)
End Sub

What am I doing wrong (in access 2000) ?
 
Dsperry101 said:
Rick

I put the code in a separate module I called
hide access ,made the form popup
and put in the following code:

Private Sub Form_Open(Cancel As Integer)
Dim ncmdshow, returnval As Long
ncmdshow = 0
fSetAccessWindow (ncmdshow)
End Sub

What am I doing wrong (in access 2000) ?
Click to expand...

Do you get an error or just no effect?
 
Rick

I get the error generated by the code:
"Cannot hide Access unless " _
& "a form is on screen"
I tried putting the code in other events of the form to
be sure it was the form with focus, I even called
the code using a button on the form.

Rick said:
Rick
Click to expand...
[quoted text clipped - 9 lines]
What am I doing wrong (in access 2000) ?
Click to expand...

Do you get an error or just no effect?
Click to expand...
 
Dsperry101 said:
Rick

I get the error generated by the code:
"Cannot hide Access unless " _
& "a form is on screen"
I tried putting the code in other events of the form to
be sure it was the form with focus, I even called
the code using a button on the form.
Click to expand...

Sorry, I am not that familiar with the "guts" of that code. As I stated, I
did find that the Open or Load event would not work for me in Access 97, but
when using the Timer event it did and using a separate button as you tried
should certainly work.
 
Back
Top