I will never get this program!!!!

G

Guest

I have downloaded template 01018547 (For customer orders) from Microsoft.com.
For the most part it is what I need. There are a few things I have been
trying to update/change to more readily meet my needs. The database contains
the following tables (fields listed too):

Customers Table: Customer ID; Company Name; First Name; Last Name; Billing
Address; City; State/Province; Zip Code; Website; Phone Number; Fax Number;
Ship Address; Ship City; Ship State/Province; Ship Zip Code

Employees Table: EmployeeID; First Name; Last Name; Title; Work Phone

Order Details Table: OrderDetailID; OrderID; ProductID; Quantity; Unit
Price; Price (this is a calculated field, multiplies quantity and unit
price); Discount

Orders Table: OrderID; CustomerID; EmployeeID; Order Date; PO Number; Ship
Date; Shipping MethodID; Sales Tax Rate

Our Company Info table: SetupID; Company Name; Address; City; State; Postal
Code; Phone Number; Fax Number (I don't have any issues with this one at this
point)

Payment Methods Table: Payment MethodID; Payment Method

Payments Table: PaymentID; OrderID; Payment Amount; Payment Date; Status
Credit Card #; Cardholder Name; Card Exp Date; Payment Method ID; Credit Card?

Products Table: ProductID; Product Name; Unit Price

Shipping Methods Table: Shipping MethodID; Shipping Method

Okay, now that that is out of the way, here are my issues:

1. I have a form called "Add an Order & Details" which includes a subform
called "Order Details". I have updated the subform so that when I double
click on the Product field it opens another form in a small window so that I
can add a new product and the price per unit. When I close the small window
I am then able to select the new product from the combo box which is the
Product field, but the price per unit does not change. How can I fix this?
I also need the price field to update (keeping in mind that this is a
calculated field). The query for the form is as follows: From the Orders
Table: Customer ID; EmployeeID; Order Date; Purchase Order Number; Ship
Date; Shipping MethodID; Sales Tax Rate; from the Order Details Table:
OrderID; Product ID; Quantity; Unit Price; Price; Discount

2. I need to add a Seriel Number Field to one of the tables and include it
in the above subform. Which table should I add it to?

3. Keeping with the "Add an Order & Details" form, I have set up the
Customer field on the form similar to the Product field in the subform.
Double click on it and it takes you to another form to input information for
a new customer, close this form and you are returned to where you were. When
I double click on this field to add a new customer I get a message saying
Customers.ShipPhoneNumber. This should not be popping up, I have deleted the
field from the table it was in and the form for inputting new customers. How
do I get rid of it?

These are the questions I have for the moment. Any help would be greatly
appreciated. I am sure that once I have these issues taken care of I will
come up with more regarding reports I will need to generate.

Thank you so much in advance for any help that any one can give me!!

Teri.
 
G

Guest

Forget #3, I figured it out. The ShipPhoneNumber was referenced in a query
that I wasn't aware of. I have removed it from the query and no longer get
the message. Yeah, I was able to figure out how to do something on my own
for a change!

Teri.
 
G

Guest

1) Use the After Update event of the combo box to update the two different
price fields.

2) What is the serial number for? Is it related to the Product? Does each
Product have a unique serail number? Are you hating that quantity field in
Orders Detail Table? Depending on what you are going to use the data for will
really demand where you put it. Just by swagging I would lean towards its
open seperate table with a FK to OrdersDetailID. But that makes the subform a
little more complicated.
 
G

Guest

IT Pro Dave:

Thanks for checking out my post, I really appreciate it. I have been
teaching myself Access and have been getting very confused.

1. Should there be an option in the drop down box of the After Update event
to update the other fields? If so, there is not. So I don't know what to do
with it. (I feel like a total idiot!)

2. No, it is not a unique seriel number. Not all of the products that we
ship out will have a seriel number, only 5 of them. But I will need to do a
report based on this number for tracking purposes. The number may be
repeated on several occasions due to the item coming back in for repair and
then being shipped back out again. The owner of the company wants to be able
to see exactly where each of these items that have a seriel number have been
in the past. Would you still suggest a separate table?

Do you mind if I add a 3. to my list of issues? I have modified the form
where the order and details are input so that when you double click on the
Customer Field it takes you to the form to add or delete a customer and did
the same to the Product field in the subform so that new products can be
added as needed and I don't have to worry about anyone messing with the
tables. Both of these fields are combo boxes. When I add a new customer or
product I have to exit out of the main form and go back into it before the
customer list and product list update to reflect what I have added. Any idea
on how I can prevent this? Oh, wait, would that be the After Update Event
too? And if so, what would I put in for this update?

Thanks again for your help with this, as mentioned before, I truly
appreciate it!!

Teri.
 
G

Guest

I have figured out my number three, so never mind that one. I now have a new
number three. When I select an existing company in my company field Access
takes me to my add or delete a customer form. What did I do wrong?
 

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