P Pappy Registered User. Local time Today, 10:13 Joined Jun 12, 2003 Messages 28 Jun 12, 2003 #1 I need to create a time stamp in a field called "letter mailed" when a button is clicked. I know you have to use VB code, but I'm having some trouble getting it to work. Please kind I'm new to this... Thanks
I need to create a time stamp in a field called "letter mailed" when a button is clicked. I know you have to use VB code, but I'm having some trouble getting it to work. Please kind I'm new to this... Thanks
W WayneRyan AWF VIP Local time Today, 16:13 Joined Nov 19, 2002 Messages 7,122 Jun 12, 2003 #2 pappy, In the OnClick event for the button, put: Me.[Letter Mailed] = Now() If you didn't put the space in there, you could: Me.LetterMailed = Now() Wayne
pappy, In the OnClick event for the button, put: Me.[Letter Mailed] = Now() If you didn't put the space in there, you could: Me.LetterMailed = Now() Wayne
P Pappy Registered User. Local time Today, 10:13 Joined Jun 12, 2003 Messages 28 Jun 12, 2003 #3 It says this record set is not updateable. I'm adding it to a text box.
W WayneRyan AWF VIP Local time Today, 16:13 Joined Nov 19, 2002 Messages 7,122 Jun 12, 2003 #4 Pappy, What is the record source for the form? Is the text box bound to that? Need more info, or Compact, ZIP and post the db. Wayne
Pappy, What is the record source for the form? Is the text box bound to that? Need more info, or Compact, ZIP and post the db. Wayne
P Pappy Registered User. Local time Today, 10:13 Joined Jun 12, 2003 Messages 28 Jun 12, 2003 #5 The form is taken from a query which is from a master table list. The text area currently has nothing in it but is bound to the query.
The form is taken from a query which is from a master table list. The text area currently has nothing in it but is bound to the query.
