Link to home
Start Free TrialLog in
Avatar of Biggles1
Biggles1Flag for United States of America

asked on

Macro Objects disappeared from Objects Pane (on Left).

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
Avatar of Mark Edwards
Mark Edwards
Flag of United States of America image

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.
For Start press ALT+F11 to make sure that your modules are still there
Avatar of Biggles1

ASKER

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.
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!
Yup!  My Bad, so sorry.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.