Search results

Morning All i am having some trouble with the following code. Private Sub CRANK_1_Change() Dim Answer As Variant Answer = DLookup("[Barcode]", "tbllogfurnaces", "[Barcode] = '" & Me.CRANK_1 & "'" And "[FURNACELOADNUM]", "tbllogfurnaces", "[furnaceloadnum] = '" & Me.FURNACENUM & "'") If...

Morning All :), I Hope everyone is well. I am still fairly new to access, and not a frequent user so go steady on me please.:eek: With a current database i have this piece of VBA code that checks a barcode has been entered on the previous station/table before you can scan in on the current...

Hello all, i relatively new and have not used access in many months, i have slight issue any help would be greatly appreciated. I currently have a textbox which i enter a barcode using a scanner, this triggers the following code. Private Sub TxtBarInp_AfterUpdate() If DCount("barcode"...

Good Afternoon Everyone. I am relatively new to VBA, so any help would be greatly appreciated :). I have got a database where there is two options to LOG in, one being a password the other is done using a RFID CARD, this is all working perfectly. My issue comes when i need to isolate what...

Good morning i have been having a problem trying to get some code working, any help is much appreciated. Basically i have the initial form which the user scans an ID Card to log them in, this works perfectly, however i have added the option to press a command button to which opens a second form...

Good evening, i am currently creating a subform that will be shown in datasheet view on my main form. i am doing this just to show recent records of inspection results in a datasheet format, i have got an attachment field which is an in image, is there any way of setting up this datasheet form...

hello i have a small problem i believe someone may be able to help me with :), i am trying too write some Vba to copy the value of a combobox on one form too a text box in my second form. i have some code that does what i want however it copies the autonumber id field (which is collumn 1 in my...

Good evening i have an issue i just cant seem to resolve, i have a table where the primary key is a 10 digit number RFID number, and the second column is USERNAME linking the Unique RFID number with a username. i want to create a form where on open it is blank and the focus is set to the RFID...

good evening, i am in the process of making a database to record the booking out of PPE equipment however i have reached a small issue when operators are having too book for example ear plugs and gloves because they are having too complete the form 2 times which is wasted time. Is there any way...

Hello i have a little problem i am hoping someone can help me with. I am trying to sort using a query, i want to show all records with a checkbox checked first in Date Order, followed by records with checkbox unchecked second i n Date order. Any help is greatly appreciated. Kind regards :D

hello, i am new too access and have been stook with this issue for a while now. i have a barcode which is scanned in, how can i get ms access to add the area and part name to the fields. i have a table with the part number as the primarykey, column1 line and column 2 part name. i then have a...

hello everyone, i have a small issue i need help with if, any help is much appreciated. i have a database in which i have a created a user log in function, i have it working too allow me too code what areas of the database you can see depending on authority levels i have set. However i have an...

hello i asked this question before but from the answers I received i dont think i explained it very well. i have a table with the following headers Id, Barcode, part, Size, Date, Operator name. i have then set this up on a standard form, on opening the focus is set too the barcode field, the...

hello my name is dale, i am from coventry United Kingdom. i have been using access for the past 6 month, completly self taught. I am here for help but i will do my best too help out if there anything i may have learned in the past few month that someone else needs :) regards

hello, i am currently in the process of making a database where the end goal is to able to scan a barcode and store part measurement data against the barcode. i currently have a form where the first field is generated by scanning a barcode, the barcode consists of 12 digits the first 7 being the...