Problem with startup

[dsomers]

I'm having a problem with my startup screen that basically gives information and then has a Don't display on startup check box and an OK button that is supposed to close the startup screen and load the Switchboard form. However, its not doing this when I click ok or check the check box.

I've attached a copy of the db. Could somebody take a look and see what I'm doing wrong? I've tried to follow the Northwinds example but get some error about can't find the function names.

Thanks!
David Somers

 

[WayneRyan]

David,

You have to use Tools --> Startup
to define your Startup form.

In the OK button of your Startup form, I put:

DoCmd.Close ' Close Startup
DoCmd.OpenForm "SwitchBoard"

The "Don't show this in the future" does not work because
it is not bound to a table and thus is not saved. The value
should be stored in a table.

Wayne

 

[dsomers]

How was it done in the Northwinds sample db?

Thanks!
David Somers

 

[WayneRyan]

David,

To tell you the truth I hadn't look at NorthWind. The check box
is not bound to a table. Look at their code in the StartUp
code module.

Wayne

 

[Oldsoftboss]

Northwinds is one of the most complicated ways of turning on/off the start up screen I could imagine. If you study the code you will see it creates a property in the Db application and sets it to no.

The easiest way to achive what you are trying to do is create a 1 field (yes/No) table and have it as the record source of your start up screen.

In the Load event of the form put

If me.checkbox = true then

Docmd.OpenForm "YourFormName"
Docmd.Close acForm , Me.Name

End if

HTH
Dave