Magnetic Card Reader
Apr 7, 2008
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
ADVERTISEMENT
May 10, 2006
Hi all,
I am trying to use a barcode reader with an Access database. The raw data is a linked table to a Crystal Report Excel dump that is updated daily. My problem, the raw data “Asset Tag” field is numbers only. The barcode has the needed numbers but is preceded by “PC”.
Example:
Raw data Asset Tag “12064621”
Barcode Asset Tag ”PC12064621”
Is there a way to remove the “PC” from the scanned “lookup” field?
Objective:
Scan the barcode tag into the form, bringing up all related information on that Asset.
View 3 Replies
View Related
Dec 9, 2005
Hi,
One of users of supermarket is running my db successfully since long. But due to the change of time & his progress in business, he expanded his supermarket and it is becoming difficult to use the keyboard to enter the digits for the price.
Hence he asked me to make db able to read barcode on the items so the transaction would take very little time.
To be frank, I do not have any experience about barcode reader how to implement it with Access db.
What kind of barcode readers are available that would EASILY set with Access db? R They really work with Access db? What steps I need to carry out to implement it?
Please advice if anyone of you has any idea in this regard.
With kind regards,
Ashfaque
View 2 Replies
View Related
Mar 7, 2008
hi
I m new, and i want to make a meter reader in Access for daily use. i want to be enter only last reading every day at data entry form and that last reading must appear as first reading of the next day automaticaly in same table, because i have only one table in my database. fields are "date", "1streading", "2ndreading" & one data entry form and one report. is it possible in access, if so please help me. thanks
View 7 Replies
View Related
Dec 24, 2014
I have just finished putting together an access database as a payroll. It is working fine and it will now save the company a lot of man hours in calculations.
When the employee clocks in or out there is a form and the employee has to key in a unique employee number and a password, which of necessity is hidden from view. Of course the password can be divulged from one employee to another.
Consequently, eventually I will need to incorporate a finger print reader and use the information from this instead of the password.
View 1 Replies
View Related
Aug 23, 2013
How can I show by query all the books that has not been borrowed by a chosen reader?
My query setup is:
Table 1 readers( name etc.)
Table 2 books (name etc)
Table 3 Table of borrowing dates linked by 1 to many link to tables 1 and 2
View 11 Replies
View Related
Mar 18, 2015
Since converting to Access 2010, when I use the "PDF or XPS" button to create a PDF from a report, after the save dialog it opens the PDF in Adobe reader, and then after I close it there is another dialog with the option to save the export steps. Is there any way to just be able to save the PDF and go back to where I was without having to do the extra clicks to get back?
Back in Access 2000 I had created a custom button on a toolbar that would automatically make a PDF from the open report, but that didn't transfer over when I converted the database to 2010.
View 10 Replies
View Related
Jul 31, 2013
My desired output of this is to have a database to allow me to quickly check in and out equipment and personnel using a barcode scanner. I am using access 2013 and started with the asset tracking template downloaded from Microsoft. Where I am hung up right now is adding the personnel check in and out (each member of the team will have a barcode attached to their id) I want to be able to just scan their badge when they show up and again when they leave. At the end I will run a report that shows who was on scene (it is for a search and rescue team) during a certain day or time range.
I have added two new tables one check in and one check out the only fields are firedeptID and CheckIn or CheckOut a date/time field CheckIn and CheckOut Auto populatewith Now(). The first problem is that I think I need to turn off (if possible)the auto creation of a new record every time, when I scan in an ID right now that record gets the time stamp of the last time the new record was created IE.Last week when the last person scanned in and the new record was created. I assume I am going the same type of issue when I start working on checking out the equipment.
View 8 Replies
View Related
Aug 3, 2004
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 6 Replies
View Related
Dec 21, 2005
Sorry All,
I have a simple question, how can I tell if my laptop has a wireless network in it. Thanks.
View 1 Replies
View Related
Jun 4, 2006
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 1 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
Jan 28, 2008
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 7 Replies
View Related
Feb 27, 2008
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 4 Replies
View Related
Jun 22, 2005
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 4 Replies
View Related
Apr 18, 2005
Does anyone know of any software or have any code that would allow to process credit cards.
View 4 Replies
View Related
Nov 15, 2006
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 1 Replies
View Related
Jun 30, 2014
I want to create a database that utilizes the user's ID card to authenticate them and tie any changes to their name.If not that way, using their stored information (SSN, or other ID) as a means of creating a username/password. I've never messed with creating different user levels in Access so this is uncharted territory for me.
View 6 Replies
View Related
Nov 3, 2007
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 1 Replies
View Related
Jan 14, 2008
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 1 Replies
View Related
Jan 8, 2005
i'm try to create a database to record staff sign in and out times and to get reports but i cannot for the life of me get it working after many many efforts. can any one help me?
View 2 Replies
View Related
Oct 23, 2004
I have got a dbase created however getting it to print in the order I need for the PVC Id card just is not working.
Any Ideas
thanks
Matt
View 1 Replies
View Related
Jun 26, 2014
I want to prompt the user to enter a merchant name, but want the results to return close matches.I know how to use the wildcard in the Criteria field of the query, but I want to use brackets.I know that "*Southwest*" Will return Southwest Airlines.So I tried *[Southwest Airlines]* and it treats the criteria like a text string.
View 1 Replies
View Related
May 18, 2013
I have a series of dates that I inherited from former DB. Some of the dates are Mon-Fri, Mon-Thu, Sun-Fri, etc. That is, there is a hyphen "-" in the middle of the text. I have an unbound control with an IIF statement using the LIKE condition, I just get an error. I tired the following to no avail. Using Access 2010.
IIF([Day1] Like "*-*", 5, 1)
IIF([Day1] like "-", 5, 1)
IIF ([Day1] like '-', 5, 1)
IIF ([Day1] like [-], 5, 1)
I've looked it up and the hyphen _ is used as a wild card character, but I need to include it just as a dash.
View 3 Replies
View Related
Jun 7, 2015
In fact, I have one principal d/b running on my access, ad/b which I had imported from my iPad... The import went smoothly enough but I face this problem. I usually scroll the table in order to locate a patient's name.
I can't find a way to select this line and have it switched to a card view in order to update it. I need to move to card view, search from there in order to locate this person in card view. I am sure there is a way to select a line ( a record) in table view and jump from there directly into this record in card view.
View 11 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
