Data entered is not displaying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access Microsoft 2003 - I have entered data through one of my tables, but it
is not displaying in the select query/form I have created for the data. How
do I get it to display?
 
Maybe somebody will be able to decipher what you are doing, but it would be
best if you provide some details. Are you entering the data directly into
the table? If so, that's not such a good idea, especially if you are doing
that in an end-use version of the product (as opposed to during
development). Users should not work directly with tables, but should be
using forms for data entry/editing.
That being said, the reason the data are not appearing in the query is that
the query does not call for the data. Have you added the field to the
query? If so, have you entered criteria that prevent the data from
appearing? If you open the query directly do the data appear, or is their
absence only in the form that is bound to the query (if that is indeed what
you have -- "select query/form" is a bit ambiguous)?
 
Thank you for your help - I am developing a database with names/addresses and
workdetails plus whether contact has been made with people. I have entered in
test data directly into the names/addresses table, which I agree is not such
a good idea and was intending to input more new data via the form. However I
thought that the query and forms would pick up the data and can't understand
why they are not. All the fields in the query have "Show" checked and the
query has the "Output All Fields" property checked. I have not put in any
"Criteria". If I open both the query and the form, neither of them has any
data from the table. The surnames are picked up in a 'SelectName' combo box I
have made on the form, but this does not retrieve the complete record when
selected. The combo box seems to add a new record instead!
 
It may help to know something of the structure of your database. What are
the tables, and how are they related to one another? Is contact information
in its own table, with information as to whether or not contact has been
made in another table? On what table or tables is the query based. If you
open the table in datasheet view, do you see the information? If so, what
happens when you build a query based on just that table? When you build the
query, be sure either to add all of the fields individually, or to add the
asterisk (all fields) to the query design grid. You can use a combination
of the two, which you could do if there the query is to contain all fields
from the table, and is to be sorted by one of the fields (which you would
need to add separately).
The combo box sound like a separate issue. If you are using it to find a
record it would typically be an unbound combo box. The wizard can set that
up, if you like. If you are just adding or editing information, use a data
entry form with text boxes bound to FirstName, LastName, Address, etc. If
the search combo box is bound to a field, making a selection will change the
field's contents, I believe.
 
There are 3 main tables and 3 lookups: Personnel (with lookups for Gender and
Country), WorkHistory, and Calls (with lookup for CallTypes e.g.
letter/email/phone). Personnel has one-to-many relationships with both
WorkHistory and Calls. The query is intended to be based on Personnel and
WorkHistory (and display on a form), but I have now deleted the original data
which did not display and entered new data via the form - and created a new
TestQuery based only on the Personnel table. This new data can be viewed
through the datasheets of the Personnel table and the query, but still does
not display in the form, and now I cannot seem to enter further new data via
the form either (when I click on certain fields, e.g. list boxes, certain
random fields get filled with "#Name?" and cannot be overwritten/changed.
 
If you make a query (qryPersonnel) based on the Personnel table
(tblPersonnel), then make a form with qryPersonnel as its Record Source,
then drag fields from the field list to the form (in design view), can you
see the data?
A typical arrangement with something like WorkHistory is to do what you have
done with the one-to-many relationship, then to use a form/subform to
display the data. To verify that we are talking about the same thing, I
envision a structure something like this:

tblPersonnel
PersonnelID (primary key, or PK)
FirstName
LastName, etc.

tblWorkHistory
HistoryID (PK)
PersonnelID (foreign key, or FK)
StartDate
EndDate
JobTitle, etc.

The relationship is between the two PersonnelID fields. The PK fields are
established in table design view, and the FK field is established by its
relationship to the PK field.

Build a form (frmPersonnel) based on tblPersonnel, and another form
(fsubHistory) based on tblWorkHistory. When you drag, say, FirstName from
the field list onto the form, the text box will be named FirstName (same as
the field). Change it to txtFirstName (or whatever you choose, as long as
it's different from the field name). This will take care of some #Name
problems. You may wish to set the Default View of fsubHistory to
Continuous. Drag the icon for fsubHistory from the database window onto
frmPersonnel. Click the border of fsubHistory, then click View >
Properties. Verify that the Link Child Field and Link Parent Field property
is set to PersonnelID. If it is not, click the three dots; I think the
dialog box will be self-explanatory.

If this works as expected, try substituting qryPersonnel for tblPersonnel as
the RecordSource for frmPersonnel. Does it still work?

This should help get you on the right track, unless I have completely
misunderstood the question.

Now you should be able to enter Personnel information into the main form and
History information (as many separate entries as are needed) into the
subform.
 
Back
Top