User Profile

Collapse

Profile Sidebar

Collapse
Dinnydannydong
Dinnydannydong
Last Activity: Dec 13 '13, 02:54 PM
Joined: Sep 27 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • ...
    See more | Go to post

    Leave a comment:


  • 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
    That is the code you requested in number 1.
    It came from where you described it in number 3.

    The error message I am getting is...
    See more | Go to post
    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 help
    See more | Go to post

    Leave 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 change
    ...
    See more | Go to post
    Last 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

    martin
    See more | Go to post

    Leave 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...
    See more | Go to post

    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 help
    See more | Go to post

    Leave 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.
    See more | Go to post
    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...
    See more | Go to post
No activity results to display
Show More
Working...