Search results

Hi all :) I have a DB set up to receive data from a scanner through a virtual COM port. I manipulate the received scan data in VBA before writing the result to various tables. For certain scans, I'd like the user to confirm the scanned barcodes by scanning it again within the a certain time...

Just an update. I have solved this problem now. One of the reasons I was having so much difficulty is the software app sent with the scanner to program it was well out of date! So it wasn't setting the scanner to output in virtual COM mode. Once I discovered this and downloaded the up to date...

Thanks for the feedback. Unfortunately my programming skills are fairly basic so not sure I understand what you were getting at, let alone be able to do it. But I'll have a play around when I get time. Thanks.

Thanks for the link. The bc wedge looks like it could be a solution, so I'll give it a try. :) Just wish I had enough vb knowledge to make an app like that myself. But thanks very much for that. And great instructional videos too!

I basically have two front ends. One to just capture the data and one for doing reports and charts etc. But as mentioned above what I wanted to do is explore a different way of getting the data into the database though connecting via a virtual COM port and not using the keyboard emulation, which...

To answer both of those, I already have my scanner connected via USB and set up to keyboard wedge and have a continuous form where data is received. So no problem getting the data into access that way. I've also programmed my scanner with the enter suffix so it moves to the next field in my form...

Hi, yes it is USB and I already have the scanner working in keyboard mode. But the problem with that is that focus needs to be kept on a specific field in a form at all times or it won't pick up the read. Hence why I wanted to connect directly via the virtual com port so I could make some code...

I have a bar code scanner I can set to act as a virtual COM port and I'd like to set up a connection in my DB to the scanner so the DB will pick up any bar codes scanned. This is my first try and doing anything like this! So was wondering if any kind souls might be able to help me set this up...

Thanks for the update. I thought I might be able to use the excel application.onkey method to catch alt, tab, ctrl and windows key but can't seem to get it to work in access.

I wanted to use Application.Onkey within an vba procedure but it doesn't recognise it as a valid method. Is there a specific reference I need to point to? I'm using Office 365 on windows 10, so assume I'm using the latest version of MS Access. Thanks

Thank you to everyone for the help and suggestions. I think I have a good solution I'm going to try based on ridders code (Thank you Colin) and potentially kiosk mode once I've investigated this a little more. Cheers to all :)

Yes, that's basically how the bar code scanner works. Each time a scan is made is acts as if someone has just typed the data in. But the scanners are wireless and remote from the terminal. So I can't just ask the op to navigate to the form each time they make a scan. Also there are mutiple...

There is no sensitive data, I just need the form to remain open and the control on the form always in focus. It's actually a really simple form with just one control that accepts the data from the scanner. The problem when an operator scans a bar code, the data is sent to the PC as if someone...

Ah ok. Not heard of that before but sounds pretty much what I was looking for. Thank you.

Thank you, that will help with the database side of things.

Thanks for the reply. I can use model and set the form with a button the closes the form but is password protected. But it doesn't stop someone from navigating outside the database to other PC apps. Model would work great if I knew a way of making the database the only application that can be...

I have a database on a stand alone PC that is used solely for capturing bar code reads from a scanner. In order for the result of the scan to be captured and stored in the database, the focus needs to remain on the open form. So I am looking for any tips or tricks that would stop some curious...

Ok, sure. I am going to be travelling for a few days, so will be next week though if that is ok? Yes, I am the only developer but I am not a developer :) I have designed a number of production type databases over the years, but I am completely self-taught and database development is not my...

Well basically I am trying to design a way for a user to multi-select data from different tables which will then be used to generate a report. So imagine a simple manufacturing process where 'things' are made for different customers, made on different machines and can have a different order...

Yes, you are probably right but I couldn't think of a different way to do it. The main form is selectiong various critera to run reports. So there are some sub forms where the usere can filter and select things like Customer, Order Number, Machine etc. So in the sub form the user has to be...