Query/Forms

[Robison]

I have developed a database for my son's small business but am having a problem with one of my forms/query.

I am having problems with my form frmApparelOrderDetail. I know the problems is the query qryApparelOrderDetail but cannot figure out what is happening. When I join the orders table (Left Join) I don't see the OrderID. The only way it displays is if I take it from the tblOrders but it then becomes New and I know that is not correct. Can you look at these to items and see if you can help me with this. I have eliminated all old data and have just one customer listed to help diagnosis this problem.

I sure would appreciate any assistance anyone can offer.

I have attached my database for assistance in the diagnosis of this problem:banghead:
Sharon

 

[JHB]

.. When I join the orders table (Left Join) I don't see the OrderID. The only way it displays is if I take it from the tblOrders but it then becomes New and I know that is not correct.
Sharon

I can't follow you here, can you explain a little more, (maybe a print screen)?
What do you mean about "I don't see the OrderID."?
Where do you think you could take it from, " The only way it displays is if I take it from the tblOrders"?
What do you mean about, "but it then becomes New"?

 

[Robison]

If you look at my database it will be visable...I have developed the process to first open the frmCustomer...then button to the frmOrders The frmOrders has fields established from the customer form...CustomerID, Organization name. After that the operator will button over to the detail form of the item they are purchasing. The Trophy and Plaque detail forms work fine but the frmApparelOrderDetail will not work properly. The information I bring forward to the detail form is the Organization, CustomerID, TypeOfOrder, DueDate and OrderID. The detail form is based off of a query qryApprelOrderDetail. It is this query that is not working properly and I cannot figure out why. If you process from the frmOrder to the frmApparelOrderDetail you will see the information is loaded temporarily in to the OrderID control field but then disappears and the form will not allow any data to be entered as it error out as no orderID is established. I hope I have explained it better and that you can help me with this. I would like to start using the database soon. Thanks for you time. Sharon

 

[Robison]

JHB...after months of banging my head again Access I finally figured out what was going on...I have the customer form/query working well and the Order form&query working well but I was trying to use TWO different tables to store the details of each other in and THAT was not working. Once I combined but table fields in to one large table the whole thing worked. DUH. Access does not give you any hits when you are not doing something right or if they do it is so nebulous you can follow the error to resolution...or at least that has been my experience. Only problem I have now is with the Nz funtion. I have a Apparel Total field that calculates and when there is no data involved it produces no answer. This statement works if there are quantities and prices in both expression but not if there isn't. ApparelTotal: (([XS]+[SM]+[M]+[LG])*[RetailPrice])+([XL]+[2XL]+[3XL]+[4XL])*[RetailXLPrice] Would appreciate assistance if you get a chance. Sharon
A BIG THANKS FOR YOUR ASSISTANCE.