Open 2 forms on first DB run

[SteveC24]

Hi,

I have this database for fishkeepers that stores all their information about their fish/tanks etc.

Anyway, I was wondering if it would be possible to make a form that would come up the first time the DB was run, presenting 2 buttons for the user to open other forms already in the database.

In order for the database to work, the user must enter at least 1 shop and at least 1 tank into the database, before using anything else....so I need this form to come up the first time the database is run.

Is this possible? In case this involves VB (which is probably will!) I no nothing - so simple things please!!!

Thanks very much

 

[pcEars]

Have you tried to create a SwitchBoard?

Go to Tools|Database Utilities|Switchboard Manager

Is that what you want?

 

[SteveC24]

No. I wanted it to ONLY run the first time the database was run, then not again.

Thanks, I have got it to work now.

 

[pcEars]

Then maybe try a new form with 2 command buttons to select your other forms. The options are presented when you add the buttons. [Be sure you've selected the Wizards button near the left of the toolbar]

Then go to Tool|Statup|Display Form and select your new form. When you start the db it will open up. Once closed, it must be opened manually.

More what you meant?

 

[SteveC24]

No, not really, I mean it should display the first time the database is ever used...then never display again.

I got some help from a friend, and they showed me how to do it using a table.

Basically, the table contains one field, called run_before, with a possible value of either 0 or 1.

When the database is loaded, it checks this number, if it is 0, it displays the form, if it is anything else, it doesn't display the form.

Thanks anyway!

 

[ghudson]

What if the user needs to modify their original (1 shop and 1 tank) selections? Just sounds odd that they have to make this selection the first time the db is opened and never again? Will future design updates to the db cause a problem with that first selection?

 

[pcEars]

Glad to hear I wasn't the only one that didn't quite get that!

 

[SteveC24]

Sorry, as usual, my explainations are rushed and incomprehensible!

You user can add or edit these details later if they wish, and they will probably need to.

My problem was, when the user starts up, their immediate reaction will be to add a fish. Before they can do that, they need to add at least 1 shop and 1 tank. This is because when they add a fish, they are required to fill in which tank the fish is in, and where it was bought from.

I hope I have explained better this time!