Search results

Afternoon Gasman, Thanks that worked perfectly. All sorted now, i was just not sure how to lay out the code with multiple criteria. Kind regards :cool:

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 Isladogs, I apologise, having read the link i fully understand what you mean. Sorry for any issues my cross posting has caused, i was just being a little naive hoping to get help quicker. Kind regards

Morning Minty :) Firstly many thanks for your reply. This method worked great, however i have just thought i can secure the process much better with a small adjustment. i just think i have a few issues with way i am laying the code out. Private Sub TxtBarInp_BeforeUpdate(Cancel As Integer)...

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...

Thanks for your reply. Basically i have a computer set up on the line (station 1), the operator scans a barcode on the part, the code i posted above currently searches my table to see if the barcode has already been scanned/used, if it has it prompts you if you wish to overwrite, if the...

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...

Hello thanks for the reply i am relatively new too access could you help me out with were i need to insert that code and what i need to change to suit my database. many thanks

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...

Many thanks this worked :)

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...

Many thanks for the reply, i am relatively new to access is there any chance you could show me a sample of this as i am struggling from your explanation how to do it, if you cannot is there any links you know of which would show me in more detail how to achieve this. kind regards

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...

Many thanks that worked perfectly, i was not aware of the left to right corresponding to order.

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...

many thanks for the helpful comments, you have prompted me too look at another solution. i have used this code me.inspector = forms!frmlogin!cbouser, i have tried multiple usernames an this inputs the user id into the textbox that ties in with the respective user who i logged in with, is there...