Search results

that is the proper way. but what if i want the values of gross total and net total on order form get stored on order table.

here it is

i tried this in AddNewCustomer form Unload event, and working for me Private Sub Form_Unload(Cancel As Integer) Forms!Orders!CustomerID = CustomerID End Sub

hi guys, how it is possible that when user add a new customer name and mobile number, and click on save/close button on AddNewCustomer form, it save the record, then close form, and then set combo box value of customerID on main form which is newly entered.

very important informations. thanks

hi guys i m facing this error on my order details subform. the fields (which sums i need on subform footer) are calculated fields order details table design view i need the sums of RetailPriceT and SalePriceT fields, which later i will refer on mainForm.Footer.Field Design view of order...

thanks for your guidance, i understand that validation of data is not good in afterupdate events of form or control.

its working now, me.qty.value was not responding, but when i change it to me.qty.text=0 now working in form beforeupdate event

after insertion of available product, if user put value 0 or just leave it unchanged unconciously, there is no check on this step, like as under, gramex septran

i did not have, do i put code under command button click event

working very well, as i require. if the quantity of product left 0, i think it should be checked while user want to save or print order

understand

currently facing these problems, firstly, in product combo, i enter product baydal which have 100 in quantity, but after entering more then quantity, it is not showing msgbox "MsgBox "There is only " & ProductID.Column(2) & " available", vbInformation, "Stock". despite this, the msgbox which is...

dear access members, please check where is trouble in the coding. need assistent to make here is view of my sales order form, there is some issues with coding behind it. i am trying to make it like northwind form, (there is some difference) i need, when ProductID combobox get focus...

i wish to to make coding simple as much i can, i found on above said artical, there is a simple way of rownumber available on report. like this

i tried the code priveded in attached db. but there is some type of error which i am unable to configure. after hours of research i found an artical on this link https://accessexperts.com/blog/2015/07/28/ways-to-do-sequential-numbering-in-access/ which includes method no.5 . working smooth for me.

thanks for your help, sum problems with controls at bottom solved, there is error on my side, i did not refer controls in formulas with their original and proper names.

how can i add sr no automatically starting from 1 for every order i enter

Thanks, i was not aware, and thanks to arnelgp and all of you, now this function is working after putting code given by arnelgp