Re: Lost All Forms

No good. Navigation Pane still not showing Forms except for the
one form that I saved the design changes to when this happenned.

James

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message news:%23ZxmZEbgHHA.3412@xxxxxxxxxxxxxxxxxxxxxxx
Excellent. They are still present.

That means they may be marked as hidden objects, or the navigation bar may be filtered to exclude those objects.

Go to:
Office Button | Access Options | Current Database | Navigation Options.
Under Categories, choose Object Type.
Make sure the Forms box is checked (on the right.)
At the bottom of the dialog, check the boxes for Show Hidden Objects and Show System Objects.

If you can now see your forms in the Navigation Pane, right-click and choose View Properties. Make sure the Hidden box is not checked.

Since you can see the names of your forms, you can also try opening one like this:
1. Press Ctrl+G to open the Immediate window.

2. Enter:
DoCmd.OpenForm "Form1"
substituting your form name for Form1.
If it opens, that may reassure you they are okay.

Let us know how you go.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JamesJ" <jjy@xxxxxxxxxxxxxxxxxxx> wrote in message
news:O%23VnPJagHHA.4368@xxxxxxxxxxxxxxxxxxxxxxx
Yes. The query returned the all form names.
Now what?

James

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message news:%23udioMWgHHA.5052@xxxxxxxxxxxxxxxxxxxxxxx
James, I guess you are trying to find out whether the forms are somewhere under the surface, even if you can't see them.

Try creating this query:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type = -32768
ORDER BY MSysObjects.Type, MSysObjects.Name;

Alternative approach: open the Immediate Window (Ctrl+G), and enter:
? CurrentProject.AllForms.Count
If there's more than zero, you can try:
? CurrentProject.AllForms(0).Name

Any luck?

"JamesJ" <jjy@xxxxxxxxxxxxxxxxxxx> wrote in message
news:%23mWH4NTgHHA.4868@xxxxxxxxxxxxxxxxxxxxxxx
Has this happened to anyone else?
Designing a form and all of a sudden all form objects are gone in Access 2007.
Access asked to save the design of a form and that was the last I saw
of 10 objects in this db. Showing tables and related views find no more forms in my
db.

James


.