Hide Access Window when opening database via Hyperlink

[LittleE]

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]

put this code below in a module,

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

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

 

[LittleE]

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]

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]

I have the "MAIN PAGE" set to open at startup....

 

[optimuz]

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