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

  • 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

    Friday, September 14, 2018 12:41 PM

All replies

  • Hi,

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

    Hope it helps...

    Friday, September 14, 2018 3:02 PM
  • 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

    Saturday, September 15, 2018 2:59 AM