Barcode Reading And Security
Jan 30, 2007
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
View Replies
ADVERTISEMENT
Nov 25, 2014
I will have a PC and a number of scanners in a production line. I will need at least 15-20 scanners and would like to plan for more if needed. When an operator clicks on a button I would like to have each of the scanners triggered and return the value. They can be done in turn or all at once (preferred for speed). I need to know which value came from each scanner. I would then compare the barcode read at each station versus what is supposed to be at that station and either pass or fail.
View 2 Replies
View Related
Jun 16, 2005
I didnt find answer to my question!..
Hope someone here can help..
I just added security to my access application...
I have added a new user and gave all admin rights. Removed all permissions from Admin and Admins group. When I log on as this new user who is equivalent of Admin,
I am able to doubleclick the table(linked table) and modify/delete the data..but when I the form is executing, it says, "Records cannot be read, no read permission on <Table>"
Hope someone can answer my question.
Thanks very much.
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
Mar 26, 2007
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
View 4 Replies
View Related
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
Aug 13, 2007
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
View 1 Replies
View Related
Nov 2, 2007
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
View 1 Replies
View Related
Mar 25, 2008
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.
View 2 Replies
View Related
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
May 19, 2005
I'm fairly new to access (now using for work purposes) and i've become a bit stumped...
I have a database set up and running fine, however I want to be able to generate a form in one database from a table within another. Is this possible?
Thanks for your input, It will all be apreaciated.
skelmer
View 2 Replies
View Related
Nov 16, 2004
Here's my situation. I have a .txt file that I need to bring into Access. This .txt file is set up with records that are separated by semicolons.
I need to pull this information into Access and separate the data by the semicolons. I can open the file in Excel and separate the information by using Data --> Text to Columns --> semicolon (as the separator).
Does anyone have an idea how I can do this into Access.
View 2 Replies
View Related
Dec 24, 2006
on the audit trail modul
when the field is combo box I need to capture the combo's column(1) to my audit trail table
i used the code :
If TypeOf ctl Is ComboBox Then
rst("OldValue") = ctl.OldValue.Column(1)
End If
but it's not working
can any one help me with that
many thanks in advance
View 1 Replies
View Related
Nov 19, 2004
I am working on searching my customer number in my billing table and finding the appropriate customer and then pass the customer number onto my shipping table to find the corresponding shipping data to go with my billing data. My problem is this :
When I find my customer in my Billing table ( searching through field0 = CustomerNumber)and then select it, it won't pass the customer number to continue to search field0 in the shipping table for customers that have a # in any of the cell values of the recordset.
Is there a work around for special characters in cell data ie) #
Any sugestions or comments would be greatly appreciated.
View 4 Replies
View Related
Nov 23, 2004
I have a linked spreadsheet. Access is not pulling certain records from the field DOD. The code I used is as followsSELECT final.[SSN P ], final.TXPD, final.[TC-530], final.[TC-150], final.[ DOD ], final.[ DOB ], final.[SSN S ], final.[TC-421], final.[TC-420], final.[TC-424], final.[TC-540], final.[LFRZ-RFRZ], final.[TC-590], final.[TC-591], final.[TC-594], final.[TC-599], final.[TC-290], final.[TC-291], final.[TC-300], final.[TC-301], final.[TC-976], final.[TC-977]
FROM final
WHERE (((final.[TC-530])="TC-530")) OR (((final.[TC-150])="TC-150")) OR (((final.[ DOD ])="dead")) OR (((final.[ DOB ])>1929 And (final.[ DOB ])<1986)) OR (((final.[SSN S ]) Is Not Null)) OR (((final.[TC-421])="TC-421")) OR (((final.[TC-420])="TC-420")) OR (((final.[TC-424])="TC-424")) OR (((final.[TC-540])="TC-540")) OR (((final.[LFRZ-RFRZ])="-AL")) OR (((final.[TC-590])="TC-590")) OR (((final.[TC-591])="TC-591")) OR (((final.[TC-594])="TC-594")) OR (((final.[TC-599])="TC-599")) OR (((final.[TC-290])="TC-290")) OR (((final.[TC-291])="TC-291")) OR (((final.[TC-300])="TC-300")) OR (((final.[TC-301])="TC-301")) OR (((final.[TC-976])="TC-976")) OR (((final.[TC-977])="TC-977")) OR (((final.[LFRZ-RFRZ])="-ALR")) OR (((final.[LFRZ-RFRZ])="-L")) OR (((final.[LFRZ-RFRZ])="-LBR")) OR (((final.[LFRZ-RFRZ])="-LBRK")) OR (((final.[LFRZ-RFRZ])="-LR")) OR (((final.[LFRZ-RFRZ])="-LRF")) OR (((final.[LFRZ-RFRZ])="-LRKF")) OR (((final.[LFRZ-RFRZ])="-LW")) OR (((final.[LFRZ-RFRZ])="-O")) OR (((final.[LFRZ-RFRZ])="-OLR")) OR (((final.[LFRZ-RFRZ])="-V")) OR (((final.[LFRZ-RFRZ])="-VL")) OR (((final.[LFRZ-RFRZ])="-VW")) OR (((final.[LFRZ-RFRZ])="-W"));
For some reason the DOB and DOD fields are not being recognized. Please help.
View 2 Replies
View Related
Dec 9, 2004
Is there a way for a access to read the filenames of files contained in a folder on the local machine and paste
those filenames in a database field?
View 1 Replies
View Related
Jan 4, 2006
Hi guys, Im working on a DatABase at the mo that is heavily featured around forms - the problem is I dont have a clue about how the code side of it is structured in access. I know a lot about visual basic, and I've been having pot shots at how to do this, but with no success...
How do I read the value of an object from a subform with macros? Lets say on my main form I have a textbox called 'ExampleTXT' - to read a value from the text box would be simple...
Code:msgbox Me.ExampleTXT
but on this form I also have a subform, which contains an array of textboxes (they link to a seperate table, so there can be any number of these textboxes) and they have the name 'ExampleARR'. How do I read the values from these? I have tried the following code (like I siad, these are random stabs in the dark) but I have had no success...
Code:msgbox Me.ExampleARR--msgbox Me.ExampleARR(0)--msgbox Me.SubFrm.ExampleARR(0)
PLEASE HELP!
View 3 Replies
View Related
Jul 22, 2013
I am very new to Access and I am not a programmer at all. Something in my program changed and I am stuck on how to correct it. When I look at the front end everthing looks fine. When I look at the back end one of my fields are no longer reading correctly. I get the message error code 2465
View 14 Replies
View Related
Jun 26, 2015
I have a command button on a Access 2010 form that i am using as my switchboard. On this form i have a hidden unbound text box that captures the users environ"username". When the user hits a command button on the form the code looks at the name in the hidden textbox that captures the environ"username" and then DLooks up a table to see if there is a match. If yes then it will open the next form and if not then a message box appears.
Code:
Private Sub Command6_Click()
Dim TxtUsername As String
If Me.TxtUsername = DLookup("[OneLondon Login]", "TblAccessUsers") Then
DoCmd.OpenForm "Bakerloo_Main_Form"
Exit Sub
Else
MsgBox "You do not have permission to access this database"
End If
End Sub
This works fine apart from the fact it will only read the first name entered in the table. This table(TblAccessUsers) could have up to 50 names in it and possibly have names removed and re added at a later date. Is there a way i can get the code to look up every name in the table ??
View 3 Replies
View Related
Sep 10, 2005
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 1 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
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
Jan 15, 2006
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
View 6 Replies
View Related
Mar 13, 2007
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.
View 1 Replies
View Related
Aug 17, 2006
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
View 1 Replies
View Related