Question Form not displaying information (1 Viewer)

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
Hello all this is my forst post and I an looking for any guidance that maybe on offer. I a a new user to Access having only every ceate a couple of small databases using the wizards. I have just started a database where I have created my tables and I am now creating a form to display information. The problem that I am having is that when in Design mode I can see all the information and fields that I have used to create the form, however when i save the form then opening in display mode I do not see any of the fields, revert back to design mode and hey are all there. I have save all my work, closed and restarted access but still no joy, now I am stumped.

Thanks
Sadny
 

MStef

Registered User.
Local time
Today, 17:22
Joined
Oct 28, 2004
Messages
2,251
As I can understand you, in this form put DATA ENTRY = No (properties).
 

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
There is no data in the DB yet, I have just create it and am now doing the forms. in Deisgn node I can see all the fileds that I have added ie the Form Title and all the various filed that i need on the form from other table. I then save and close the form however when I open the form in formal view (as iff I was wanto to enter data) the only thing that is being displace is the Form Name, all the other Fields appear to have gone, however when i go back to edit mode everything is there.
 

MStef

Registered User.
Local time
Today, 17:22
Joined
Oct 28, 2004
Messages
2,251
Check the properties VISIBLE (for every field).
It must be YES.
 

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
Hi have checked all properties and visibility is set to Yes on all fields but still no joy
 

pr2-eugin

Super Moderator
Local time
Today, 17:22
Joined
Nov 30, 2011
Messages
8,498
Could you quickly take a snapshot of your access window?
 

MStef

Registered User.
Local time
Today, 17:22
Joined
Oct 28, 2004
Messages
2,251
Send a short example of your mdb (access 2000 or 2002-2003),
and say what is the problem.
 

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
Hi as requested I have attached 2 pictures in the attachment drop down one is what is showing in Design View and the other what is showing in Form View

Thanks
 

Attachments

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
I am seeing another ptential issue with this BD I have 5 Tables with no data in it yet the DB is saying that it is over 21Mb which i find strange for something with no data

Thanks
Sandy
 

MStef

Registered User.
Local time
Today, 17:22
Joined
Oct 28, 2004
Messages
2,251
Check VISIBLE properties in DETAIL of this form.
 

pr2-eugin

Super Moderator
Local time
Today, 17:22
Joined
Nov 30, 2011
Messages
8,498
Try a Compact and Repair.. it will solve the mysterious size of the DB..
 

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
Thanks that brought it down to 640Kb - more like it.
 

pr2-eugin

Super Moderator
Local time
Today, 17:22
Joined
Nov 30, 2011
Messages
8,498
So now that is sorted, could ypu post a copy of your DB so we can see what is causing it to go invisible?
 

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
Hi, I have now been able to attach a copy of the DB as was requested

Thanks
 

Attachments

pr2-eugin

Super Moderator
Local time
Today, 17:22
Joined
Nov 30, 2011
Messages
8,498
Okay a few pointers here.. The reason why it is not visible is because,
1. You have is a Query as a data source, that has no result set. i.e. the record count is 0
2. If you want to manipulate several table information, they CANNOT be used in one single main Form.. You need to use Main Form and Sub Form set up.
3. You need to look into Normalization principles. As there are no relationships defined in your Database..

Address these issues before going any further..
 

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
pr2-eugin's thanks very much for the pointers - I am from the other side - I certified in Excel now i and begning to i know why. Thanks again
 

Severin

Snr. Developer
Local time
Today, 09:22
Joined
Mar 27, 2012
Messages
172
Hi, here's a bit to work on... just to show a quick way of getting up and running.

Without any data I can't be sure of your structure or you work flow...

If you want to go behind the scenes you need to hold down shift when you open the database.
 

Attachments

SandyB

Registered User.
Local time
Today, 17:22
Joined
Dec 11, 2012
Messages
18
Severin, thanks for the help, I will Havalook behind the db to see how things are.

It is very much appreciated.

thanks again
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom