Results 1 to 4 of 4
  1. #1
    greatwhite is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Location
    Ottawa, ON
    Posts
    56

    Cannot find Macros??


    So the DB I have inherited appears to have some hidden Macros which I cannot seem to locate. I know they are there because they seem to be used for updating the Audit Table. If I change any data a line is definitely entered into the table. My MS DB consists of a Separate Front and Back-end. I have searched all over the properties of each form and cannot find the macro. I have looked at the back-end and cannot seem to locate any. At this point I seem to be running out of ideas as to where it may be hidden.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    D you see anything in the Macros objects? Set objects visibility property.

    If you press Alt-F11, does it enter VBE where all the code & macros are?
    modules?

    Do the macros run? If not and you cannot see them, they may have been erased.
    sometimes an crash error occurs and it trashes ALL code.

  3. #3
    greatwhite is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Location
    Ottawa, ON
    Posts
    56
    I think I just found some on the back end in the Data Macro Manager, But it only gives me a delete option and a rename option on only one. At least I think these are all Macro's. How can I view them.



    Click image for larger version. 

Name:	Macro.PNG 
Views:	8 
Size:	57.6 KB 
ID:	38001

  4. #4
    greatwhite is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Location
    Ottawa, ON
    Posts
    56
    OK I got it when I click on to create a new Macro it show me the old one. now I can see everything.

    I hate macro's so much easier to find and trouble shoot if everything is just written in plain old code.

    Thank you

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

Similar Threads

  1. Replies: 6
    Last Post: 04-16-2018, 09:15 PM
  2. Help with VBA or Macros please
    By Simonhtc4 in forum Access
    Replies: 9
    Last Post: 04-27-2017, 03:53 AM
  3. Macros
    By Capri Pruitt in forum Access
    Replies: 1
    Last Post: 09-13-2010, 10:36 PM
  4. VBA or Macros
    By mastromb in forum Forms
    Replies: 6
    Last Post: 01-03-2010, 04:46 PM
  5. Macros
    By kfhai in forum Access
    Replies: 0
    Last Post: 04-17-2009, 08:28 AM

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