How to add a daily note to a form

[Mark M Simonian]

I am using Access 2002.
I am using a form date and text field to create a note on the Note Form #2
then using setvalue to paste it to the Progress Note #1 memo field of
another form. It works well but I need to open the Note form each day and
create a new note and add it to the Progress note. Right now it just pastes
over the first note and I want to add it into the same memo field.

I did this a long time ago and it seems that I did a carriage return (Chr$)
in the first note and
it forced a return and printed on the following line. I can't figure out the
syntax now so I can keep adding notes to the first form. Any suggestions are
appreciated.

-----------------------------------------------------
Mark M Simonian MD
Medical Director, ChildNet Medical Assoc.
681 Medical Center Drive West #106
Clovis, CA 93611
(559) 325-6850
(e-mail address removed)
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.

 

[fredg]

I am using Access 2002.
I am using a form date and text field to create a note on the Note Form #2
then using setvalue to paste it to the Progress Note #1 memo field of
another form. It works well but I need to open the Note form each day and
create a new note and add it to the Progress note. Right now it just pastes
over the first note and I want to add it into the same memo field.

I did this a long time ago and it seems that I did a carriage return (Chr$)
in the first note and
it forced a return and printed on the following line. I can't figure out the
syntax now so I can keep adding notes to the first form. Any suggestions are
appreciated.

** snipped **
To add the note to the memo field, and space it one line down,
your basic method would be like this:

[NoteFieldonForm1] = [NoteFieldonform1] & chr(13) & chr(10) &
[NoteOnForm2]

 

[Mark M S]

Thank you very much. This group is always so helpful.
*************************************************
Mark M Simonian MD FAAP
Medical Director, ChildNet Medical Assoc.
681 Medical Center Drive West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.

I am using Access 2002.
I am using a form date and text field to create a note on the Note Form #2
then using setvalue to paste it to the Progress Note #1 memo field of
another form. It works well but I need to open the Note form each day and
create a new note and add it to the Progress note. Right now it just pastes
over the first note and I want to add it into the same memo field.

I did this a long time ago and it seems that I did a carriage return (Chr$)
in the first note and
it forced a return and printed on the following line. I can't figure out the
syntax now so I can keep adding notes to the first form. Any suggestions are
appreciated.

** snipped **
To add the note to the memo field, and space it one line down,
your basic method would be like this:

[NoteFieldonForm1] = [NoteFieldonform1] & chr(13) & chr(10) &
[NoteOnForm2]