Microsoft Office Tutorials and References
In Depth Information
TROUBLESHOOTING COMMON PROBLEMS
4. Select Use existing Tables and Queries, then select Hours Worked from the list. Click Next,
select Choose from a List, click Next again, and then click Finished. Select the Form view. Your
form and subform should resemble Figure B-80. You may need to stretch out the subform box in
Design view if all fields are not visible.
FIGURE B-80
Form with subform
TROUBLESHOOTING COMMON PROBLEMS
Access users sometimes create databases that have problems. Some of these common problems are described
below, along with their causes and corrections.
1.
I saved my database file, but I can
t find it on my computer or my external secondary storage
medium! Where is it?
You saved your file to a fixed disk or a location other than the Documents folder. Click the
Windows Start button, then use the Search option to find all files ending in .accdb (search for
*.accdb). If you saved the file, it is on the hard drive (C:\) or a network drive. Your site assistant
can tell you the drive designators.
2.
m trying to enter records into my Sales table. The first
record was for a sale of product X to customer 101, and I was able to enter that one. But when
I try to enter a second sale for customer #101, Access tells me I already have a record with
that key field value. Am I allowed to enter only one sale per customer?
What is a
duplicate key field value
?I
Your primary key field needs work. You may need a compound primary key
a combination of
the customer number and some other field(s). In this case, the customer number, product
number, and date of sale might provide a unique combination of values, or you might consider using
an invoice number field as a key.
 
Search JabSto ::




Custom Search