Results 1 to 2 of 2
  1. #1
    EliOklesh is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    7

    Macro stops working for 'USER' group

    I'm working on a project using Access 2007. This db is in .mdb format to allow for assigning user permissions, etc.

    On one form I have a macro ("m_new") set to run OnLoad, which is basically just a GoToRecord command taking the form to the NEW record.

    When I log in from the 'USER' group I receive an error saying I am "not allowed to go to that record."

    I'm certain this has something to do with the macro permissions for those in the USER group, but I've tried everything and can't get it to work.



    Any thoughts?

    Thanks!
    eli

  2. #2
    EliOklesh is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    7
    NEVERMIND! I just scrapped the macro altogether and used a DoCmd.GoToRecord command for the OnLoad for the form.

    SOLVED. By myself... Sorry to waste your time!

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

Similar Threads

  1. Replies: 7
    Last Post: 08-19-2011, 02:57 PM
  2. Trying to sum a group of records not working
    By shelbsassy in forum Reports
    Replies: 0
    Last Post: 04-10-2011, 07:52 PM
  3. "And" stops functions from working
    By JimmD43 in forum Programming
    Replies: 5
    Last Post: 03-19-2011, 11:10 AM
  4. Change a User's Group
    By Ted C in forum Security
    Replies: 1
    Last Post: 07-16-2010, 09:20 AM
  5. Having - Like stops working
    By tdalber in forum Queries
    Replies: 0
    Last Post: 02-03-2009, 04:30 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