User Profile
Collapse
-
... -
That is the code you requested in number 1.Code:Private Sub ProductID_AfterUpdate() If Not IsNull(Me![ProductID]) Then Me![Quantity] = 0 Me.Quantity.Locked = False Me![CustPrice] = GetListPrice(Me![Product ID]) Me![Discount] = 0 End Sub
It came from where you described it in number 3.
The error message I am getting is...Last edited by Rabbit; Oct 10 '13, 03:18 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.Leave a comment:
-
Hi Thanks for getting back to be, I presume I remove the line
Private Sub CustPrice_After Update()as I am working in the ProductID field.
In regards to the second part I do not have GetListPrice in my Products table I have CustPrice as the field I want to match to. Could you explain how I do this. Thank you for your helpLeave a comment:
-
GetListPrice error in OrderDetailsExtended form
Hi,
I have a set up an OrderDetailsExt ended subform on an Order Form. I have used OrderDetailsExt ended Query, these were both taken from the Northwind Database. On productID I have adjusted the VBA in the after update. But I am still getting an error when I add a new product to the order.
...Code:Private Sub CustPrice_AfterUpdate() Private Sub ProductID_AfterUpdate() 'Initialize price and discount for each product changeLast edited by Rabbit; Oct 10 '13, 03:17 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data. -
Hi,
NeoPa and zmbd, you two are the guys. Thanks for all the advice, I am returning to access after a 4 year break designing websites so still rusty but appreciate all your Information and Guidance and the way you delivered it.
Warm wishes
martinLeave a comment:
-
Hi zmbd,
thank you for jumping in on this enquiry I appreciate your input.
I have wrote the following code from your information and guidance.
forms!NewOrders .CustomerID.req uery
forms!NewOrders .CustomerID.val ue= =new_customer_r ecord
The issues I have now is the place to put it in the properties of the combo box and also in the last line of code I have 2 equals sign and what is new_customer_re cord...Leave a comment:
-
Hi NeoPa,
think we could be on different time zones, but thanks again for your prompt reply. Your solution looks to be the answer but could you go into a bit more detail in how I achieve this. I have to be careful as I will not always have a new customer. Thanks in advance for any helpLeave a comment:
-
Hi, firstly I apologise in the late reply I have been away. I have tried this code and it works as far as when you go back into the main Order Form (NewOrders)it is in the drop down list,so thank you. But I was hoping to have it automatically put in the field so you do not have to scroll for it.Last edited by zmbd; Oct 7 '13, 04:14 PM. Reason: [z{Please realize, many of us can not see your attachment.}]Leave a comment:
-
Setting a value on an open form From a pop up form
Hi,
I have a NewOrders form on my database.
If I have a new customer I have created a pop up form and I fill in the new customer details including CustomerID and then I close this form and return to the NewOrders form. What I would like to happen is the new customer be then entered in the CustomerID field on the NewOrders form. This field is set up as Combo Box displaying the Customer name in a query set up in the Order...
No activity results to display
Show More
Leave a comment: