Recent content by Jordonjd

  1. J

    Solved IF OR AND statement vba, multiple conditions

    Its going to take me a few days to understand these as I cant read them, but thanks I will definitely try and figure them out and utilize them
  2. J

    Solved IF OR AND statement vba, multiple conditions

    its just the tip of the iceberg for me haha
  3. J

    Solved IF OR AND statement vba, multiple conditions

    haha I can only imagine what you guys must think sometimes when you see what and how people like me try to do things. I am looking for some good starter course to get into, maybe udemy or something I managed to get it working by adding a cancelevent at the very bottom of everything and using a...
  4. J

    Solved IF OR AND statement vba, multiple conditions

    I have made these changes and the it seems fine now. the only problem is the code continues as the error message as if it was ok but I think that is due to other statements I have further down which I guess aren't reliant on the results of this this statement.. I will have a look at the...
  5. J

    Solved IF OR AND statement vba, multiple conditions

    Right Chaps, I have done my best, and everything is technically working except the last: If Me.[+/-] = "-" Then By working I mean it seems to work and also then carry on the code from Line1 .. all except the last one, it seems to just stop at its end if ? Select Case Me.Move_Reason Case...
  6. J

    Solved IF OR AND statement vba, multiple conditions

    ahhh ok, sorry my VBA knowledge is awful. So the & is the concatenation So (me.Ref & "") = "" ( [field] concatenate with "empty string") = " empty string" If the field is null then it will = "" If not then in then = me.ref value And I guess my Not Isnull() is actually redundant because if...
  7. J

    Solved IF OR AND statement vba, multiple conditions

    Thanks, So (Me.Ref & "") is the same as IsNull(Me.Ref) and Me.REF & "") = "" is the same as IsNull(Me.Ref) OR me.Ref = "" ?
  8. J

    Solved IF OR AND statement vba, multiple conditions

    Thanks so much, I had about 8 levels different "Move_Reason" with different criteria, could I add an ELSE and the another CASE and another IF and continue like that? How you guys have this info immediately to hand is great, i cant even google the right question 99% of time to try and find...
  9. J

    Solved IF OR AND statement vba, multiple conditions

    Hi everyone, I have a very long If statement which i have realised only applies the "AND" to the last "OR" I have entered. Basically i have a dropdown box and once the record is complete, depending on the "Move_Reason" certain fields can or cannot have certain data in them. Some "Move_Reason"...
  10. J

    Serial Number Search Form (enter list of serial and see latest related movement for each record)

    I'm going to have another crack at it all tomorrow. I have some area's to look at now. Thanks for the advice, Thanks everyone else for their advice and input as well
  11. J

    Serial Number Search Form (enter list of serial and see latest related movement for each record)

    Otherwise, i think i will just create a form, using the Empty table, the user can scan the whole list of serials in there, then i'll run a query that populate a subform or something that is next to this list and sort both lists the same so they line up with one another
  12. J

    Serial Number Search Form (enter list of serial and see latest related movement for each record)

    Well, because there could be multiple records on the movement table i had to "group max" for [move id], [Serial_Number] on an underlying query so there would only be one result available for a serial number, (originally the Dlast solved that for me) The idea is the Serial table stays empty...
  13. J

    Serial Number Search Form (enter list of serial and see latest related movement for each record)

    i've been playing around a bit but the recordset isnt updatable etc, tried separate queries etc to make the right side unique records..
  14. J

    Serial Number Search Form (enter list of serial and see latest related movement for each record)

    Thanks again for the quick reply. i think in my attempt to explain the situation i made it more confusing. The idea was to build a form that looks like an empty datasheet, with many empty columns Then someone could scan a Serial number into column 1 creating a new record each scan, As each...
  15. J

    Serial Number Search Form (enter list of serial and see latest related movement for each record)

    Yes in a manner of speaking that is the general gist of the steps and other data is held and related in the DB. This request about the form is for the specific scenario is "What are these devices doing here, where did they come from?" Instead of scanning each serial and looking the history up...
Top Bottom