[AccessD] Before update problem

Many thanks to all who replied. It was indeed the "potentially harmful
content".

Douglas Barnes

Starn Technical Services
P.O. Box 1172
15957 Conneaut Lake Road, Suite 7
Meadville, PA  16335
P: 814.724.1045
F: 814.337.3460


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of A.D.TEJPAL
Sent: Thursday, June 14, 2007 2:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Before update problem


Doug,

    Nothing wrong with your code. Apparently it is in disabled state,
typical when Access 2007 file opens.

    On opening the file, just make sure that you enable the "potentially
harmful content" in "Security Alert" dialog box, invoked by clicking
"Options" button in the "Security Warning" message.

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message -----
  From: Doug Barnes
  To: accessD at databaseadvisors.com
  Sent: Wednesday, June 13, 2007 23:49
  Subject: [AccessD] Before update problem


  Hello listers

  I'm having a devil of a time. I want to update a Date/Time field when/if
the data has been changed on a form. The form is bound to a table and all
fields on said form are bound to fields in the table.

  Access 2007 Trial version
  Windows XP sp2

  Here's what I've tried so far:

  This didn't work
  Private Sub Form_BeforeUpdate(Cancel As Integer)
      Me.QUOTEDATE = Now()
  End Sub

  Any help would be grateful

  Doug Barnes
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com