Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Auto-insert text to memo field

I *think* what I need is an update append query! - If a user clicks on a command button, I'd like a field in my table (called memotext) to be updated (i.e. be appended to) with the date, time, NT username and a string like "Customer report was printed".

Lap
0
Lapchien
Asked:
Lapchien
1 Solution
 
jadedataMS Access Systems CreatorCommented:
I would agree with you..

  UPDATE TableName
  Set [MemoField] = ([MemoField] & vbcrlf & UserName & " - " & DateTime & " - Customer report was printed")
  WHERE ([PrimaryKeyField] = sPKVariableToIDThisRecord)

In addition you are making the edit in a manner consistant with how M$ has recommended,....One swipe edit.

Piece meal or typing edits to memo fields are more prone to corrupting the content of the memo field during edit.

-j-

0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now