Search results

Hi. Thanks JHB It allowed me to send in xls but not in csv. Regards

Sorry JHB. It does not allow me to attach .csv file that's why I zipped it. It is just a normal CSV(made in excel)file with one column. Thanks

Hi. Thanks Please find enclosed barcodes.csv Many Thanks for your help

Hi JHB sorry for troubling you again I am also failed to copy the records of QRY PRODUCTS(query) in to ORDERS table. at the moment I copy and paste manually. I tried some sql statement and it does not work. Thanks for your help

Thanks for the reply. I have attached the sample database

Thank you very much JHB. I was on busy in other works and could not finish this. It works perfectly when I run standalone. but when I run with another query that get barcodes from the table in UNION query it through table mismatch error. here is the sql from the query i want to make union...

Thank you very much JHB. I will try this and let you know if I have any problem Regards Thanks

Hi. I have another problem if you can help me please. let,s say i scan a some products for new order and from them some of the products i need to order more than one in quantity. At the moment if i scan same product 5 times and when i run the query it showed 5 rows of the same product. for one...

Thank you very much JHB It works like a charm. Many thanks for your help JHB. And Thanks for all other forum members who try to help me. Regards

Thank you very much JHB. I will try this and let you know. Thanks

Hi. Thanks for your help. Would you please guide me bit more on this. I think I already link the two field if you see my sql statement. But no gain. If you have better way to connect them together, please help me Thanks

Thanks for reply. It's One barcode= one product No duplicates Thanks

Thanks for reply. Here is my situation. I have database of around 2000 products. When I want to make order from the suppleir. I scan items which I need (about 100)with hand held scanner. Scanner collect the barcodes and when I connect this scanner with the pc, it transfer all the barcodes in...

Thanks for reply. If I took away the WHERE part, it did not search the database through the form. Instead it showed the whole database. My task is to search the database by Taking input from the form. It only showed records for first row and does not show any other rows which are present in...

Thanks for your reply. Here is the sql of the query SELECT PRODUCTS.ID, PRODUCTS.BARCODE, PRODUCTS.DESC, PRODUCTS.[ITEM CODE], PRODUCTS.[RETAIL PRICE], PRODUCTS.[UNIT SIZE], PRODUCTS.[CASE QUANTITY], PRODUCTS.[SINGLE QUANTITY], PRODUCTS.[CASE PRICE], PRODUCTS.CATEGORIES FROM PRODUCTS WHERE...

Thanks for reply. I used the form as datasheet as well. But no joy. I think I am making some mistake in query because the form shows all the barcodes but the query search only first record. Thanks Any other thoughts ?

Hi. I have ms access database with one table called PRODUCTS with 4 column. ID, BARCODE, DESC, SIZE. I build a query which take information from a form. form gets value from the excel table called LNKBARCODE with one column BARCODE. when i run the form it gets all the records(ABOUT 100) from the...