unkown function 'format' in validation expression or default value on 'patients.CreatedDate'.

Question

Hi all im getting this error when trying to open my database, the person who created it is no longer with us (RIP) and I don't know of anyone else who could help

when opening the database I get this message

   unkown function 'format' in validation expression or default value on 'patients.CreatedDate'.

any help would be greatly appreciated

thank you

Answer 1

Hi,

Double-check your references and make sure none is missing. If so, you'll have to fix it.

Hope it helps...

Answer 2

Hi

Access 2000 and 2002 users:

Many code solutions in Access 2000 or 2002 require the Microsoft DAO Library.

If Database or Recordset gives an "unknown type" error, set your References.

(All other versions have this reference by default.)

See http://allenbrowne.com/ser-38.html

I hope this helps.

---

JG