On Wed, 2 Jun 2010 17:55:49 +0100, "Peter Kinsman"
wrote:

A client using Terminal Server is in the process of upgrading from
Server2003 and SBS2003 to the 2008 equivalents. A number of built-in
functions such as Format and Date are causing problems.
As an example, I created a new database with a form displaying Now() Date()
and Format(Date(), "dd/mm/yy"). When in its own database, the form
displayed correctly, but when exported to an existing database it didn't,
which makes me think that something about the structure of an empty database
has become corrupted.

This is a symptom of bad or missing references. From the VBA code
editor, choose Debug..References. Correct any missing references.
It's likely that you have some references to components that were on
your old server but not on your new one.

If you have references to other Office applications (like Word, Excel,
etc.) you may want to consider using late binding instead of early
binding. There are many articles on that subject.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com