Recent content by dale_j1992

  1. D

    DLookup with multiple criteria

    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:
  2. D

    DLookup with multiple criteria

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

    Help Modifying a piece of VBA

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

    Help Modifying a piece of VBA

    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)...
  5. D

    Help Modifying a piece of VBA

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

    Vba Dcount please help :)

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

    Vba Dcount please help :)

    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"...
  8. D

    VBA ISSUE When using information on either 1 or another form

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

    Please help :((

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

    Viewing attachments from form (Datasheet view)

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

    Viewing attachments from form (Datasheet view)

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

    copying value from combobox on one form too text box on another

    Many thanks this worked :)
  13. D

    copying value from combobox on one form too text box on another

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

    Rfid form help

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

    creating multiple records with one form.

    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
Top Bottom