Lost All Forms

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

Did you try to compress and see if they come back?


"JamesJ" wrote in message
...
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

Tried that. Have no idea what happened here.

"Noreply" wrote in message
...
Did you try to compress and see if they come back?


"JamesJ" wrote in message
...
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

Hope you have a backup!! If not, you will next time.

D.

"JamesJ" wrote:

Tried that. Have no idea what happened here.

"Noreply" wrote in message
...
Did you try to compress and see if they come back?


"JamesJ" wrote in message
...
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

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?

--
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" wrote in message
...
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

I backed it up a few minutes before. But with ac 2007 I have to
walk on eggshells... corrupted forms and the like. Seems all I need
to do is change the BackColor of a form object and the form becomes
corrupt.

James

"Damian S" wrote in message
...
Hope you have a backup!! If not, you will next time.

D.

"JamesJ" wrote:

Tried that. Have no idea what happened here.

"Noreply" wrote in message
...
Did you try to compress and see if they come back?


"JamesJ" wrote in message
...
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

Yes. The query returned the all form names.
Now what?

James

"Allen Browne" wrote in message
...
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?

--
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" wrote in message
...
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

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" wrote in message
...
Yes. The query returned the all form names.
Now what?

James

"Allen Browne" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
Yes. The query returned the all form names.
Now what?

James

"Allen Browne" wrote in message
...
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" wrote in message
...
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

Can you open them programmatically, i.e. using the DoCmd.OpenForm?

--
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" wrote in message
...
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" wrote in message
...
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.

"JamesJ" wrote in message
...
Yes. The query returned the all form names.
Now what?

James

"Allen Browne" wrote in message
...
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" wrote in message
...
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.