Question Form not displaying information

[SandyB]

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]

As I can understand you, in this form put DATA ENTRY = No (properties).

 

[SandyB]

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]

Check the properties VISIBLE (for every field).
It must be YES.

 

[SandyB]

Hi have checked all properties and visibility is set to Yes on all fields but still no joy

 

[pr2-eugin]

Could you quickly take a snapshot of your access window?

 

[MStef]

Send a short example of your mdb (access 2000 or 2002-2003),
and say what is the problem.

 

[SandyB]

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

 

[SandyB]

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]

Check VISIBLE properties in DETAIL of this form.

 

[pr2-eugin]

Try a Compact and Repair.. it will solve the mysterious size of the DB..

 

[SandyB]

Thanks that brought it down to 640Kb - more like it.

 

[pr2-eugin]

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]

Hi, I have now been able to attach a copy of the DB as was requested

Thanks

 

[pr2-eugin]

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]

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]

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.

 

[SandyB]

Severin, thanks for the help, I will Havalook behind the db to see how things are.

It is very much appreciated.

thanks again