spamjim,
Its nohing more than a STDIN device, it acts just like a HID keyboard except it appends a C/R onto the end of what it scans. I have a bar code on the visitors badge I create, so when they scan themselves out my function takes the number, searches thru an Excel spread sheet to find...
Hello all,
I'm having trouble making a hand scanner work, what I would like to do is hide a field on my first page and put the focus on that field and wait for STDIN. But if a visitor comes in make them click on the "Name field" and take the focus away, let me show you my code:
<HTML>...
Is there a way to catch <STDIN> from a background process running in windows? I want to write a service that loops, running it in the back ground and just listen for <STDIN>, when it gets input go automatically and run a perl program.
#!c:/dwimperl/perl/bin/perl.exe
# PERL MODULES WE WILL...
Hey guys,
Your suggestions helped and he got it to run!! Thanks very much. Unfortunately he left for the day and didn't explain to me what was happening. I will get the info in the morning and will post it to you. Your help was very appreciated!
Thanks again
--Rick
The above error on line 90, and the debug.print strSQL isn't printing anything but when he takes out the [Branch Name:] it returns everything as in:
rs.Open "Select * from Data (yes I know Data is a bad name, do you think that might be the problem? Is data a reserved word in MS Access?
-- Rick
Andy,
Getting the following error, I suspect he's not getting one of his variables set like he thinks is it.
Error Description:No value given for one or more required parameters.
Error at line :90
Error Number :-2147217904
-- Rick
Thanks Andy!
I agree with you, Data is a bad name for a table.... thankfully I didn't create it or have to support it.
I will have him give this a try.
Most appreciate the help.
Rick
Sub CreateAndRunQuery()
Dim cn As Object, rs As Object
Dim intColIndex As Integer
Dim DBData As String
Dim TargetRange As Range
Dim MyValues() As Variant
Dim i As Integer
Dim Ca As Range
10...
Friends,
I'm trying to help out a co-worker with his query. The person that set up the MS Access database put a ":" at the end of the column name.
"Branch Number:" so when he does his select:
rs.Open "Select * from Data where [Branch Number:] =" & Ca, cn
it doesn't work. I told him I think...
Hello everyone,
Is there a way to start a program on the scan event? for example, I thought the <prefix><data><suffix> would work but I can't find any documentation or examples. What I have is a perl program that opens an excel spread sheet and scans a certain column until it finds the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.