Search results

Hi Ranman. No. If it can be done with queries, that would be nice. Can you put me in the right direction? The VBA code per line make some checks. For instance, if the barcode does not match an order it shows an error. It would be nice to keep these kind of things.

Hi guys, I have a program in Access 2016 for barcode scanning and matching. I receive files with orders (barcode, product, quantity, shipdate) and make an orders-table of it. Then I have a form/scantable for scanning the barcode and fill some columns with the information of the orders-table...

Hi Minty, Thanks for the reply. I made simplified an example database. See attachment. It’s for scanning barcodes and making reports for drivers. In the tblMututions are the scans results. I want to make a view of the count of products per store in a table. This table must be modified by...

Hi Guys, I'm still a newbe in Access VBA. I want to make a macro/module that does the following: -insert 3 records in a table (one for each product with a dummy store) -then run a make table query -then modify the table properties of the new table to set a propertie -Remove the 3 dummy...

Yes! this does the trick. Thanks quys!

I copied the query and convert it to a make table. Then I convert it to a make table. So I have to test if a new make table does the trick. Thanks. I need to change some data by human interaction.

I’m a beginner in making Query’s (and SQL). In the Example file there is a cross table query (qryCountPerStore) with the information I need. I want this information in a table. I do this with a make table query (Kopie van qryCountPerStore). The table thas is made (tblqryCountPerSore) is not...

Got it! thanks

Hi pdaldy. Thanks for the information. I simplified the access files. Therfore I left out the after update event of the barcode. I have some customers with two letters and some with 3 letters at the beginning. Do you have a bid more datails so I can figure out how to use this?

Hi. I’m a beginner in Access VBA. I started a learning project for scanning and matching barcodes. We receive shipments (physical) and orderfiles from a couple of customers. In these orderfiles we get the barcode, storenumber, shippingdate en quantity. We put these files combined in the...