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