Search results

I am trying to paste the values from form to access browser by clicking the command for auto fill the user id and passwords. So i requesting the vba code .Thank you .

No, there in no error ,only stopped working and getting recover mode.

i have compiled my vba code and it does not have any errors and i given trusted location for that file. But it is stopped working while making accde. so what will be the cause ? will any have solution? thank you.

If I delete the entry it won't affect to main data . for that only I used duplication. Thank you

it worked thank you

Yes, by default original data fetches in to combo box and its bound colomn(0), when user inputs data it has to match the value of colomn(0) then run the other code else message to user that doesn't exist in list.

Cboestdet is a combo box, and I am going to input value there and it has to check whether value matches in cboestdet.colomn(0) ."here combo box with multiple information I used" so I specified colomn(0)

Hope you required this "Sales of each item regard less discount"

I need message pop up for not matching the value with combo box colomn(0) value. I used below code but not success. Please get me out from here. thank you. Private Sub cboestdet_AfterUpdate() Select Case cboestdet Case Not (Me.cboestdet.Column(0)) MsgBox "Item not found", vbOKCancel...

i used update query it was success and updated parent table where the cursor was dropped that particular row only updating in parent table. But actually i need all the rows should compare . how can i FOR loop after WHERE condition ? and Just i want multiple barcode values from subform to...

Actually i am not going to change the barcode number, i am going to change the other columns details where the estimate sub form barcode values(i mean multiple items) is equal to parent table barcodes .

Design Flaw as in picture, Estimation_data is a table for only quotation for multiple items of tbl_Purchase_details and not effect to tbl_Purchase_Details items while i use Estimate command. If i use Sale command those selected products to be updated in required fields in tbl_Purchase_details...

yes, but in update query where condition takes only one value. instead of one i need many..remain all the thing is good.

I TRIED TO RUN THIS AND METHOD MEMBER DOES NOT EXISTS FOR Currentdb.CreateQueryDefs. ANY CORRECTIONS??

it was run, but updated only i item which is cursor is dropped that row only effected. but i have 2 items in subform all should be updated

All the thing is good i think!!?. but not perfect...

Got input box

Barcode is parent ID , where active subform having multiple barcodes, those are should be updated to main table. here sub form having a duplicate data of main table.

UPDATE tbl_Purchase_Details SET tbl_Purchase_Details.IS_Sold = True, tbl_Purchase_Details.bill_num = 123, tbl_Purchase_Details.sales_date = #5/30/2018# WHERE (((tbl_Purchase_Details.BarcodeID)=[Forms]![frm_Estimation]![frm_estimation_details]![barcode])); by this query i can update only cursor...

Yes, scanner can't read the printed barcode.