Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 02-17-2004, 07:05 AM   #1
VinceC
Registered User
 
Join Date: Jun 2003
Location: Toronto, Ontario, Canada
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
VinceC
Forms Disappear

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.

VinceC is offline   Reply With Quote
Old 02-17-2004, 07:31 AM   #2
Taff
Registered User
 
Taff's Avatar
 
Join Date: Feb 2004
Location: Pembrokeshire, Wales
Posts: 158
Thanks: 0
Thanked 0 Times in 0 Posts
Taff is on a distinguished road
Hi Vincec,

On the Tools Menu, goto options and then make sure the Hidden Objects box is ticked.

Your forms might be set to hidden in the properties of the form.

HTH

Anthony
Taff is offline   Reply With Quote
Old 02-17-2004, 08:38 AM   #3
VinceC
Registered User
 
Join Date: Jun 2003
Location: Toronto, Ontario, Canada
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
VinceC
Thanks but I already tried that. Even a newly created form seems to disappear when I re-open the database.

VinceC is offline   Reply With Quote
Old 09-15-2019, 07:58 AM   #4
Shaunfish
Newly Registered User
 
Join Date: Sep 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Shaunfish is on a distinguished road
Re: Forms Disappear

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
Shaunfish is offline   Reply With Quote
Old 09-15-2019, 08:09 AM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,609
Thanks: 50
Thanked 1,053 Times in 1,034 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Forms Disappear

Quote:
Originally Posted by VinceC View Post
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.
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"
What happens? Do you get an error?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 09-15-2019, 08:17 AM   #6
Shaunfish
Newly Registered User
 
Join Date: Sep 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Shaunfish is on a distinguished road
Re: Forms Disappear

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
Shaunfish is offline   Reply With Quote
Old 09-15-2019, 12:49 PM   #7
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,149
Thanks: 15
Thanked 1,572 Times in 1,494 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Forms Disappear

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.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 09-15-2019, 12:55 PM   #8
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,609
Thanks: 50
Thanked 1,053 Times in 1,034 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Forms Disappear

Quote:
Originally Posted by Shaunfish View Post
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
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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 09-15-2019, 01:03 PM   #9
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,083
Thanks: 421
Thanked 751 Times in 729 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Forms Disappear

I was going to suggest that you list out all the forms in the DB with some VBA, but apparently the Documenter would do that for you as well.

What does that show you.?

Database Tools/Database Documenter
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 09-15-2019, 06:13 PM   #10
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 932
Thanks: 10
Thanked 189 Times in 179 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Forms Disappear

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
Quote:
I can see tables and queries only
which is asking for such trouble.

EDIT -sorry, I re-read and it seems you have split the db.
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)

Last edited by Micron; 09-15-2019 at 06:51 PM.
Micron is offline   Reply With Quote
Old 09-15-2019, 06:46 PM   #11
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Forms Disappear

Check like below pic:
Attached Images
File Type: jpg Nav1.jpg (81.2 KB, 60 views)
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 09-16-2019, 01:53 AM   #12
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,236
Thanks: 40
Thanked 3,644 Times in 3,514 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Forms Disappear

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

Quote:
It error is something about the switchboard name has changed or is missing
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?

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 02:50 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World