Search results

  1. R

    Creating a time out function

    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...
  2. R

    Reading a virtual COM port

    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...
  3. R

    Reading a virtual COM port

    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.
  4. R

    Reading a virtual COM port

    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!
  5. R

    Reading a virtual COM port

    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...
  6. R

    Reading a virtual COM port

    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...
  7. R

    Reading a virtual COM port

    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...
  8. R

    Reading a virtual COM port

    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...
  9. R

    Locking PC for use while DB is running?

    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.
  10. R

    Can't use application.onkey

    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
  11. R

    Locking PC for use while DB is running?

    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 :)
  12. R

    Locking PC for use while DB is running?

    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...
  13. R

    Locking PC for use while DB is running?

    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...
  14. R

    Locking PC for use while DB is running?

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

    Locking PC for use while DB is running?

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

    Locking PC for use while DB is running?

    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...
  17. R

    Locking PC for use while DB is running?

    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...
  18. R

    Database Engine Could Not Lock Table...

    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...
  19. R

    Database Engine Could Not Lock Table...

    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...
  20. R

    Database Engine Could Not Lock Table...

    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...
Back
Top Bottom