Results 1 to 2 of 2
  1. #1
    kfitzpa1 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2013
    Posts
    2

    StopMacro use with embedded macro to open a form with a password


    I have an embedded macro to open a password protected form. The password works and using an incorrect password presents the error message I defined, but when the user clicks on OK the form still opens. It's as if the embedded OpenForm Macro is still executing. Is there any way to stop the macro from executing under these circumstances? I tried using the code in the attachment, but then the password code didn't work at all. Thanks!
    Attached Files Attached Files
    Last edited by kfitzpa1; 12-03-2013 at 09:13 AM. Reason: Add attachment

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Can you place the password verification in a function and have the function call the Macro if the password is validated? I don't work with Macros often so I am not sure how to stop their execution.
    Here is a link that mentions "Stop Macro" action
    http://office.microsoft.com/en-us/ac...001226305.aspx

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

Similar Threads

  1. Embedded macro on form
    By trout in forum Macros
    Replies: 7
    Last Post: 07-09-2013, 01:13 PM
  2. Replies: 2
    Last Post: 06-30-2013, 09:59 AM
  3. Replies: 3
    Last Post: 02-15-2013, 03:36 PM
  4. Replies: 0
    Last Post: 07-13-2010, 07:45 AM
  5. Run Embedded Macro
    By smikkelsen in forum Forms
    Replies: 0
    Last Post: 07-07-2010, 09:44 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