Need Quick Answer To Barcode Scanner Question...
Jun 15, 2006
Didn't know where to post this one...... But forms seemed logical..... I am doing some experimenting with using a barcodes. I can create them now, no problem. My next step is using a scanner to input to a textbox...... Problem isn't with the forms..... But more with the scanners. I thought if someone has done one of these DB's they might know.
So........ I need a cheap scanner to test with.... Found a few on Ebay. The cheapest being a Symbol- "Hotshot" LS2100-I000.Says it has "DB9" plug. The ebay ad says "comes with NO software". Only thing I am wondering about are drivers. I've read in a couple places claims that this scanner "Needs NO drivers"
So my question is.... Would this scanner work with Access on a Windows XP system? No drivers needed?
Hope this question isn't too "off the subject" But I am dealing with Access and hoping someone has done this.
Thanks
Curtis
View Replies
ADVERTISEMENT
Sep 5, 2006
Yep, I'm a newb.
I have a Symbol long range barcode scanner. Works great. I need to drop this in access and have it update as input (without hitting enter every time). I am reading barcodes with serial numbers and part numbers.
Anybody got anything to help?? Pweeease?
Thanks in advance!
RevJohnny
View 5 Replies
View Related
Nov 25, 2005
Help!!
Does anyone know where I can obtain a driver for a barcode scanner that has model details:
Metrolgic MS951 KB Wedge
If anyone knows a specific website that has the drive it would be much appriciated if you could post it here.
Many thanks
Regards
Jason_Hyde
View 1 Replies
View Related
Jun 17, 2006
OK... Did some searching and posted one question on forms... But still have one important question that has not been answered. First let me say I want to use a scanner connected via USB. ( I need to be able to use this app on a laptop, so keyboard wedge is not possible) Found a quote on a site "TalTech"... Something like that...... This one..
"1) Keyboard Wedge output or USB output
If your bar code scanner has Keyboard Wedge output or USB output you will not need special data collection software. Both these outputs will dump the data right into the foreground application on your PC wherever the cursor is flashing, as if it were being typed in. You do not usually get much control except for the addition of a trailing keystroke, such as an ENTER key, to your data. But these methods are very simple and work fine for many people."
Question is...... Is this true??? Will the USB input directly to the field I want it to?? I just need someone with some experience in this to let me know for sure.
Thanks
Curtis
View 8 Replies
View Related
Oct 26, 2004
I have created a form that I would like to search for a barcode by using a scanner as an input device. Does anyone know how to go about doing this?
The form basically holds a subform of textboxes that have barcodes. I want the user to be able to scan a barcode which will then find that barcode in the subform and assign it with a DateOut = Date() ...
View 2 Replies
View Related
Apr 11, 2013
This question is related to a restaurant POS system design. Is there a way to allow a text field in a form to be filled by a scanner only, unless an event is triggered? Rather than using a magnetic strip ones for gift cards, we're thinking of using the bar code version. However, to prevent employees from fraudulently entering the six digit code, the code must be inputted by a scanner. We do also would like to allow user input with keyboard in case scanner malfunctioning, but would require a "manager" login first.
View 3 Replies
View Related
Mar 7, 2014
Still working on an meeting registration app in Access. I have a Main menu which contains buttons that allow search by Name, Phone Number, or Account Number. We are using barcode scanners if they have a registration card.
Currently I have an account button which pops up a query prompt window and when they scan the code it fills the prompt with their account number and a carriage return, pulling up an account registration form with their info.
What I would like to do is from the main form, if a barcode is scanned, to automatically lauch the account form passing the scanned account number.
View 7 Replies
View Related
Nov 17, 2014
I am using Access 2003 and there is a from with barcode scanner to update the shipping data. This form has a sub-form which is working perfectly fine and updating data but the barcode scanner assigned with main form stopped working today. I tried different scanner too and different system too but its not working.
View 5 Replies
View Related
May 20, 2015
I am creating a inventory database for work. I am trying to get the cursor to jump to the next text box for data entry using a barcode scanner. I have a limit on how many characters there can be in this field but yet even after it is all filled the cursor stays in that same field. I am fairly new to access, especially in code building. Do I use "After Update" under "Event" in the "Property Sheet"?
Capture.PNG
Capture1.PNG
Capture2.PNG
Capture3.PNG
View 4 Replies
View Related
Sep 28, 2006
Text field
"CM#000001"
How do i write a where criteria to exclude all records that start with "CM#"
like "CM#*" does not work
like 'CM#' & "*" does not work
thanks
sportsguy
View 3 Replies
View Related
Aug 23, 2006
Thanks for helping me out with this question. Im sure this is pretty easy to do. I have a query with a few paramaters set up... one of them runs a custom function all i want to do is this
query one
Average water flow:Avg([WaterFlow])
when run this just shows me the average water flow for the database... now if i have another criteria i want to base off the average how do i get the query to realize that. for example it would look something like this
[Average water flow]/[currentFlow]
how do i reference another criteria? hopefully this isnt to hard to understand.
View 1 Replies
View Related
Nov 11, 2013
I want to be able to put a barcode in a field that when a reader scans the barcode it records the current time. Need it for access control to record who is in and out of the office. Reading other threads I understand it may be possible in Dlookup.
View 3 Replies
View Related
Jun 8, 2013
I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.
So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .
Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?
View 4 Replies
View Related
May 16, 2005
I'm in the US military. I would like to use the bar code on the back of the military IDs to populate an access database. Can you point me in the right direction as to how to get started?
Thanks in advance
View 3 Replies
View Related
Nov 17, 2006
I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o
View 2 Replies
View Related
Oct 22, 2013
I have a table which contains 2 fields. UserID and FullName..Each employee is assigned a barcode (UserID) and what I would like is when they scan their barcode into the form their name comes up. There is a second table containing records of documents and I am hoping that this form will allow an employee to scan their ID, their name comes up, scan a document and the title of the document comes up, there would be a current date box and then that whole transaction is saved as a record in another table. Long story short I want to know who is accessing what records and to have it logged.
View 5 Replies
View Related
Aug 7, 2015
I have scanner (Unitech MS335-1G) and my end goal is to scan a product number bar code on a box into a field on a form. Then from what is scanned into the box run a query on another table that has all the info on the product. Then populate other fields on the form.
View 2 Replies
View Related
Oct 12, 2014
I have hp scanner whose twain driver has the option to scanning in the pdf document.
Microsoft WIA 2.0 have save scanned document only to graphical format.
I want automated (on click any button control) to scan multipage document from glass source or ADF to pdf document and attach it to attachment field.
I'm found VB Module for accessing TWAIN compatible scanner but it is call twain software and scan to bmp format with assigned name of file.
Me need it also only use the pdf format .
View 7 Replies
View Related
Apr 12, 2005
I have a basic Access Form that contains a small number of questions.
Question 4 is a Yes / No combo box
If the user enters Yes, I want the focus to go to Question 5
If the user enters No, I want the focus to jump to Question 4.1
Completing question 4.1 will take the focus to question 5
I'll be hornswaggled if I can figure out how to do this.
I would love someone to help me out!
:confused:
View 12 Replies
View Related
Oct 31, 2006
I have a receipts table with columns- Customer ID, Receipt #, Amount Paid, Date and in another table- customer Id, First name, Last name, Contact # ,Total Cost. How can I get the balance owing by a customer who have made several payments.
No question is stupid
View 1 Replies
View Related
Jan 15, 2006
Hi all,
Just put some buttons together, and I notice when I click on them I get a box appear on the button itself. Strangely, some of the boxes are solid likes and some are dashed.
Just wondered what they are, and how to change/get rid of them.
See sample below
Thanks
Col
View 4 Replies
View Related
Jan 29, 2007
Hi, totally new on MS access. Is it possible to solve this following task in Access. (using it in Excel today)
Ex.
2d table?
Prod 1 Prod 2 Prod 3
Prod 1 0 10 20
Prod 2 10 0 30
Prod 3 20 30 0
Question 1: What did you just create?
Answer: Prod 1
Question 2: What will you create?
Answer: Prod 3
Then Access will show 30.
Probably explaning it bad but hope you understand and can answer me if this is possible to solve in Access....
The mission is to create a database with setup times between diffrent products, and make it possible to ask a question to get the answer.
/Martin
View 11 Replies
View Related
Feb 3, 2007
I've been here for two months and answered over 400 questions. I'm seeing a pattern here, and I have decided to post the best ways to make sure you are never answered.10) Blood, sweat, and tears are for losers. Spend no time figuring things out on your own.9) Announce almost ceremoniously that you have no VBA experience.8) Fail to use the search functions of this forum.7) Try to put every example you're given into a macro.6) Believe that this is the only source for answers, because Access Help provides nothing. Nothing, I tell you!5) Have us write your homework for you and then complain when you don't understand it.4) Post in German.3) Have a belief that your particular problem is the most important issue ever, and post in every sub-forum possible. Then bump it.2) Be vague, and then be belligerent.1) Have no appreciation for the people that are answering your questions in the first place. I know this sounds cold and mean and otherwise uncaring, but we are here to answer questions, not give you fish, as it were. This is a place to say, "I've done most of the work, but I need help over this hump," not "I have this crazy project/idea and I want you to write it for me." I've written over a dozen example DBs for people, and I know that I know what I'm doing. But, myself along with perhaps the majority of others that answer the majority of the questions, I'm asking on their behalf to please take the time to figure some of this out. If you can't do VBA, you are using 25% maybe of Access. If you can't understand your own DB, then asking us to fix it is a solution, but not a learning opportunity for you. If you can't understand what I'm getting at, it's that so many posts are the same. Again, I'm not trying to be an ass, but if you want to be a decent Access programmer and a programmer in general, then please, take the time to learn it. There are plenty of books (look at the bottom of this forum) and there are plenty of resources. I don't think any of us are teachers by trade, but the best teacher for something like programming is always trial and error. Programming is a language, a passion, a "something you figure out" if you will. If you're spoon-fed the entire time, you don't learn. I will continue to answer as I always do and I apologize if anyone was offended, but jeez, make sure you've tried everything offline before asking for help. And don't forget to search first, both here and Google.Sorry for the long read. :)
View 14 Replies
View Related
Nov 12, 2007
Hi Guys
I currently have a database and the powers at be want me to enable a button that will count how many times in the database a particular month is used. So for example how many times did we visit a particular place in September/october etc.
Is there a way of doing this that i can't see, I have tried searching the forum but to no avail.
my thanks in advance
Anthony
View 7 Replies
View Related
Oct 13, 2005
Please Help. I am tring to get the Month to date, year to date and week to date total in a query. I added a parameter for a date range. Instead of giving me the mtd, wtd, ytd, I get the whole months daily total. Can someone tell me what query caculation do I need to just get one number instead of daily numbers?
View 2 Replies
View Related
Apr 19, 2006
I have created a basic database but now need it to perform some difficult tasks (Well difficult to me) an havent a clue how to do this.
I need to be able to search the database for a vehicle type for a specific dat to see whether it is available or not?
and i need to be able to produc a list of vehicle & drivers that are not booked by entering a date?
Has anybody got any ideas on how to do this because its racking my brains
Thanks
View 4 Replies
View Related