G
Guest
As a fairly inexperienced Access 2000 user, I've made several attempts to
follow the example in Northwind to construct my own simple OrderDetails
database, but am missing something, so have turned to modifying the sample
database.
Here's what I have done so far:
Deleted the irrelevant relationships (shipper, Supplier, etc) leaving
CustomerID, ProductID, and OrderID.
Deleted the irrelevant fields from the Products, Customers, Orders,and
OrderDetails tables, leaving CustomerID, CustomerName, Product ID,
ProductName,UnitPrice, which are all I am interested in using.
Deleted the field for the now missing Discount in the OrderDetails query.
Deleted the missing fields from the Customer and Products forms, which work
fine without them.
Now, when I open the Orders form, I get an error message "Enter Parameter
Value:" for each of the deleted fields. It doesn't matter if I delete the
fields in the form or not, the message still appears.
Am I completely on the wrong track? Or is this a simple thing to fix that
won't prevent me from going onward? How can this error message condition be
corrected?
I've read a couple of Access books, and looked at some posts here. I'm
overwhelmed with information. Can't think straight anymore!
Thanks in advance, Kathy
follow the example in Northwind to construct my own simple OrderDetails
database, but am missing something, so have turned to modifying the sample
database.
Here's what I have done so far:
Deleted the irrelevant relationships (shipper, Supplier, etc) leaving
CustomerID, ProductID, and OrderID.
Deleted the irrelevant fields from the Products, Customers, Orders,and
OrderDetails tables, leaving CustomerID, CustomerName, Product ID,
ProductName,UnitPrice, which are all I am interested in using.
Deleted the field for the now missing Discount in the OrderDetails query.
Deleted the missing fields from the Customer and Products forms, which work
fine without them.
Now, when I open the Orders form, I get an error message "Enter Parameter
Value:" for each of the deleted fields. It doesn't matter if I delete the
fields in the form or not, the message still appears.
Am I completely on the wrong track? Or is this a simple thing to fix that
won't prevent me from going onward? How can this error message condition be
corrected?
I've read a couple of Access books, and looked at some posts here. I'm
overwhelmed with information. Can't think straight anymore!
Thanks in advance, Kathy