By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,608 Members | 1,698 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,608 IT Pros & Developers. It's quick & easy.

Access2007 - adding a date to a memo field

P: 2
I keep a database of projects. I have a memo field in which I keep dated notes about the status. Above the memo field is a button called "update date." When I click on the button it adds into the memo field a bullet the date and the dash "• 01-07-2008 -"

There is an on click event procedure associated with the button and the code at the back end looks like this:

Private Sub Command73_Click()
Me.Recent_Update = Me.Recent_Update.Value & "• " & Date$ & " - "
End Sub

There is also an event procedure associated with the memo field:
Private Sub Recent_Update_BeforeUpdate(Cancel As Integer)

End Sub

The problem is that once I upgraded to Access2007 I click the button and nothing happens. What do I need to change to get this working again?

Sep 9 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,532
Does any code work? Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location.

To trust your folder, click:

Office Button (top left)
Access Options (bottom of dialog)
Trust Center (left)
Trust Center Settings (button)
Trusted Locations (left)
Add new location (button)

Welcome to Bytes!

Linq ;0)>
Sep 9 '08 #2

P: 2
Hooray! That did it!

Thank you so much!
Sep 9 '08 #3

Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Sep 10 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.