Switchboard and Forms

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jnice814
    New Member
    • Oct 2007
    • 8

    Switchboard and Forms

    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
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Originally posted by 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
    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.

    Comment

    • nico5038
      Recognized Expert Specialist
      • Nov 2006
      • 3080

      #3
      Originally posted by 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
      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)

      Comment

      • Rabbit
        Recognized Expert MVP
        • Jan 2007
        • 12517

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

        Comment

        • nico5038
          Recognized Expert Specialist
          • Nov 2006
          • 3080

          #5
          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)

          Comment

          • ADezii
            Recognized Expert Expert
            • Apr 2006
            • 8834

            #6
            Originally posted by nico5038
            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.

            Comment

            • nico5038
              Recognized Expert Specialist
              • Nov 2006
              • 3080

              #7
              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)

              Comment

              Working...