Cannot see existing forms, Queries etc.

[Canners96]

Hi There,

I am trying to open an Access database which was created a few years ago... When I open it to edit one of the forms I fail to see the forms etc that are in there.

Is there a hot key you hold down when opening the database to be able to open Access in full edit mode showing all forms queries etc

 

[rhett7660]

Can you see the tables? Do they have a little arrow next to them? You might be opening up the back end of the database..

R~

 

[Canners96]

No, I cant see any of the tables .... Sll I can see is "create table" create form icon etc.... Its as if there needs to be a key held down when initially opening the database to open it in full acces mode

 

[Moniker]

Open access with no DB attached. Go to File -> Open, go to the DB you want to open, hold down SHIFT, and open it. That prevents the AutoRun stuff from executing.

 

[Canners96]

Unfortunately that made no difference either still no visible forms reports or anything..... The switchboard finds the tables etc so its working and they are just not visible to me....... God I wish i could remember .... Thanks for trying so far but neither worked so far

 

[Moniker]

Can you press Alt-F11 to open the code window?

 

[Canners96]

Yes I can, will that show something then ?

 

[Moniker]

PRogrammatically, you can unhide everything (in the Immediate Window). However, if you're not sure what you're doing there, have you considered creating a new DB, and then importing all the object from the DB giving you problems? (File -> Get External Data -> Import)

That's probably the easiest way without manually doing it all in the immediate pane. I could go through the steps if the importing into a new DB doesn't work.

 

[jkl0]

The are probably just hidden.

Under Tools - Options - Show Hidden Files

 

[Canners96]

Thanks Moniker - that worked...........

p.s. jkl0 - no they were not just hidden thats the first thing i checked but thanks for the idea...