Search results

So when I do that, it prompts me for information that I have put in for user interaction. For example, my query asks me for a beginning date and end date, and a customer name. If you read my previous posts you can understand my predicament. It doesn't behave like a form.

Can anyone tell me how to update a query from a form, Once i've done that I think we can put this string to bed, as thats all the help i'll think that i'll need for now. Thanks very much

Is it in the SQL View?

Sorry I didn't mean to confuse anyone, I just thought that my question had become relevant to forms so I put in that forum. My mistake. I think that i'm nearly there now, i've learnt quite alot about access. I just don't understand how I update the query.

What does that mean?

Ok, sorry about multiple posts, Anyway, that seemed to get rid of the error message, but how do I update the query recordset for the form. Thanks for your patience

I'm really sorry, you have to tell me like i'm a six year old because I'm having real trouble. Whats the vba sub? Where do I enter [event procedure]?

Ok, i'll give that a go.

How do I update the query?

How do I update the table that the form is based on. The fields for price remain at zero. I have been informed that this is because it is bound. I need to be able to print off the various delivery notes within a certain date span as one invoice, but the calculated figures don't show up...

Well i get the following error. "The expression BeforeUpdate you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'Me.'."

What does Me. mean, what does it refer to exactly, sorry i'm a real beginner at database work. Thanks for your help so far.

Where do i put it on the query? The function I use is: =GetCost([Zone],[Weight]) My Module that I use is: Function GetCost(ByVal intZone As Integer, ByVal intWeight As Integer) As Currency If IsNull(intZone) Then GetCost = 0 Exit Function End If If...

Well where do I store the price, it doesn't show in the table, it only shows on the form, but I want the calculated price to be displayed in the table and the query so I can print it off when I want to. There must be a way

Well basically I need to generate an invoice based on all the delivery notes I enter into the form. I have the query set up so I can choose the customer I need to invoice and I can choose the dates, but when I view the report it shows all the delivery notes in the dates I specify but the value...

I have a function on a form that calculates a price based on information entered into a weight text box. The function works well, and the information is calculated in the form, and when I review the records in the forms the information in the price cell is ok. When I look in the table that the...

I've noticed another thing too, When I look in my table format of the form, the prices are not showing. It shows all the right zones entered and the weights, but for price it shows zero Do you know why that is?

That works brilliant, many thanks mate. The pallet is a seperate field, for example if there is 1 pallet, than nothing will be entered in the weight field. Its like a one of cost, so no weight details are taken if there is a pallet, except if there is loose packages along with the pallet...

Yes sorry for being unclear. Its like this: Zone 1: 0 - 30 kilos = £5.50 31 - 99 kilos = Plus 20p per kilo thereafter 100 kilos plus = £19.50 per 100 kilos Plus 18p per kilo thereafter Pallet = £50 per pallet Zone 2: 0 - 20 kilos = £5.50 21 - 99 kilos = Plus 22p per kilo thereafter 100...

I think you may well have missed out a bit of code for the zone 2. Also where do I enter this code, in the control source box on the properties?