Hide Access Window when opening database via Hyperlink (1 Viewer)

LittleE

New member
Local time
Today, 06:36
Joined
Aug 7, 2015
Messages
7
Does anyone know how to hide the access window when opening a database from a hyperlink on another database?

I can get the databases to open with the Access window hidden individually, but when using the hyperlinks it doesn't work.

Any suggestions would be greatly appreciated.

I'm using Access 2007.
 

Ranman256

Well-known member
Local time
Today, 09:36
Joined
Apr 9, 2015
Messages
4,339
put this code below in a module,

then in a macro AUTOEXEC
RunCode HideDb()
openform "mainmenu"

Code:
Public Function HideDB()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Function
 

LittleE

New member
Local time
Today, 06:36
Joined
Aug 7, 2015
Messages
7
Thanks for your reply.
It still doesn't appear to work though - the access main window still appears in the background.

In the module I included:
Option Compare Database
Option Explicit

I just changed the "mainmenu" in the macro to "MAIN PAGE" as per my naming convention.
 

Ranman256

Well-known member
Local time
Today, 09:36
Joined
Apr 9, 2015
Messages
4,339
it DOES work. I use it in all my db for my users.

are you using anything in the STARTUP property of the database?
 

LittleE

New member
Local time
Today, 06:36
Joined
Aug 7, 2015
Messages
7
I have the "MAIN PAGE" set to open at startup....
 

optimuz

New member
Local time
Today, 06:36
Joined
Jun 25, 2016
Messages
3
hi im from Sri Lanka... just got this sorted out on my own...

annnnndddd it works clean...

heres how..

1. Create a macro just go to Create--> macro
2. in the action field type or find using the drop down list "Run Command"
3. in the action arguments form below ( not right after the action field, just look below) in the "Command" field select "appMinimize"
4.then in the action field find a second value "openForm"
5. in the arguments field you can give your desired form to pop up, it's state, any filters,windows state and all.
6. save all & rename the Macro as AutoExec
7. happily close your database and open... BOOM... you got the miracle in simple steps..
8. if anyone ran to a situation where nothing could editable again... please open your database while pressing the SHIFT KEY as a life saver.
9. and i recomend you to first create a good set of navigation amoung your forms so that it will be another application like database.
10. YOU KNOW WHAT... I am a NewBee .... hope you like this

Thanks
 

Users who are viewing this thread

Top Bottom