Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Microsoft: Access Forms FAQ

User Interface Techniques

How Can I completely hide Access so only my forms are visible by Chance1234
Posted: 29 Sep 04

Just came across this in my notes, Time has taken the better of them, so please any questions or improvements please feel free to contact me at Tektips at 5ylac dot biz

Create a New Database

Create a Form  and change its pop up property to True
Create another form called frm_main, this is the form that you want to use.

Add the following code to the first form


Private Declare Function ShowWindow Lib "user32" _
  (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long

Private Sub Form_Open(Cancel As Integer)
  Call ShowWindow(hWndAccessApp, SW_HIDE)
   DoCmd.OpenForm "frm_main", windowmode:=acDialog
End Sub

Private Sub Form_Unload(Cancel As Integer)
Dim lngret As Long
  lngret = ShowWindow(hWndAccessApp, SW_MAXIMIZE)
End Sub

Change the start up properties of the database, to start up with your first form and Voila,

Access without urm Access.  

1. You Cant run reports
2. You need to put a application.close line in on your exit button otherwise Access will still be open if you just use the close form button.

Back to Microsoft: Access Forms FAQ Index
Back to Microsoft: Access Forms Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close