Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing a button from record selector (Access 2000)

    Is there a way to remove only the add new record button on a form? I want to only have the navigation buttons on the bottom of the form just not the add new record button. I know I can make my own buttons but I wondered if this was possible. Thanks..

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Removing a button from record selector (Access 2000)

    The answer is No. Your options are to either set form's Navigation Buttons property to No, and create your own buttons, or use the built-in buttons and set the form's Allow Additions property to No. The latter option will prevent users from adding new records, but the Add New Record button will still be visible (though disabled).

    HTH

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Removing a button from record selector (Access 2000)

    In further reply, you may already know how to do this, but for a sample database you can download that demonstrates the use of customized navigation buttons (including the Record n of.... Records box) see this link:

    Roger's Access Library - RecordNavigation.mdb

    If you download the sample db, see NavigationSingleForm2 for example of form without the Go To New Record button. Note: You will probably get Type Mismatch errors when initially opening db (A2K version) & running forms, due to recordset variable declarations not specifying the DAO type library. To fix this, open VB Editor do a Search & Replace (CTRL + H). For "Find What" specify:

    Dim rs As Recordset

    For "Replace With" specify:

    Dim rs As DAO.Recordset

    Select Current Project option, then Replace All. Close dialog and Save Project & recompile. This should fix the errors. You should be able to adapt the techniques demonstrated in the sample forms for your own projects.

    HTH

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Removing a button from record selector (Access 2000)

    If you set the form's AllowAdditions property to false, the Add New button will be disabled. Is that enough?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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