Why use keystrokes mode instead of DDE?
While it is possible to do this entirely through code and using DDE there is really no advantage to doing so. The main advantage of using DDE with Access is simply to allow the operation to run reliably in the background – allowing you to work in other applications in the foreground while the data is quietly logged into a table for you to look at and analyze later – or to use multiple serial devices that transmit data at the same time. In an inventory application where you are scanning a bar code into your computer simply to retrieve information about a product, the Access application will need to be in the foreground to display the result and it is therefore unlikely that you would be using the PC for any other tasks at that time. It is equally unlikely that you would have two scanners connected to the same PC as Access allows multiple users to modify data at the same time so you could just as easily connect a single scanner to multiple PCs all of which are configured in keystrokes mo
