Date Reference

[CBragg]

Im having problems with Dates but only using Windows XP and runtime.

There isn't any references missing as such, but does anyone know if there is a specific date on i can add, just to see if this will solve my problem.

I doubt it will work but im running out of ideas!!

Thanks in advance.

 

[KenHigg]

'but does anyone know if there is a specific date on i can add'


???

 

[CBragg]

A Date Reference, sorry, mistype.

 

[KenHigg]

Are you getting error messages? If, so what do they say?

 

[CBragg]

Its a very confusing situation which i'll try and be brief about.

Ive got a database that works fine with Access 2000 Runtime and Windows 2000, however when ive put it on a Windows XP machine it comes up with a runtime error. Ive narrowed it down to the format function:

Format(Now(),"dddd")

For some reason it doesnt recognise it. The regional settings are fine and it has worked on one XP machine, but the majority ive tested failed.

Ive got XP on my machine and the full Access 2000 and this also works fine.
Hope this makes sense

Any ideas??

 

[KenHigg]

Are there any other options to the 'dddd' format?. Could you use 'ddd'?

 

[CBragg]

Not if i can help it. I think the problem lies in the format function rather than the criteria im specifying.

 

[Rich]

You have a missing/broken reference, search here for solutions

 

[KenHigg]

Not really sure about this, but have you tried setting the project calendar propery.

Calendar = vbCalGreg

or

Calendar = vbCalHijri

???

 

[CBragg]

Thanks for that Rich, had to unselect my references then re-apply them.

Never came accross that before!!

Cheers everyone for your time.