MS ACCESS :: Business Card Scanner

Using A Barcode Scanner
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 Replies !

Barcode Scanner
Hello,

I hope you can help me with this. I have bought a hand scanner for scanning barcodes. I want to scan a barcode code 39.
It is pluged in on the RS232 port of the computer. I know how to set this up but do I need vba code to get this going.

Thanks you for helping me.

View Replies !

Barcode Scanner Drivers
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 Replies !

Barcode Scanner Input Question
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 Replies !

Entering Data From A Barcod Scanner
I’m Robert.
If anybody knows how to help me, please… help.
My problem is with the scanner for barcode. I want to put the barcode (from a product that I have at a table “product”) with the scanner in a form (or a table) and at the moment that the barcode is enter, I want to see the price and the name to this product. Then I want to put another product (entering data from the barcode scanner) at another row next to the other one. At another row I want to see the value (price 1 + price 2).
:confused:

View Replies !

Search For Barcode With Scanner As Input
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 Replies !

Need Quick Answer To Barcode Scanner Question...
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 !

Using A * (Wild Card) In Pop Up Box?

Is it possible to use a * (Wild Card) in a pop up box for a query?

I read the previous post about pop up boxes for quires and it worked worked great! I created one for my month field

My criteria in my search fieled is a follows:
05-May
06-June
07-July
08-August
etc...

As you can see someone would have to type a 08-August to get the results for August, can a wild card be used? Example 08* would return all of 08-August data. I tried it but it wouldn't return any data.

Any help would be appreciated.

Thanks, Scott

View Replies !

Wireless Network Card
Sorry All,
I have a simple question, how can I tell if my laptop has a wireless network in it. Thanks.

View Replies !

Fried Graphics Card. What Do I Do?
Hi,

I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use.

In order to retrieve the information from the harddisk, I got a cable between this computer and another one.

This is my plan:

When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this?

second question:

If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer?

Fuga.

View Replies !

Magnetic Card Reader
Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get the info from the serial port and my limted coding does not even come close to what I need. Any help or a push in the right direction would be greatly appreciated.

Thanks,
Matthew

View Replies !

Wild Card In IIF Statement
I am using a criteria entry form as the source of parameters for a select query, and I am using IIF statements in the query so that if the user does not want to specify for that particular field, the search still works based on the other parameters specified. Therefore the statement I am using is;

IIf([Forms]![Criteria Form]![Customer Account] Is Not Null,[Forms]![Criteria Form]![Customer Account],[Data]![Customer Account]).

This works.

However for some of the criteria I want to also use wild cards, so that the user can enter just part of the data, and the relevant records will be returned. I understand that wild cards cannot be embedded into the IIF statement above.

I have tried many methods, and trawled the web for ideas, but I cannot get this to work. I either want the user to enter the wild card themselves ie "100*" returning records starting with "100", or for the query to append the wild card itself.

Can someone help please?

View Replies !

Wild Card Name Searching Help
How would I make a query find a person like this:

Inputted Data: Smit
Outputted Data: Smith, Smithy etc..

The formula I have entered in the criteria of my query is:
Like [Enter the person's last name]

With this formula, if I type Smith, then the data that comes out is Smith. But if I type in smit or smi, Smith doesnt come out.

Thanks.

View Replies !

Wild Card Searches
Ive read loads of posts about Wildcard searches but am unable to find the answer to my problem. In one of my boxes on my search form the user places in the search criteria value, this can be from A1 - A16 all the way to G16. At the moment i'm using this as my seasrch query:

[Forms]![Search]![BoxNo]

So if I put in C1 then I get all the C1's, great. If I want to wildcard then I put in Like "*" & [Forms]![Search]![BoxNo] &"*", and again it works, this time it call enything with C1 in it i.e C13.

How can I adjust my query to do both, sometimes I only want the exact match othertimes I want to wildcard :confused:

View Replies !

Credit Card Processing
Does anyone know of any software or have any code that would allow to process credit cards.

View Replies !

Employee Time Card System
I need to develope a system that will allow for employees to login and imput their "time card". I found one post on here about something similar, but it didn't give much info. I am very very new to Access so please give info in simple terms or very well explained. I am hoping that I can have a login and password so employees can't access eachothers time card. All it will need to track is
Date
Type of work
Hours
Rate
Comments
I am hoping that this is going to be an easy task, but I need some help. Anyone have any ideas or directions... or even better know where I could just download a template.
Thanks,
Chrissy

View Replies !

Access Wild Card Search Help
Hi

I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The problem is that it excludes all the records with blank cells in either last name or first name or city. In another words, the list is already pre-filtered with records that contain all three fields (city and first name and last name). For example, the record (Last name: Mosby, First name: Ted, City = blank) will be excluded from getting displayed because it contains no characters. Can someone help me out with this issue? I would like to include those people on the search even though their city is not entered in the table. With the query parameter empty, I would like to show a very raw list (a list that is not filtered at all).

The Query is built as follow:
The criteria for the field "Last Name" is
Like [forms]![simform].[lastnamesearch] & "*"

The criteria for the field "First name" is
Like [forms]![simform].[firstnamesearch] & "*"

The criteria for the field "City" is
Like [forms]![simform].[city] & "*"

View Replies !

Wild Card On Search Form Issue
Hi all,

I need a little help with a wild card issue, Ive looked and looked and cant spot whats wrong.

I have two forms "Requisitioner" & "Engineers", each form has a subform.
These are basic search forms (unbound) that find related records in the subforms. The work is done in the query of the subform and then the form is refreshed. I have used this approach many many times without issue until now.

If the engineers form is opened "G*" is entered into the text box then all the entries beginning with "G" are found in the subform.

If the "*" is then removed from the text box leaving "G" no results are found in the subform, (Working Correctly)

Now if the "*" is added again "G*" then the subform shows all the entries beginning with "G"

Everything is good with the Engineers Form, If the same steps are made on the Requisitioners form after adding the "*" again no records are displayed.

I could change the way this works by doing a recordset find but i really want to know why this is working on one form but not on another.

I would appreciate any help with this.

Garry

View Replies !

Seeking Much Help With Generating A Card Number From Another Field
Hi guys,

I need some help here and any would be muchly apprieciated.

I am building a database for a theme park fast pass system where a customer can book themselves a place on a ride at three session times a day.

Now my problem is, that I need to generate a card number. 5555 1946 as the first 8 digits (this always stays the same) and then the last 8 digits is the customer ID number, which is in the same table. So there are 16 digits in total.

Let me give you an example:

A new customer registers and are assigned a customer ID of 1000 0001. Therefore the Card Number for that customer must be 5555 1946 1000 0001.

I have used auto number for customer ID so when a new customer signs up, there ID is 1 more that highest already in te database.

Simple question really...but how is this done?

A million marks for someone who breaks it! Hehe

Thanks

View Replies !

Business Card Scanner

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