Dealing with 'if null' syntax when locking old records (VBA)

[Sharky II]

Hey there!

I could - but is that what would be causing the error/date to be filled in - do you think? I will try to remove the date formatting on the form field and see if it fixes the issue, and report back (not at my machine right now, will try tonight!).

I'm also not sure what this means for the date that is actually stored in the table.

Anyway, I was thinking that it was to do with the code throwing an error because it was looking for a TransactionItem field which didn't exist yet...

Cheers

Eddie

 

[vbaInet]

Actually look in the Format property of the textbox and tell us what it reads.

 

[Sharky II]

The format property for the text box on the main form OracleClearDate is mm/yyyy

This is because the employees only get/know their oracle dates by month, so even though really they're entering any day in that month, really the main thing they want to see is the month, so it works 'ok' for this purpose...

If i remove the format property for the text box altogether and create a new record (Without any 'items'), then the text box shows 00:00...

 

[vbaInet]

I'm guessing RG is looking into the problem as well?

I would imagine it may be a Default Value set on the field or the control that is causing it. Upload a stripped down version of your db and I'll have a quick look.