This may be more of an Access question than a VB question but I am not overly familiar with either so I am trying to cover all bases.

I need to convert local time to UTC (GMT) in a MS Access application.

The application presently uses a simple VB routine to add either 3 or 4 hours to the local time depending on whether we are on DST or EST time. The problem is that we have to manually change this 3 to a 4 and vice versa in the spring and the fall.

VB has a built in to handle this as shown below.

Dim saveUtcNow As DateTime = DateTime.UtcNow

This would give me the UTC time in saveUtcNow.

When I try to get this VB code into MS Access it won't buy it. I am wondering if I need to include some other code ( a further declaration or an import ) into the MS Access VB window to get it to work.

Thanks
Zapper