Recent content by age0004
-
A
"You cant assign a value to this object"
Wait im sorry, did you edit that file and repost or just edit it in the drop box? Also the reason I had the master/child link was so that the user can click on a job to be tracked and have it update so it can be edited. Is there another way to do this ? (not sure if that makes any sense)... -
A
"You cant assign a value to this object"
Okay, so I made another copy of my front and back end and deleted every phone number, address, etc.. from it. Im trying to upload it but its not letting me upload to this website. Ill send a link to a shared drive. The back end is not actually protected, I just named it that to ward off nosey... -
A
"You cant assign a value to this object"
Unfortunately I cannot share, it has personal information about our employees, card numbers, etc... Its a pretty large file as well.. sorry MajP -- thanks for the suggestions. I doubled checked and It only gives me the error when I try to add a customer from a drop down box. There is not... -
A
"You cant assign a value to this object"
I have a form called JobtrackingHome with a subform called jobtrackingsubform. Within this jobtrackingsubform is another subform in a datasheet view to enter in dates and times for employees on specific jobs. When I click "New job tracking" button which updates the jobtrackingsubform to a new... -
A
Sum of a field defined by query expression
Okay, so one thing that Im not sure if I will need to change or not is this.... "subtotal" and "extended price" comes from the table OrderDetails whereas the "taxes" and "total" comes from the table Orders Can I keep this the same and still do a query with the total? Is it a problem that the... -
A
Sum of a field defined by query expression
Yes it is a line item. Its a subform in a datasheet view on a main form. Each item could be ordered from somewhere different. Each vendor has different shipping costs and tax costs. Some places have free shipping and some places we don't pay tax so it has to be assigned to the item. So my main... -
A
Sum of a field defined by query expression
Thank you! Okay perfect. I got that first formula to work beautifully! Onto another issue I've been having, which will hopefully complete this form. Now that I have the subtotal and shipping total working, I need a grand total. I can get this to work just by doing a control source simple... -
A
Sum of a field defined by query expression
Okay, So I have it working correctly if I type the actual order number in. For instance for orderID=4, the correct total comes up using this =DSum("[extendedprice]","Qry_orderdetail","[OrderID]=4") Now, since I have one order form for all orders... being filtered by the order number.. how... -
A
Sum of a field defined by query expression
Okay, so actually.... It works, but not quite.... So its giving me the total for every single order in the query... but I need the total for the order in question. So if my order form has orderID=4 I need the total for that order, not for ALL of the orders.... Is there a way to make that... -
A
Sum of a field defined by query expression
OH MY GOODNESS! Thank you, thank you, thank you! DSum works!!!! So thankful for all of your help. I hope it keeps working and doesnt act funny later on, but the fact that Im getting a sum now is amazing. Thank you!! -
A
Sum of a field defined by query expression
Okay, I see what you are saying. In this case, however, all of the fields are working correctly. The only field with the error is the subtotal. The extended price calculates correctly and the prices for all of the parts appear to not have any errors as well. So the Capture1232 is the form... -
A
Sum of a field defined by query expression
So the field is set to currency, without any "text dollar signs" in the field. This is the case for all fields that are currency... As far as this database is concerned I have not split it yet. Its fairly small still so I was going to wait until I fixed this problem (the last problem I have... -
A
Sum of a field defined by query expression
So, I have four tables involved in this. 1) Equipment (only holding the description of the part) 2) EquipmentDETAILS (holding all different vendors/prices for each of the parts) 3) Orders (only holding customer, job name, etc) 4) OrderDETAILS (holding information about all of the things that... -
A
Sum of a field defined by query expression
So do you have any advice or tips for how I can fix this? -
A
Sum of a field defined by query expression
Okay, thank you. I copied and pasted the SQL below SELECT OrderDETAILS.OrderID, OrderDETAILS.OrderDetailID, OrderDETAILS.QuantityOrdered, OrderDETAILS.vpID, OrderDETAILS.ShippingCost, OrderDETAILS.TrackingNumber, OrderDETAILS.ExpectedReceivedDate, OrderDETAILS.Paid, OrderDETAILS.ReceivedDate...