Pop Up Log-In Form only After Enabled ActiveX

[Only4Access]

Hi Forum,



I have created a Log In form (frmLogIn) in Access 2007. When 'Log In' button clicked open 'Main' form.

Access Options >> Current Database >> Display Form. I select frmLogIn. It works fine.

The problem is, this pop up as soon as i open the DB. I only want to pop up after they enabled the activex warning. Same like when we open Northwind DB, we get form like 'Welcome to the Northwind Traders sample database. In order to use this sample, click 'Options...' on the Message Bar and select 'Enable this content'. Alternatively, open the database from a Trusted Location.'

How can i make it. thank you for your help.

[pbaldy]

What I would do is make the display form one that says "If you see this, you need to ...". Then in the timer event of that form, with a very short interval, close it and open the login form. That code will only run if code has been enabled.

[Only4Access]

Thank you Paul. Excellent. I created a start up form in Time Interval used 1, then On Timer Event

DoCmd.Close acForm, Me.Name, acSaveNo
DoCmd.OpenForm "frmLogIn", acNormal, , , , acDialog

Is it OK? or should I add something else? When we open this from Trusted location, still showing Start Up form for nano second Is it possible to completely avoid showing Start Up form, if they open from Trusted locations?

Thank you Paul

[pbaldy]

Well, I don't think you can open it hidden with Access Options. You can use the method Northwind uses, which involves an autoexec macro and testing for trusted.

[Only4Access]

No problem Paul. Your method is OK for me. Thanks a lot for your help.

[pbaldy]

Happy to help!