All of the forms that existed in a database yesterday have suddenly disappeared today. I can see tables and queries only. If I create a new form it disappears when I re-open the database. I am using Access 2000. Any ideas? Thanks.
Forms Disappear (1 Viewer)
- Thread starter VinceC
- Start date
I have a similar problem. Is it not an access 2010 bug?. I have split my database so the data is safe. It's just the forms and switchboard that disappears and the only way to get it back is to restore from a backup. I have an added problem in that sometimes I can save attachments and other time it tells be that the attachment. Is in the wrong format. Please help
- Local time
- Yesterday, 18:40
- Joined
- Oct 29, 2018
- Messages
- 21,453
Hi. What do you mean by "disappear?" You can't see them or they don't exist? For example, even if you can't see the form in the Nav Pane, can you go to the Immediate Window and type the following?
Code:
DoCmd.OpenForm "FormName"Yes. It error is something about the switchboard name has changed or is missing. Well it would say that because it's not there more are any of my forms or reports. All that I can see is queries and table links and tables
- Local time
- Yesterday, 21:40
- Joined
- Feb 19, 2002
- Messages
- 43,223
There may be some filter on the nav pain (sic) that is causing new items to not show. Try entering a new filter and see what happens.
- Local time
- Yesterday, 18:40
- Joined
- Oct 29, 2018
- Messages
- 21,453
Hi. Just curious, did you try the above code on more than form? If so, how about adding the argument to open the form in design mode? I just wanted you to try because I am still not sure if the forms are merely hidden or really gone.
One approach is to create an new db and initiate an import of all the objects from the affected db. It has been reported that the list of forms is visible (along with all the other objects) so if you can see your forms, import everything into a new db. Obviously you want to keep up to date backup files for front ends that have been modified as standard practice but your post reads like your db is NOT split
EDIT -sorry, I re-read and it seems you have split the db.
which is asking for such trouble.
EDIT -sorry, I re-read and it seems you have split the db.
Last edited:
- Local time
- Today, 02:40
- Joined
- Feb 19, 2013
- Messages
- 16,607
nothing like hijacking a 15 year old thread
@shaunfish - you say you have a similar problem. The original poster was using a 2000 db. Access 2007, let alone 2010 hadn't even been invented when their thread was created
So are you running a 2000 mdb in 2010? or something else?
you say
I would also clarify who uses the front end - is it shared between users? or does each user have their own copy? if the latter, do other users have the same problem?
And to cover the obvious, I presume it is not possible that you are actually opening the back end and not the front end? and perhaps left an autoexec macro in the back end?
@shaunfish - you say you have a similar problem. The original poster was using a 2000 db. Access 2007, let alone 2010 hadn't even been invented when their thread was created
So are you running a 2000 mdb in 2010? or something else?
you say
would be very helpful if you clarify exactly what this says
I would also clarify who uses the front end - is it shared between users? or does each user have their own copy? if the latter, do other users have the same problem?
And to cover the obvious, I presume it is not possible that you are actually opening the back end and not the front end? and perhaps left an autoexec macro in the back end?
