Tags: access, additions, additionsno, database, form, microsoft, mysql, oracle, resolutions, rfi, scroll, scrolls, sql, user

Allow additions=no (sometimes)

On Database » Microsoft Access

3,049 words with 3 Comments; publish: Sat, 07 Jun 2008 22:02:00 GMT; (25078.13, « »)

I have a form (RFI Resolutions) that I want to open with "Allow Additions"

off, so when the user scrolls through, he cannot scroll to a "new record".

Works great when I open the form on its own. But when I open it from another

form, using a button and a macro to do so, the new record button (the with

the * on it) is enabled even though the property still says no.

What am I missing?

Thanks

All Comments

Leave a comment...

  • 3 Comments
    • "paulpenta" <paulpenta.ms-access.itags.org.discussions.microsoft.com> wrote in message

      news:15D3D3EB-1D12-4131-964B-4B8E7FD47C46.ms-access.itags.org.microsoft.com

      > I have a form (RFI Resolutions) that I want to open with "Allow

      > Additions" off, so when the user scrolls through, he cannot scroll to

      > a "new record". Works great when I open the form on its own. But when

      > I open it from another form, using a button and a macro to do so, the

      > new record button (the with the * on it) is enabled even though the

      > property still says no.

      > What am I missing?

      What parameters are you specifying for the OpenForm action in the macro?

      If you specify "Edit", you'll override the form's settings and open it

      in full edit mode. If you leave the argument blank, the form's settings

      should rule.

      Dirk Goldgar, MS Access MVP

      www.datagnostics.com

      (please reply to the newsgroup)

      #1; Sat, 07 Jun 2008 22:03:00 GMT
    • On Mon, 3 Oct 2005 09:15:04 -0700, paulpenta wrote:

      > I have a form (RFI Resolutions) that I want to open with "Allow Additions"

      > off, so when the user scrolls through, he cannot scroll to a "new record".

      > Works great when I open the form on its own. But when I open it from another

      > form, using a button and a macro to do so, the new record button (the with

      > the * on it) is enabled even though the property still says no.

      > What am I missing?

      > Thanks

      You left out the most important part.

      What does your macro actually do (or say).

      Having already set the form [RFI Resolutions] AllowAdditions property

      to No, the following Macro works for me:

      Form Name RFI Resolutions

      View Form

      Window view Normal

      Fred

      Please respond only to this newsgroup.

      I do not reply to personal e-mail

      #2; Sat, 07 Jun 2008 22:04:00 GMT
    • PERFECT!

      Thanks, Dick

      "Dirk Goldgar" wrote:

      > "paulpenta" <paulpenta.ms-access.itags.org.discussions.microsoft.com> wrote in message

      > news:15D3D3EB-1D12-4131-964B-4B8E7FD47C46.ms-access.itags.org.microsoft.com

      > What parameters are you specifying for the OpenForm action in the macro?

      > If you specify "Edit", you'll override the form's settings and open it

      > in full edit mode. If you leave the argument blank, the form's settings

      > should rule.

      > --

      > Dirk Goldgar, MS Access MVP

      > www.datagnostics.com

      > (please reply to the newsgroup)

      >

      >

      #3; Sat, 07 Jun 2008 22:05:00 GMT