Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Nov 2005
    Location
    Br. Columbia, Canada
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Viewing Data on a Form (2003)

    I am either missing something very simple or am going totally insane! <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

    I have entered 15 records into our form and needed to go back and edit a certain record. It's set up to display the previous records and most of the time it will. One time out of three when you open the database and open the form, it will not show that there are already records in the form. If I open the form in design view, go into properties and change the DataEntry from No to Yes then back to No, click save, close the database and reopen it, the form will display the previous records again. Once the database has opened not displaying the previous records it will not display them until you have gone through this procedure.

    I have deleted all of the irrelevant "stuff" out of the database in order to try and get it small enough to post but after deleteing everything but one table and one form, doing the compact and repair, converting it to access 97 and zipping it, its still just over 200kb.

    Any suggestions that can be offered are greatly appreciated.

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Data on a Form (2003)

    Wow....that's a heck of a form...are there any images in the database, reports or otherwise? We can fill in some dummy data in your table, but aside from that, can you give more data on your form? Is it a continuous form; a datasheet?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  3. #3
    Lounger
    Join Date
    Nov 2005
    Location
    Br. Columbia, Canada
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Data on a Form (2003)

    Ok...I

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Viewing Data on a Form (2003)

    As far as I can tell, the form itself is Ok and will show your existing records.

    However, the switchboard command you use to open the form, says to open it in DataEntry mode. When you open a form in data entry mode, you don't see the existing records.
    Regards
    John



  5. #5
    Lounger
    Join Date
    Nov 2005
    Location
    Br. Columbia, Canada
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Data on a Form (2003)

    Ok. Where would i change that though? Im really a very beginner user to the program and I feel like im a little bit over my head with this one.

    K

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Viewing Data on a Form (2003)

    In the table Switchboard Items, change the Command on the second line from 2 to 3.

    Do youi know how to find that table?
    Regards
    John



  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Viewing Data on a Form (2003)

    Alternatively, select Tools | Database Utilities | Switchboard Manager.
    Select the Switchboard page that contains the entry for your form.
    Click Edit...
    Select the entry for your form.
    Click Edit...
    Change the Command from "Open form in data entry mode" to "Open form in edit mode".
    Click OK.
    Repeat for other forms if necessary.

  8. #8
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Viewing Data on a Form (2003)

    I never use Access Switchboards, so I completely forgot about the Switchboard Manager. I have not looked at it for years.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •