Adding a generic note to ALL records

[Guest]

Hi

My DB of donors has a subform which stores client notes. Fields are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients with
particular criteria with something like "Fax request sent to client on
28/2/06".

I tried doing an updatequery though it overtyped all my existing notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Duane Hookom]

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a new
comments record for each donor?

 

[Guest]

Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and will take
your advice - you're right - I think I want an append query as I want NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to insert the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query would KEEP
the original comments and ADD the new comments on to the END of the existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on 28/2/06"

TIA - Sue

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

Hi

My DB of donors has a subform which stores client notes. Fields are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients with
particular criteria with something like "Fax request sent to client on
28/2/06".

I tried doing an updatequery though it overtyped all my existing notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Duane Hookom]

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and will
take
your advice - you're right - I think I want an append query as I want NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query would
KEEP
the original comments and ADD the new comments on to the END of the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on 28/2/06"

TIA - Sue

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message

Hi

My DB of donors has a subform which stores client notes. Fields are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients with
particular criteria with something like "Fax request sent to client on
28/2/06".

I tried doing an updatequery though it overtyped all my existing notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Guest]

Hi Duane

OK - for this example let's say that I only want to append a new notes
record to though Donors that have a fax number (field is called FaxNumber]

Cheers

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and will
take
your advice - you're right - I think I want an append query as I want NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query would
KEEP
the original comments and ADD the new comments on to the END of the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on 28/2/06"

TIA - Sue

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message
Hi

My DB of donors has a subform which stores client notes. Fields are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients with
particular criteria with something like "Fax request sent to client on
28/2/06".

I tried doing an updatequery though it overtyped all my existing notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Duane Hookom]

Do you have a table and field names that you would like to share? I expect
you have a tblDonors with fields like DonorID and FaxNumber.

--
Duane Hookom
MS Access MVP
--

Hi Duane

OK - for this example let's say that I only want to append a new notes
record to though Donors that have a fax number (field is called FaxNumber]

Cheers

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message

Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and will
take
your advice - you're right - I think I want an append query as I want
NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query would
KEEP
the original comments and ADD the new comments on to the END of the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on 28/2/06"

TIA - Sue

:

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi

My DB of donors has a subform which stores client notes. Fields
are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients
with
particular criteria with something like "Fax request sent to client
on
28/2/06".

I tried doing an updatequery though it overtyped all my existing
notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Guest]

Sorry Duane

The Notes Table is called [Notes]
The Notes Field is called [Comments]

The Donors Table is called [Contacts]
The Fax Field is called [FaxNumber]

I also tried your update query and a really wierd thing happened. I have
1553 donor records - all with notes. I ran the update query to add in a
dummy additional note - ie [Comments] & 'Yadayada'. When the query ran - it
said - 'about to update 1553 records' - and I ran it.

When I went through the records - only about half of them carried the new
additional part of the message - though when I went CTL F -'Yadayada' it
would go to ALL records - though you couldn't see it in the comments field on
50%. Any clues?

Cheers

Sue

Do you have a table and field names that you would like to share? I expect
you have a tblDonors with fields like DonorID and FaxNumber.

--
Duane Hookom
MS Access MVP
--

Hi Duane

OK - for this example let's say that I only want to append a new notes
record to though Donors that have a fax number (field is called FaxNumber]

Cheers

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message
Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and will
take
your advice - you're right - I think I want an append query as I want
NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query would
KEEP
the original comments and ADD the new comments on to the END of the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on 28/2/06"

TIA - Sue

:

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi

My DB of donors has a subform which stores client notes. Fields
are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients
with
particular criteria with something like "Fax request sent to client
on
28/2/06".

I tried doing an updatequery though it overtyped all my existing
notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Duane Hookom]

I'm not sure why you didn't see the comments on some records. Is the field
wide enough and tall enough to see the entire contents?

Are you still looking for a method to append rather than update? If so,
there should be more fields that are significant to your append.

--
Duane Hookom
MS Access MVP
--

Sorry Duane

The Notes Table is called [Notes]
The Notes Field is called [Comments]

The Donors Table is called [Contacts]
The Fax Field is called [FaxNumber]

I also tried your update query and a really wierd thing happened. I have
1553 donor records - all with notes. I ran the update query to add in a
dummy additional note - ie [Comments] & 'Yadayada'. When the query ran -
it
said - 'about to update 1553 records' - and I ran it.

When I went through the records - only about half of them carried the new
additional part of the message - though when I went CTL F -'Yadayada' it
would go to ALL records - though you couldn't see it in the comments field
on
50%. Any clues?

Cheers

Sue

Do you have a table and field names that you would like to share? I
expect
you have a tblDonors with fields like DonorID and FaxNumber.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message

Hi Duane

OK - for this example let's say that I only want to append a new notes
record to though Donors that have a fax number (field is called
FaxNumber]

Cheers


:

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and
will
take
your advice - you're right - I think I want an append query as I
want
NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to
insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query
would
KEEP
the original comments and ADD the new comments on to the END of the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on 28/2/06"

TIA - Sue

:

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a
new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi

My DB of donors has a subform which stores client notes. Fields
are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients
with
particular criteria with something like "Fax request sent to
client
on
28/2/06".

I tried doing an updatequery though it overtyped all my existing
notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Guest]

Hi Duane

I'm still looking for append assistance as I think that's the best way to go
- as per your advice. The Notes table is presented as a subform [Notes
subform] on the Contacts Form [derived from the Contacts Table]. The only
fields in the Notes table are:

ID: [which links with the parent ID field in Contacts]
UserInitials:
Date:
Comments: [this is a memo field]

Cheers - Sue

I'm not sure why you didn't see the comments on some records. Is the field
wide enough and tall enough to see the entire contents?

Are you still looking for a method to append rather than update? If so,
there should be more fields that are significant to your append.

--
Duane Hookom
MS Access MVP
--

Sorry Duane

The Notes Table is called [Notes]
The Notes Field is called [Comments]

The Donors Table is called [Contacts]
The Fax Field is called [FaxNumber]

I also tried your update query and a really wierd thing happened. I have
1553 donor records - all with notes. I ran the update query to add in a
dummy additional note - ie [Comments] & 'Yadayada'. When the query ran -
it
said - 'about to update 1553 records' - and I ran it.

When I went through the records - only about half of them carried the new
additional part of the message - though when I went CTL F -'Yadayada' it
would go to ALL records - though you couldn't see it in the comments field
on
50%. Any clues?

Cheers

Sue

Do you have a table and field names that you would like to share? I
expect
you have a tblDonors with fields like DonorID and FaxNumber.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message
Hi Duane

OK - for this example let's say that I only want to append a new notes
record to though Donors that have a fax number (field is called
FaxNumber]

Cheers


:

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and
will
take
your advice - you're right - I think I want an append query as I
want
NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to
insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query
would
KEEP
the original comments and ADD the new comments on to the END of the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on 28/2/06"

TIA - Sue

:

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on 28/2/06"

Are you sure you didn't want an append query that would append a
new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi

My DB of donors has a subform which stores client notes. Fields
are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all clients
with
particular criteria with something like "Fax request sent to
client
on
28/2/06".

I tried doing an updatequery though it overtyped all my existing
notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Duane Hookom]

You can create a query based on your Contacts table. Add the ParentID field
to the grid. Create more columns in the grid like
Comments: "These are your comments to append"
DateField: Date()
--others--
Set a criteria on this query so that it only returns the ParentIDs that you
want appended. Change the query to an append query and choose to append to
your Notes table. Select the appropriate append to fields from Notes so that
the values get pushed into the proper fields.

Run the append query.

If you have a problem, you MUST come back with the SQL view of your append
query.

--
Duane Hookom
MS Access MVP
--

Hi Duane

I'm still looking for append assistance as I think that's the best way to
go
- as per your advice. The Notes table is presented as a subform [Notes
subform] on the Contacts Form [derived from the Contacts Table]. The only
fields in the Notes table are:

ID: [which links with the parent ID field in Contacts]
UserInitials:
Date:
Comments: [this is a memo field]

Cheers - Sue

I'm not sure why you didn't see the comments on some records. Is the
field
wide enough and tall enough to see the entire contents?

Are you still looking for a method to append rather than update? If so,
there should be more fields that are significant to your append.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message

Sorry Duane

The Notes Table is called [Notes]
The Notes Field is called [Comments]

The Donors Table is called [Contacts]
The Fax Field is called [FaxNumber]

I also tried your update query and a really wierd thing happened. I
have
1553 donor records - all with notes. I ran the update query to add in
a
dummy additional note - ie [Comments] & 'Yadayada'. When the query
ran -
it
said - 'about to update 1553 records' - and I ran it.

When I went through the records - only about half of them carried the
new
additional part of the message - though when I went CTL F -'Yadayada'
it
would go to ALL records - though you couldn't see it in the comments
field
on
50%. Any clues?

Cheers

Sue




:

Do you have a table and field names that you would like to share? I
expect
you have a tblDonors with fields like DonorID and FaxNumber.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi Duane

