need help regarding part of a database I am trying to get functioning. User scans a card with a barcode need to log the entry time and reduce a unit value by 1 in a table e.g user has 20 credits when they log in thier time is recorded and 1 credit is deducted from the 20 credits a warning is displayed when the credits are reduced to 1. I am a novice in this , am using ms access, thanks in advance
View RepliesI 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 RelatedI have a barcode input form. When a barcode is scanned, the value of the barcode, along with a date/time stamp using the now() function (hh:mm:ss) is entered into a table in the database as 2 separate columns. I need to make sure that I don't have any 2 barcodes with exactly the same date/time. They must be at least 1 second apart. How can I easily make this happen? I can't control how many times the barcode actually gets scanned.
View 3 Replies View RelatedI 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?
We have a date function that converts a text date format. Can someone help me with time function to do the same thing? We want military time. The field is like this now: txt fields.
160037
213137
224356
235716
235800
12341
21708
22732
Here is the date function we use:
Function f2Date(strDateOld As String)
Dim strDate As String, strMonth As String, strYear As String
strMonth = Mid(strDateOld, 5, 2)
strDate = Right(strDateOld, 2)
strYear = Left(strDateOld, 4)
f2Date = strMonth & "-" & strDate & "-" & strYear
f2Date = CDate(f2Date)
f2Date = Format(f2Date, "mmmm d yyyy")
End Function
Hi all,
was wondering if there was a simple way out there, or if someone could give me some ideas on how to use an admin function to either approve or deny a users time and tasks... this wouldnt neccesarily have to a be a daily function... but i would like to have this done before the end of a pay period(2 weeks).
i feel like this could be as simple as using a check box to show approval, but i wouldnt know how to have the users submission go into a place where the admin could view to approve or deny.. has anyone seen something like this done before?
thanks in advance
Is there some kind of Time picker function , i can see the date picker however i am using a booking system and have a field named 'time of booking' and i need something that can dump the exact system/online time into the field.
View 5 Replies View RelatedIn my DB that we use and a workflow tool, some of our work has and due date and time.If we get the complete_package our work time starts and we have X amount of time to complete our work. This is something i worked on but set it aside, now i am coming back to try and fine tune this so it returns a more accurate value.
So if we receive and [Date_Complete_Package_Received] at 09/13/2014 09:00:00 AM and based on the work being done we have 5 hours to complete the work, then the [Date_and_Time_Complete_Package_DUE] would be 09/13/2014 02:00:00 AM. That part is simple and i have coding that does that just fine. [SLA_Time] is where it gets the amount of time allotted, we have 5,10,12,14,and 16 hours depending on what is being done.
Code:
Me.Date_and_Time_Complete_Package_DUE = DateAdd("h", [SLA_Time], [Date_Complete_Package_Received])
This is done on AfterUpdate of a field on one of my forms and it works the way it is but what i need is to be able to run this through my Workhours Function so i am not getting values that our in off hours.The following doesn't work i know i can't use the Workhours function with the DateAdd but this is just to show what i am trying to do.
Code:
Me.Date_and_Time_Complete_Package_DUE = WorkHours(DateAdd("h", [SLA_Time], [Date_Complete_Package_Received]))
I have a Workhours module and it is used for a lot of things and it works perfectly.
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
I would like to use barcode translation of text and numbers and print on labels. Has anybody experience with that, and how to do ?
Rudi
Hi,
I need to be able to run my database in the background but i still need to be able to input data from a barcode scanner is this possible. I have worked out how scan bar codes but when the application is minmised it no longer accepts the barcode data.
Cheers Phill
Hi All
I am wanting to use a barcode scanner to input data into a field and bring up details based on the barcode. This is simple enough as long as the field you want to scan into has focus. Is there a method which will automatically populate the correct field with the scanned data no matter where I am on the form.
Thanks in advance.
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.
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
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
Hi,
I am using the downloaded "IDAutomation code 39" font recommended in this forum. It works great on laser quality reports and the scanner reads the codes fine.
But when I try to print to a Zebra TLP2844, the labels are intermittently faint, and not readable by the scanner. The whole label's quality is very sub standard.
I have been reading about the Printer and someone else suggested that I need a template stored in the printer and feed in the data to this template??
Has anyone had any experience with this type of printer / problem??
Many thanks
Dazadd
Hello,
I have a problem printing barcodes; my reader will not detect the printed barcode. Others work and I do not usually have a problem but here I go.
I have a simply table with fields ‘Room’ and ‘Shelf’, then I have a form that print these for scanning. Once scanned we have a program that uploads the barcodes and puts them into the separate Room and Shelf fields within our database.
Here are the examples of code I have been trying to be able to capture the barcodes:
="*"+([Shelf!Room]+shelf([Shelf!Shelf]))+"*"
="*"+([Shelf!Room]& shelf([Shelf!Shelf]))+"*"
="*" & [Shelf!Room]+shelf([Shelf!Shelf]) & "*"
Any ideas would be greatly appreciated.
Thanks.
Hi Guys,
This might be pretty simple, but I haven't found anything on it (might not have looked hard enough!). What I am trying to do is scan a barcode label that I created in Access, when this is scanned, it goes to a table and opens the record that contains this ID and allows me to enter further data in this record. The further data will be data capture from a balance, which works fine if you select the location where the data is to go (using the mouse), what I need is for this location to be automatically accessed when I scan the barcode, hope that makes sense.
Also, is there any way in Access to either prevent data in a table from being changed once it is entered, or alternatively to mark the data as changed/edited from the original input?
Any help would be greatly appreciated.
Nigel
Hello:
Does any one know where I might locate a free 2d datametrix barcode font to you in access. I tried google, but not having much luck.
thx
Hi Guys,
I've tried searching the forum to no avail,
I have a table (tblBarcodes) that has two fields, Barcode & Material
The Barcode field is already populated with specific numbers, but what I need to do is when I enter a new material on my form it will assign it a barcode from the tblBarcode and then append the Material code to the that table against the relevant record.
Is this possible?
Thanks again
Sorry for the flashy post.
1.st Job:
I have an access 2003 db. I want to implement barcode system to the DB in which I can print barcodes in any kind of barcode printer and also when imputing an order read data from barcode scanner etc.
2nd Job:
I want to put access db to a server so I can view reports, forms, imput data and retrive data from internet explorer window (with a password).
I will give my DB to you so you can work on it. Please do the pricing seperate for each job.
Please PM or Reply if you have more than 500 posts. PLEASE RESPOND IF YOU REALLY KNOW HOW TO DO IT.
Thanks in advance.
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
My client is a baseball league who started a Kids Club which has membership cards that have a barcode and their own specific number to monitor the number of times that the KidsClub members come to the games. They don’t have any software to go with the cards though. They asked me if I could help. I created a simple table in Access to capture the name, address, telephone, email, number of games attended. The cards have a barcode on them, and they would like to be able to scan the card with a USB handheld scanner and have the number of games attended field to be updated by the scan. Each card has its own number that is programmed into the barcode, which could be the primary key for Access. Can you offer any assistance in how to get the scan of the card to update the "number of games attended" field I created based upon the barcode number?
View 6 Replies View RelatedI am using a special font called Interleaved 2of5. You have to have macros enabled and the font package installed to get this font package to work. I have everything working perfect, I can print reports directly out of Access with the bar code perfect.
Here is my question:
Can anyone figure out how to get this to work in a query?
We have a couple mail merge documents set up in Word and I would like this same bar code to be at the top of the page.
I cannot find a way to get the BarCode to work in a query, only the report. I do not know if this is possible. Here is a sample database that comes with the program.
hi guys, i am slowly learning access by browsing these forums and using microsoft help and downloading example databases. problem is - i have no formal training in it and am just sort of poking around. how did you guys learn? is there a good book out there to read, or did you take a course in it?
right now i am trying to develop a database of tracking product through a factory. technicians would scan the barcode for a pump before and after every process. i made it a simple table coupled with a form where they input the barcode # and a timestamp was coupled with it. later, youd be able to graph the time stamps so you can see process times, how many are in work in process, etc.
my specific questions are:
when i use the timestamp feature, it updates the time when a new record is brought up, but i want the timestamp to register when they click the add entry button. so far i have the default value =Time() for one, and =Date() for the other ...
next is, i want each workstation with this open to have its own unique identifier. for example, one program in assembly station should automatically input "assembly" for where the record was added in, how is this done?
lastly, i have a barcode scanner that operates like text input, i have an area on the form for the barcode, so when it scans it enters the number. is there a way that once the field gets 8 digits entered into it, it automatically goes to the next field on the form? i would like for users to pull the trigger and not have to hit enter again ...
a big THANK YOU for all you access gurus, i have been browsing these forums learning a lot. i hope i can achieve your level so i can help others as well. Thanks again
- Dave
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() ...