Search results
-
M
How to open a form at specific record?
Hi, I want to open a new form which is similar to the form it will be opened from. Only difference is the new form I want to open is designed for printing purposes. I'd like to access the this new form by hitting a button that opens the print form for a user given order number. Any ideas if... -
M
Address field question
If I have a set of address fields looked up by a customer ID number, how can I get acess to copy them into a shipping address field, which can allow the address to be altered if delivery is needed to an address which differs from the billing address? The example I have seen is in the Northwind... -
M
Calculation Problems
I have a field in a subform called LineTotal which is calculated by multiplying (price1*quantity1)+(price2*quantity2). This works fine and LineTotal displays the correct answer. However I have tried to make a Grand total of the LineTotal using the sumfunction in the subform footer... -
M
Form problem, going back to first record
Hi, After I run a requery command in an Afterupdate event (to update a second subform), the subform in my main form refreshes and returns me to the very first record in the main form. How do make sure that after the requery or refresh, the form keeps me on that record? -
M
How can i count how many items a customer currently has?
Hi, How do I apply a limit to my library database to stop borrowers having anymore than say 7 books at the one time? New loans are recorded via a Loans form which contains a subform allowing the librarian to add new items to the Loan. I need to make sure that no matter how many Loans take... -
M
Adding up the cost of each item stored in a subform
How do I add up say RentalCost of 3 items in one order so that it appears in the main form as a subtotal. Is it use of the SUM function or is it more complex? Thanks -
M
Subform links when selecting a product?
Hi, I have the following structure: Products 1-M ORDER DETAILS M-1 ORDERS M-1 CUSTOMERS I have ORDER DETAILS set as a junction table so that many products can be recorded within one order. All is good apart from when i go into ORDERS and create a new order. I click the subform which links to... -
M
Linked Tables not updating in junction table
Hi, I have the following structure: Products 1-M ORDER DETAILS M-1 ORDERS M-1 CUSTOMERS I have ORDER DETAILS set as a junction table so that many products can be recorded within one order. All is good apart from when i go into ORDERS and create a new order. I click the subform which links to...