Enter Parameter Value error message


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
 
Ad

Advertisements

L

Larry Daugherty

Hi Kathy,

It may not have occurred to you but many of us here do not download
every Access template nor get intimately acquainted with them.

That you deleted a bunch of stuff from a bunch of other stuff and then
changed some more and then came up with a specific error doesn't help
us to help you a bit.

Starting development from working models is a great idea. The trick
is to step carefully and be aware that you are on a learning
expedition. Before you change something, make a reference copy of it;
for example 070516_2_fryFindDonuts. That will identify the reference
query as of the date it became a reference query. You can now safely
change qryFindDonuts to your heart's content. You can always destroy
the broken version, rename a copy of the reference copy and start
over. The same kind of thinking is useful for every kind of object in
Access or any programming language or environment. Taking notes about
what you did and the observed effects is also a great idea.

Welcome to the world of Access and Good Luck with your learning.

HTH
 
K

Keith Wilby

KatS said:
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.
The Orders form is based on a query which probably still contains references
to the fields you deleted. Delete the fields from the query "Orders Qry".
They will show up as "Expr1", "Expr2" etc.

In my experience, deleting elements from a system you're unfamiliar with is
fraught with difficulties. Make sure you test for knock-on effects when you
add/delete things and make regular backups

HTH - Keith.
www.keithwilby.com
 
G

Guest

Larry and Keith, I am working on a copy of the database. I did delete any
fields for nonexistent data in the query. As for "downloading every access
template", that's not what I'm doing. I'm asking for help here and I feel
that I got some sarcastic replies that weren't helpful. I won't be back-
thank you very much for taking the time to reply to my first post.
 
Ad

Advertisements

K

Keith Wilby

KatS said:
I'm asking for help here and I feel
that I got some sarcastic replies that weren't helpful.
I'm sorry you found my attempt to help you sarcastic as that wasn't my
intention at all.

Keith.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top