B
batgirl_520
We publish a monthly trade magazine. I have created a database to help
me manage the monthly advertising. Here is the basic (relevant)
structure:
Table: Company - Has all the different companies and individuals that
advertise with us. Includes such info as the phone number and e-mail
address.
Table: Issue - Just a table of the months, such as 2006 January, 2006
February and so on.
Table: IssueDetail - This is the nuts and bolts. For each issue, it
lists the company, ad size (full page, half page, etc.), color, page
number, and other info not relevant to my problem.
In the IssueDetail table, I also have two Yes/No fields. One is whether
or not I need a new ad and the other is whether I have received a new
ad. (Fields are: NeedAd and NewAd). I don't get a new ad from every
company every month. Some just run the same ad all the time while
others change them every month. So for the ones that change them
constantly, the NeedAd field would be Yes. When I receive the ad, the
NeedAd is changed to No and the NewAd to Yes. This way when I am
getting ready to send the magazine to the printer, I can make sure that
I have inserted all the new ads. I have set up a form to send an e-mail
reminder to everyone I need a new ad from that gives them the deadline
date.
The form is linked to a query (EmailQuery) that only returns companies
where the NeedAd is Yes. The form has a ListBox and the RowSource
narrows it down to only include the companies for that particular
issue. I can click a button to SelectAll in the listbox or I can select
individual companies. When I have the companies selected, I click a
button (CreateRecipientString) that opens a new e-mail with all the
companies that are selected as the recipients. This all works great and
is really helping.
Now for my problem. I want to add a text field to my IssueDetail table
called SentEmail. When I click on the button CreateRecipientString, I
want it to loop through all the selected records and update the new
SentEmail field with the current date. (I don't want the field to be
a date field, as I will also send a second e-mail in the same month
right before the deadline date for those companies that have not yet
sent a new ad.) I can't for the life of me figure out how to do this.
I hope someone here can help. I hope I provided enough information.
TIA,
Nancy
me manage the monthly advertising. Here is the basic (relevant)
structure:
Table: Company - Has all the different companies and individuals that
advertise with us. Includes such info as the phone number and e-mail
address.
Table: Issue - Just a table of the months, such as 2006 January, 2006
February and so on.
Table: IssueDetail - This is the nuts and bolts. For each issue, it
lists the company, ad size (full page, half page, etc.), color, page
number, and other info not relevant to my problem.
In the IssueDetail table, I also have two Yes/No fields. One is whether
or not I need a new ad and the other is whether I have received a new
ad. (Fields are: NeedAd and NewAd). I don't get a new ad from every
company every month. Some just run the same ad all the time while
others change them every month. So for the ones that change them
constantly, the NeedAd field would be Yes. When I receive the ad, the
NeedAd is changed to No and the NewAd to Yes. This way when I am
getting ready to send the magazine to the printer, I can make sure that
I have inserted all the new ads. I have set up a form to send an e-mail
reminder to everyone I need a new ad from that gives them the deadline
date.
The form is linked to a query (EmailQuery) that only returns companies
where the NeedAd is Yes. The form has a ListBox and the RowSource
narrows it down to only include the companies for that particular
issue. I can click a button to SelectAll in the listbox or I can select
individual companies. When I have the companies selected, I click a
button (CreateRecipientString) that opens a new e-mail with all the
companies that are selected as the recipients. This all works great and
is really helping.
Now for my problem. I want to add a text field to my IssueDetail table
called SentEmail. When I click on the button CreateRecipientString, I
want it to loop through all the selected records and update the new
SentEmail field with the current date. (I don't want the field to be
a date field, as I will also send a second e-mail in the same month
right before the deadline date for those companies that have not yet
sent a new ad.) I can't for the life of me figure out how to do this.
I hope someone here can help. I hope I provided enough information.
TIA,
Nancy