Search results

dear access family i want some more feature. this code is working fine Private Sub Form_BeforeUpdate(Cancel As Integer) If DCount("*", "OrderDetails", "ProductID = " & Me.ProductID & " AND OrderID = " & Me.OrderID) > 0 Then MsgBox "This Product already entered" Cancel = True...

yes :), now i am struggling for sum formulla in bottom control, my list of problems is very long 😩. but before posting this issue on forum, i am searching for already solved threads.

work is done, this code working for me Private Sub ProductID_AfterUpdate() With Me.ProductID If Not IsNull(.Value) Then Me.RetailPrice = .Column(3) 'or whatever column it is Me.SalePrice = .[Column](4) End If End With End Sub thanks to all

getting runtime error "you cant assign a value to this object" i think, my database structure should be re-structure

it will change the values of entire column, not only the row cell

i did not create specific table for prices only, order details or purchase details having the price values

Suggestion of getting values of retail price and sale price from cbo.product columns working, but there is problem, these values are not storing in order details table.

i am unable to do so

Your forms look great! here is the screenshot of my tables relationship and the design view of query is here resulted of it is

trying to make my question more simple here is screenshot of my ORDERS FORM (which include a subform of ORDER DETAILS) i need to get retail price and sale price for my ORDER DETAILS FORM from a purchase query based on latest dates here is snapshot of purchase query is here how it is possible...

Peace for everyone here, I am not new to ms access, this is my favorit program. Now a days I am doing my job as Cashier in a pharmacy. The software, which we are using have less features, I want to create my own software. I hope this forum will be helpful for me :)