1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Access 2000: Open Forms In "Read Only"...

Discussion in 'Business Applications' started by keith10456, Sep 15, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    I'm using Access 2K... I created a macro that opens one of my forms in "Read Only" mode. The problem is, if the underlying table doesn't contain any data, Access displays a blank screen!

    I know the problem is with the "Read Only" status because if I change it so it opens in "Add" or "Edit" mode, the form opens fine.

    Is there any way around this?
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Read only?
    That shouldn't be done by the setting on the form.
    That should be done by access to tables...
     
  3. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    I made the form read only so end-users can see the data in "form" view, but not be able to edit it.
     
  4. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    So you make the data read-only, not the form...
     
  5. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Sorry. Maybe I'm being obtuse. :)
     
  6. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    Are you referring to "Data Mode" in the macro? If so, that's what I did. If not, please explain.
     
  7. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    The macro is as follows:

    [Action] = OpenForm
    Form Name = "The Form's Name"
    View = Form
    Where Condition = Empty (Blank)
    Data Mode = Read Only
    Window Mode = Normal
     
  8. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    k.
    There's a property on forms for "data entry".
    Set it to NO
    Set allow edits, allow deletions, allow additions all to NO

    What's the code for?
    :)
     
  9. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    Dreamboat... I tried it but it didn't work. When I set the "Data Mode" on the macro to "Add" or "Edit", it overrides the settings I placed in the form property (as you suggested). If I leave the "Data Mode" empty/blank, the form opens as a empty screen (no fields/text is visible).

    The macro part of a menu I created. Upon an end-user clicking "Accounts" in the menu, the macro is run (to open the vendor accounts form).
     
  10. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    I didn't say anything about a macro.
    I said the PROPERTIES of the FORM.
    :)
     
  11. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    I know... I changed the properties of the form. Same result...

    I mentioned the macro because that is what's opening the form.
     
  12. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    And the form, when opened manually, still allows for changes to be made tho your form properties say no?

    Then there is something not right.
    LOL!!

    I mean...we must have missed something here...
     
  13. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/274374

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice