Format("01/01/03","ddd") Acc2000 cant read

[sonnierock]

1) I uses Access 2002 to program a set of Query using Format("01/01/03,"ddd") which is save by default to Access 2000 file-format. However when I run this Query in another PC with Access 2000 the Query did not understand the term Format. Any ideal...I suppect its the version of VBA.

2)I know that there is a runtime engine for Access 2000 is there a runtime engine for Access 2002? Is it free?

Thanks

 

[DES]

The problem with 2000 not recognizing the Format command is a result of a bad reference. If you go into any module window and then go to the Tools - References menu option it will tell you which one is missing.

As for the runtime for 2002 yes there is one - on it is not free.