updating a memo field

[stumpydwarf99]

I want to put a button on a form that pops up a window to allow text entry.

the code will then append the text entered into a memo field in the database along with the current date and time.

I'd like to code to append it at the start of the memo field.

I have absolutely no idea how to do this and was wondering if anyone can help?

 

[boblarson]

Yes, you can do this. Is it good to do, not really because it becomes very difficult to get the data back out should you need it. You should really have another table for notes and add RECORDS for each note as it is done instead of appending to the note.

However, if you must have it this way, you can create a form with a text box to add the note and then in its close event put:

Forms!YourMainFormNameHere.YourMemoTextboxHere = Now & "---------------" & vbCrLf & Me.YourTextBoxNameHere & vbCrLf & vbCrLf & Forms!YourMainFormNameHere.YourMemoTextBoxHere

 

[mrrayj60]

Hey Bob,
I have an append qry that works fine and I'm trying to add somemore data and I'm having trouble with a date field going to a text field. This is the qry and now with the new line of visitorlog date to complaint it wants to add 688 records, all the same. I am using 3 tables, residents & visitorlog going into vrc.

INSERT INTO vrc ( UBL, NAME, PHONE, ADDR1, CITY, STATE, ZIP, SNAME, ADDR2, CITY2, STATE2, ZIP2, COUNTRY2, RENTALUNIT, OTHERUBL, STATUS, STATUS_DATE, UNIT, COMPLAINT_DATE, COMPLAINT )
SELECT DISTINCTROW residents.num, residents.name, residents.phone, residents.addr201, residents.city01, residents.state01, residents.zip01, residents.sname, residents.addr202, residents.city02, residents.state02, residents.zip02, residents.cntry02, residents.uleased, residents.special, "OPEN" AS Expr1, Date() AS Expr2, residents.UBL AS Expr3, Date() AS Expr4, DateValue([visitorlog]![Date]) AS Expr5
FROM vrc, visitorlog, residents
WHERE ((([Forms]![frmVisit]![txtubl])=[residents]![num]));

Thanks, Ray