I tried doing that in the text boxes and it kept giving me the following errors: #Name or #Error. Is there a better or easier way of doing that without having to go through queries? THANK YOU!
I have an Order form and on it I have a subform where I enter the items into: The quantity, description, price and I have a total for each line of information. At the bottom of the subform, I have the SubTotals, I did a text box with SubTotal=Sum([Total]) and it adds up the totals from all of...
THANKS A LOT TRENDSETTER! Just another question: You said to develop the invoice from the information in Order and Order Details, You mean use the same information will be in Invoice and Invoice Items and Order and Order Details right? If all these tables have the same information, how to I...
I have an order form that is sent to customers. If the customer decided he/she wanted the items I make an invoice with the information from the order form. How do I get the information from the order form to appear on a different form, the invoice form? I would like to keep record of all the...
I have a form for the customers with all of their information. When I want to add in a new customer I have to open up an existing form and go to "Add new record" to get a blank form. How do I get a command button to just open up to a blank form when I want to enter in a new customer?
I'm working on a db that is similar to Northwind Traders sample db. I have an Order Form and I need to insert a subform where the actual orders can be placed (Quantity, Unit Price, Description, Total). The subform can not be linked to products bc rarely will the same products be ordered. I just...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.