Bypassing "Startup" mode through code?

[crpjaviman]

Hello everyone,

I am looking into creating code to have a certain list of persons to have access to the DB window once the db is opened. This action would be similar to opening a db with the shift button.

Is there a property setting that can be manipulated to let this happen?

Thanks,
crpjaviman

 

[FancyPrairie]

I was trying to do basically the same thing about a week ago. I tryed using SendKeys to simulate the Shift Key scenerio but couldn't get it to work quite right. You may have better luck. What I did instead was, renamed my AutoExec macro (i.e. MyAutoExec), then, as part of the shortcut properties that launches the database, I added the to the command line "/x MyAutoExec".

Consequently, those people who you don't want to see the db window, add the /x command to the command line. For those people that you want to see the db window, don't add the /x command to the command line.

Eample shortcut property:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" YourDatabase.mdb /x MyAutoExec

 

[BeginnerProgrammer]

See this thread. Hope it helps

 

[BeginnerProgrammer]

See this thread. Hope it helps
thread181-314281

 

[BeginnerProgrammer]

See this thread. Hope it helps
thread181-314281

 

[BeginnerProgrammer]

See this thread. Hope it helps
thread181-314281