Results 1 to 11 of 11
  1. #1
    jajoju is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    9

    Smile Add an action

    Hi ,
    I am not very familiar with macros. I would like to know how to add '' ALLOWEDITS = FALSE '' in a macro

    Click image for larger version. 

Name:	1.jpg 
Views:	23 
Size:	63.1 KB 
ID:	26504
    Thank you Jacques

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    this is a form property, or a query property,
    NOT an action.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The action would be SetProperty.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    jajoju is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    9

    Macro Add action

    Quote Originally Posted by pbaldy View Post
    The action would be SetProperty.
    Thank you for your help

    ... but it doesn't work ,,,

  5. #5
    jajoju is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    9
    HI sir,

    Do I have to go at the Macro or the Object property ?

    Thank you

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by jajoju View Post
    Thank you for your help

    ... but it doesn't work ,,,
    What...exactly...doesn't work?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    jajoju is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    9
    SetProperty

  8. #8
    jajoju is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    9
    Hi
    How do I use the macro to tell the form this property : '' AllowEdits = False ''

    Thanks

  9. #9
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    In 2007, the OpenForm action accepts arguments, one of which is Data Mode, with 3 options. Look at the bottom of the macro builder window when you're working with the OpenForm action.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  10. #10
    jajoju is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2016
    Posts
    9
    Quote Originally Posted by Micron View Post
    In 2007, the OpenForm action accepts arguments, one of which is Data Mode, with 3 options. Look at the bottom of the macro builder window when you're working with the OpenForm action.
    OpenForm ?? The form is already open ... In Visual Basic I would add a line '' Allowedits = false ''

    But how do I add this property in the Integrated Macro ( macro for my command button ) ??? Where do I go ?? ( see image )


    Thank you again

    Click image for larger version. 

Name:	1.jpg 
Views:	9 
Size:	63.3 KB 
ID:	26524

  11. #11
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Sorry, not so good reading French and transposing that to what I know. My meaning was, why wouldn't you just use a macro to open the form as you wish - not allowing edits?
    If the form already has to be open, then I would give the same answer as in post #3 and would not expect the same answer you gave in post #7. You need to be more forthcoming with information as to what that means, what happens (or not) that makes you say it doesn't work, otherwise I don't think we can come up with a fix - at least I can't. The suggested action is supposed to work on the active form, so if you're running the macro when the form is not the active window, then no, it will not work.

    Your other choice, I suppose, would be to create a macro that runs code to prevent edits:
    Sub LockForm()
    Forms!frmYourFormName.AllowEdits = False
    End Sub

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Not in list action
    By Derrick T. Davidson in forum Programming
    Replies: 3
    Last Post: 05-22-2015, 05:46 AM
  2. sendkey action
    By sdel_nevo in forum Programming
    Replies: 9
    Last Post: 03-25-2015, 10:33 AM
  3. Can't run this action???
    By wwg77 in forum Programming
    Replies: 2
    Last Post: 02-02-2011, 03:22 PM
  4. Macro Action
    By Bakar in forum Forms
    Replies: 1
    Last Post: 01-05-2011, 12:38 PM
  5. PrintOut action
    By svcghost in forum Programming
    Replies: 11
    Last Post: 10-05-2010, 05:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums