Is this: how do I make it appear in the field called Name of Table 1 Qcode the value of which corresponds to the last name, for example RED? I hope I was clear and understandable, ask whatever else I will explain as. Data Lake Analytics gives you power to act on. Now, from this point on should transfer everything in my DB. Data Lake is a key part of Cortana Intelligence, meaning that it works with Azure Synapse Analytics, Power BI, and Data Factory for a complete cloud big data and advanced analytics platform that helps you with everything from data preparation to doing interactive analytics on large-scale datasets. What I've done so far is to read the Qcode achieved with this procedure with the barcode reader, I opened Notepad, pointed the reader of this and appeared content of Qcode. Set sh = ( 'STROKESCRIBE.StrokeScribeCtrl.1') This is the VBA code contained in a command button on the Word form that creates me Qcode which contains all the data of the various form fields (there are 78 in all). Sure Scottgem, we proceed step by step to show you how you have set all the work. Hope this helps, Scott Blog: Microsoft Access MVP since 2007 Also what happens after you scan the code, what do you want to do next? You need to provide more details for us to help further.

Parse the scanned info to place it in controls bound to fields in your table. I'm assuming you are referring to a QR-Code which is a 2 dimensional barcode. What you do next depends on a few factors like the info encoded in the Q code and what you want to do with it. You place the cursor in a control on your form, scan, the barcode and data appears in the control. So if that's correct, then it works the exact same way in Access. The data, encoded in the barcode appeared in Notepad. So I assume that meant you placed the cursor in a Notepad document, scanned the barcode and I'm assuming your reader simply scans the code and transmits it directly to the PC.

Microsoft access data types explained