Recent content by pdwalke4

Whats the Dmax function? not heard of that one.

I have a query that returns the latest order date of a customer (on a sub form). I want to get the value from this query into the main form. The idea being that everytime the customer adds a new order this value would be updated. How do i do this?

The idea would be to delete customers who havwen't ordered for say 2 years or so (the db isn't or me so just making sure has all the tools requested). The query needs to have a link to the Date field in the order table so as to say if the oldest date order is beyond a user defined limit it...

I want to write a query that would delete records from 3 linked tables Customer has Orders that have Items The Order table holds the date of the orders. I want to delete all customers that have not placed in order since a user entered date. Not got off the ground on this one. Any help...

Think i have pestered you enough for one day (and my head is spinning at the mo from work done on it today). Isn't any sensative data on it am doing it for a friends small business and only test data in at the mo. Will look back at it after have sorted the long lists of queries and reports...

yeah, unless you can suggest a way of making it more efficient (auto updates subform1 when click save on subform 2).

Sorry, that was me having a blonde moment. IThere is a main form and 2 sub forms Have prety much sorted both (although isn't very efficient). I had to add a refresh form button to update subform2 and subtotal field and the save button passes the value to main from. A process button on...

MsgBox (Forms!school1.subtemp) will give me a value from my main form and i can pass a value from subform2 (items1) to this form but i cant pass the value directly to subform1 (Orders1). I have fudged it a little by passing the value to main form and then to subform1. Second problem, I have a...

At the moment have got the system to pick up the total in the subform which updates everytime the Quantity field is updated. Everytime i try to add to this by asking it to pick up the value in the Order Value field in the Main form (testing by using a msgbox) i get the error object expected.

Am quite new to VB to you translate that into my field and table details from above. Sorry if it should be obvious.

I have calculated the SUM total of a cost in an order form (e.g has 3 items). How do can i transfer the data to a Total field in the main form (i.e main form holds the total cost of items)? Table details Main Form (Orders1 with field name Order Value) Sub From (Items1 with field name...

ooops sorry, was having a problem with a report but solved it before posting, forgot to chance sections. Is a form problem. Sorry

how can i calculate the SUM total of a cost in an order form (e.g has 3 items) and transfer the data to a Total field in the main form? Badger