Search results

Ok.. its been a while since i last used VB in Access and i got a bit rusty, and tbh i remember nothing :P Am trying to figure out a script to use in a field ( Due Return Date ), that will take a Date value from a specific field (Date Loaned) and will add 2 to the date. E.g Date Loaned...

bleah.. somethin went wrong and it aint working any more :( :( there's an empty value

ok.. trying to do a workaround now which i think its working.. ive just created a "DaysLoaned" field in the table, with no value in it and i think its working now :) now, am not sure if i can make calculations from the value in "DaysLoaned" but ill have a go.. thnx for all the help :) if i...

Tried this code, but all i get is -15 for all fields and i think the -15 comes from the 1st record in the table. :( Also tried Brian's code, same problem.. all have a -15 value (regardless if its more than 0 or less)

still not working :( i was wondering.. shall the text box be left unbound? or shall i enter a value?

ok.. lemme try explain again.. 1) Am trying to find the difference between one date and the today's date (both fields found in a table) 2) I wanna make this written down in the text box of the form as an integer (field is not in a table, but custom created in the form) 3) If this value is...

still doesnt work :( i get #Name? now

lol .. oh sh*t .. good point :P :o

ok.. followed your steps, still quite doesnt work ( nothing appears now ). 1) Its a text box (manually created in design view so no field in a table) 2) Its set to "unbound" 3) i think brian was right about the syntax.. but still doesnt work 3) here's the modified code: If Me.DaysLoaned >= "0"...

Hello, am trying to make a code, that will set a value in the specific field only if the current value is more than 0, but i cant get it to work... here's the code: If Me![DaysLoaned] <= 0 Then Me![DaysLoaned] = Int(DateDiff("d", Me![DueReturnDate], Date)) Else Me![DaysLoaned] = "Doesnt Apply"...