Macro Objects disappeared from Objects Pane (on Left).

Biggles1
Biggles1 used Ask the Experts™
on
Access 2016 application:  Suddenly (I certainly did something dumb) in the Left Objects Pane no more Macros appear.  They should be there, I created them.  Tables, Queries etc... are still there but no Macros!

Also in the older versions, in order to make a specific Form appear on startup, that was done from the "Startup" menu.  How do we do this in 2016.

Thanks

Biggles1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mark EdwardsChief Technology Officer

Commented:
Check and make sure you haven't set them to "hidden" and that you do not have the Nav Pane set to hide hidden objects.
You can also check the MSysObjects table to see if you have any objects of [Type]=-32766 (Macro).  If you do, then you have some, they are just hidden for some reason.  If they are not listed in the MSysobjects table, then you don't have them - they gone!


You use the "Options" item at the bottom of the "File" tab to open the "Current Database" options.  Everything is in there.  You can also start your app with a macro named "autoexec".  You can use both the autoexec macro AND the display form setting on the options, but the Display Form setting runs before the autoexec macro runs.
John TsioumprisSoftware & Systems Engineer

Commented:
For Start press ALT+F11 to make sure that your modules are still there
Biggles1Founder/CEO

Author

Commented:
I found the answer to be that if you have not created a single MACRO then the Macro "group" will not appear.  I created a Macro and the Macro appeared in the left pane.

Thanks for your help.  

This question is closed.
Mark EdwardsChief Technology Officer

Commented:
Oooooohhhhh.  So it was the Macro PANE that was missing (disappeared)..... not your macros - 'cause you didn't HAVE any macros to "loose" in the first place.

Good lesson folks.... terminology is everything when communicating with others!
Biggles1Founder/CEO

Author

Commented:
Yup!  My Bad, so sorry.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial