mysterious lockup of form half-way through ADO code

[Sirocco]

The following expression works on my PC running Windows NT.

!BeginTime = Now() + #12:00:04 AM#

It puts the current time plus 4 seconds in the field called BeginTime.
(generally, the VB is the ADO version)

On a different PC, running Windows XP, it also works (I know because the
field has the current time plus 4 seconds added to it) but then Access
completely locks up, the rest of the procedure doesn't execute, with no
error message, and I have to ctrl-alt-del to get out.

What the heck is going on?

I'd appreciate any response.

Thanks.

 

[Graham R Seach]

Whether you're using ADO or DAO is irrelevent, because the code in question
is VBA.

You should really be using:
!BeginTime = DateAdd("s", 4, Now())

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Sirocco]

Thank you, it works.

Whether you're using ADO or DAO is irrelevent, because the code in question
is VBA.

You should really be using:
!BeginTime = DateAdd("s", 4, Now())

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html