Recent content by murph

All references appear to be correct but I'm obviously missing something. It works perfectly in a brand new database (with only those two fields present). I hope it doesn't come to it but if it works I'll just have to start it all over again!! Ken you're a star. cheers for your time and help.

Yeah I've tried the same formula in many new forms. I've even tried replacing DateOne with Date() and other values. I'm getting the same errors with completely different, but related code. For example: =DateSerial(year([StartDate]), month([StartDate])+6, day([StartDate]))which I pasted in...

TRied compiling and the module window highlights the "=" at the front of the =DateAdd... and a Microsoft Visual Basic pop up appears with "Compile error: Expected: line number or label or statement or end of statement"

Cheers Ken. I thought this was correct but it's definitely not working. The full pop-up error message I'm getting is "There was an error compiling this function. The Visual Basic module contains a syntax error. Check the code, and then recompile it." Could it be an underlying problem with the...

Hi guys, I'm fairly new to access but thought what I was trying to do was fairly simple. I could really do with some help. I'm trying to calculate and display a date 6 months in the future from "DateOne". DateOne is a manually entered field which is stored in a table. FutureDate is an...