Switchboard and Forms

[jnice814]

Hello,
I am trying to build a simple database and have the following questions:

I created a switchboard to be used to open a form where data would be entered. I also set the switchboard as a default in hopes that when I open the database, the switchboard would be the first page to appear. However, this is not happening. How do I get the switchboard to be the first item that appears upon opening the database?

I also need to create a form that allows multiple people to enter data, sometimes to the same record. At this point, this is not happening. How do I get changes to my form to update, not replace?

Thank you much

[Rabbit]

Hello,
I am trying to build a simple database and have the following questions:

I created a switchboard to be used to open a form where data would be entered. I also set the switchboard as a default in hopes that when I open the database, the switchboard would be the first page to appear. However, this is not happening. How do I get the switchboard to be the first item that appears upon opening the database?

I also need to create a form that allows multiple people to enter data, sometimes to the same record. At this point, this is not happening. How do I get changes to my form to update, not replace?

Thank you much

What do you mean by you set the switchboard as default?

You can't have multiple people editing the same record at the same time. Not in access. I suppose you could try some tricky VBA stuff with an unbound form. But it would be complicated.

[nico5038]

Hello,
I am trying to build a simple database and have the following questions:

I created a switchboard to be used to open a form where data would be entered. I also set the switchboard as a default in hopes that when I open the database, the switchboard would be the first page to appear. However, this is not happening. How do I get the switchboard to be the first item that appears upon opening the database?

I also need to create a form that allows multiple people to enter data, sometimes to the same record. At this point, this is not happening. How do I get changes to my form to update, not replace?

Thank you much

Open the Tools/Startup menu to define the Switchboard form as the one to show when Access startsup.

Multiple users can update the same record (there's no difference between update and replace). Only when one user starts and another user updates the record in the meantime (so-called concurrent update), then the last user trying to save the record will be warned and asked or the changed data can be overwritten or not.

Nic;o)

[Rabbit]

I guess I was wrong. I thought there was only record level tracking.

[nico5038]

Hi Rabbit, Access does handle concurrent update when the database is opened in "Shared" mode. Using "Exclusive" mode will limit updates to the first user that logs in and this isn't to be recommended when multiple persons need to enter data :-)

Nic;o)

[ADezii]

Open the Tools/Startup menu to define the Switchboard form as the one to show when Access startsup.

Multiple users can update the same record (there's no difference between update and replace). Only when one user starts and another user updates the record in the meantime (so-called concurrent update), then the last user trying to save the record will be warned and asked or the changed data can be overwritten or not.

Nic;o)

Nico, doesn't Concurrent Updates depend on the Record Locking Strategy in place at the time? There will definitely be cases where multiple Users cannot Update the same Record.

[nico5038]

Correct, that's the "second level" you'll have to look into. Just started with the "main" switch and skipped the entire story to keep the comment short:-)

Nic;o)