Recent content by PMOB

If you're doing this via a macro you can also use the Transferspreadsheet function - it will overwrite the existing files without asking.

AJ - I tried your format but it still didn't work but I ended up developing a work-around for the problem. Since I can get this to work via an unbound text box I use on one the form to display the correct date. The unbound text box control is set to = [FIELD 1] + 547. I then set the AFTER...

I’m having trouble calculating a date field and was hoping someone could assist me. I have two bounds fields on a form – both fields are a “medium date” format both in the table design and the form view properties. Field #1 = is a user entered date I want Field #2 to be = Field #1 plus 18...