Solved

MS Access Form goes blank

Posted on 2009-03-31
9
889 Views
Last Modified: 2013-11-29
Hi experts,

I have three tables which are related through date (i.e date is the only common field in all three tables). There will be only one user of the database (me). I would like to make a form from where I can input data to the tables. I have tried to make the form the following way.
I have put date on the form (the "date" - field comes from one of the tables). Thereafter I have included all the fields I want to have from the first table (the date field is also from this first table). So far the form works, but when I then add a new field from another table and push "form view" the form is portrayed blank without any information on it (only the background). Please suggest me how to solve my problem so that all the fields I want from the three tables can be portrayed and data inputted on the same form according to the same date.
0
Comment
Question by:Stayer
9 Comments
 
LVL 28

Accepted Solution

by:
TextReport earned 150 total points
Comment Utility
From what I understand is that you have added the second table to the query for the first form, if so when you run this query do you get any records displayed and are you able to add new records to through the query?
Do you have allow additions set to yes, if this is no and there are no matching records then you will get a blank form.
Should you be considering using a Form and Subform scenario, this will allow you to add a record to the main table and multipe records in the linked table if this is what you are trying to achieve.

Cheers, Andrew
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 150 total points
Comment Utility
You can't input data into more than one table from the same bound form.  To do that you have to add to the main form a subform for each of the other tables that you want to add data to, and link the subforms to the main form on a common field.
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 200 total points
Comment Utility
Im guessing u changed the sql of the forms recordsource? perhaps changed a filter or something? so because of that no rows found so form goes blank

Depending on the relationships, you might not be able to add to the form. So you could try using subforms instead, this subform representing the other table and of course they are linked by the keys you have in the tables
0
 

Author Comment

by:Stayer
Comment Utility
Hi,
Thank you for the replies. I have made a subform based on table2 and linked it to the "Date" - field in table1. However, the result is that the subform is displayed as an inserted table in the original form. I would like the input fields (linked to table2 and 3) to be displayed the same way on the form as for table 1. I have attached a screenshot where you can see what I mean.

Best regards,

Stayer
screenshot.bmp
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 200 total points
Comment Utility
if u click on the header of the subform, right click, select subform then select form view

you can programmatically set it as well. I guess something like what is described here http://support.microsoft.com/kb/216675
0
 

Author Comment

by:Stayer
Comment Utility
Thank you very much for that tip rockiroads.
The only thing for me now is how to make this subform "melt into" the original form. That is; what should I select / deselect in the properties (design view) in order to make the subform have the same background color as the original form and to make all the lines around the box dissapear (I have deselected the scroll bars and record selector).

Best regards,

Stayer
0
 

Author Comment

by:Stayer
Comment Utility
One more thing, which is actually the most important

How do I hide the date field from the subform since I have already selected it above. the date field is what links the tables together. Is it a way to hide that field?

Best regards,

Stayer
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 200 total points
Comment Utility
try changing border style to be transparent
0
 

Author Closing Comment

by:Stayer
Comment Utility
Thank you very much for your help! Now it works perfectly!
Regarding changing back color I went into properties and choose the right back - color.

Best regards,

Stayer
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now