OK - for this example let's say that I only want to append a new
notes
record to though Donors that have a fax number (field is called
FaxNumber]

Cheers


:

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want
to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and
will
take
your advice - you're right - I think I want an append query as I
want
NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to
insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query
would
KEEP
the original comments and ADD the new comments on to the END of
the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on
28/2/06"

TIA - Sue

:

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on
28/2/06"

Are you sure you didn't want an append query that would append a
new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi

My DB of donors has a subform which stores client notes.
Fields
are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all
clients
with
particular criteria with something like "Fax request sent to
client
on
28/2/06".

I tried doing an updatequery though it overtyped all my
existing
notes
records [thank heaven for backing up].

TIA

Sue


,

 

[Guest]

Brilliant - worked a treat - thanks for your help Duane - really appreciate it.

Also - the answer to not being able to see the comments via the update
query. It was as you had said - my comments filed was only one line tall and
these entries had ALT + Enter line spaces in them so the info was 'hidden'

You can create a query based on your Contacts table. Add the ParentID field
to the grid. Create more columns in the grid like
Comments: "These are your comments to append"
DateField: Date()
--others--
Set a criteria on this query so that it only returns the ParentIDs that you
want appended. Change the query to an append query and choose to append to
your Notes table. Select the appropriate append to fields from Notes so that
the values get pushed into the proper fields.

Run the append query.

If you have a problem, you MUST come back with the SQL view of your append
query.

--
Duane Hookom
MS Access MVP
--

Hi Duane

I'm still looking for append assistance as I think that's the best way to
go
- as per your advice. The Notes table is presented as a subform [Notes
subform] on the Contacts Form [derived from the Contacts Table]. The only
fields in the Notes table are:

ID: [which links with the parent ID field in Contacts]
UserInitials:
Date:
Comments: [this is a memo field]

Cheers - Sue

I'm not sure why you didn't see the comments on some records. Is the
field
wide enough and tall enough to see the entire contents?

Are you still looking for a method to append rather than update? If so,
there should be more fields that are significant to your append.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting" <[email protected]>
wrote in message
Sorry Duane

The Notes Table is called [Notes]
The Notes Field is called [Comments]

The Donors Table is called [Contacts]
The Fax Field is called [FaxNumber]

I also tried your update query and a really wierd thing happened. I
have
1553 donor records - all with notes. I ran the update query to add in
a
dummy additional note - ie [Comments] & 'Yadayada'. When the query
ran -
it
said - 'about to update 1553 records' - and I ran it.

When I went through the records - only about half of them carried the
new
additional part of the message - though when I went CTL F -'Yadayada'
it
would go to ALL records - though you couldn't see it in the comments
field
on
50%. Any clues?

Cheers

Sue




:

Do you have a table and field names that you would like to share? I
expect
you have a tblDonors with fields like DonorID and FaxNumber.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi Duane

OK - for this example let's say that I only want to append a new
notes
record to though Donors that have a fax number (field is called
FaxNumber]

Cheers


:

If it's an update
Field: Comments
Table: Notes
Update to: [Comments] & " - Fax sent to client on 28/2/2006 - Sue"

If its append, you would need to provide information on if you want
to
append for every DonorID or what.

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi Duane

Thanks for the quick response. I'm a bit of a novice on this and
will
take
your advice - you're right - I think I want an append query as I
want
NEW
notes records for each client - 2 questions though:

I tried doing an append query and couldn't work out which row to
insert
the
generic message for all new records. My query goes like this

Field: Comments
Table: Notes
Sort:
Append To: Comments
Criteria: [blank at this point]


Second Question - are you saying that your original update query
would
KEEP
the original comments and ADD the new comments on to the END of
the
existing
comments? If so - once again - my update query looks like

Field: Comments
Table: Notes
Update to: "Fax sent to client on 28/2/2006 - Sue"

Where do I put the line you wrote? ie

Set Comments = Comments & " Fax request sent to client on
28/2/06"

TIA - Sue

:

Your update query would be like:
Set Comments = Comments & " Fax request sent to client on
28/2/06"

Are you sure you didn't want an append query that would append a
new
comments record for each donor?

--
Duane Hookom
MS Access MVP
--

"Compelling Consulting"
<[email protected]>
wrote in message
Hi

My DB of donors has a subform which stores client notes.
Fields
are:
DonorID, UserInitials, Date, Comments.

I want to automatically create a new notes record for all
clients
with
particular criteria with something like "Fax request sent to
client
on
28/2/06".

I tried doing an updatequery though it overtyped all my
existing
notes
records [thank heaven for backing up].

TIA

Sue


,