Search results

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

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 (Me.Ref & "") is the same as IsNull(Me.Ref) and Me.REF & "") = "" is the same as IsNull(Me.Ref) OR me.Ref = "" ?

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

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

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

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

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

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

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

Sorry its DLast that i was testing out, but these are the extra fields that i would like to populate instantly after the serial is scanned. I was hoping to find something other than creating another 9 Dlast fields

Hi, thanks for the quick reply. (sadly i have a history of bad field/table naming although i thought the "_" undescore seemed to be ok) Our business is refurbishing, building, handheld devices. Most of which have a unique serial number. When these items are booked in, sent to the workshop...

Hi everyone. In my database its normal to scan a serial number for an item and see where it was last used (Movement, Shipment, etc) Currently I have a form with a textbox to enter the serial and then a query displaying the related movement from the movement table. But I would like the user to...

Sorry for the late reply. Thanks for the extra help and explanation, its really appreciated. I really need to find some good starting point for learning VBA, SQL etc, im ok with incredibly basic if's and me.something = but beyond that whenever i try to read what someone has written it just...

Yer thats brilliant it seems to have done the trick. so: aworkdays function it was just 80 If DCount("*", "tblHolidays", "HolidayDate=" & SQLDate(TempDate)) = 1 Then The SQLDate was because i changed the format? it seems so weird that this function has mm/dd/yyyy format and yet its fine...

I've attached a copy here if anyone would like to play around at all

Thanks for the info about the formatting where and when guys, And thank you for the suggestions. Im sure this is very clear for you but im really not sure how to actually execute these suggestions. sorry guys SQLDate, i have no idea if i tried it correctly, the function was not working when i...

ah ok, i didn't understand then, so i paste that function into a new module and then i call it from the aworkdays function somehow? Sorry this my knowledge is impressively limited

Okie dokes, thanks, I had a read and understand i believe. i'm just having a google as to how i format the dates in the Dlookups