Flag in VB

[SpyderMan1234]

I'm fairly new to VBA, but I've managed to create a DB that sends out emails to addresses obtained through a form. After an email is sent to a certain individual I need to flag the record so that you cannot send anymore emails. I understand the logic on how to do this, but I cannot figure out how to reference the field "EmailFlag" in Table1 in my code in order to increment the flag from a 0 to a 1. Is it necessary to connect to the database?

Thanks in advance

 

[willir]

SpyderMan1234

You can add a field to your table to track this, but rather than using a True/False Yes/No boolean data type, consider using a Date data type. Have the system insert the current date when the eMail was sent.

You can find out what addressee's have not been emailed by looking for a Null date, or you can depict the specific date an email was sent.

Assumptions:
- You are using code to send the eMail, so you have an idead about coding
- You are on the form with the record for the eMail being sent
- The name of field is SentDate

To do this, after the eMail has been sent, add the code...
[tt]
Me.SendDate = Now()[/tt]

Now() inserts the current date + time.

Richard

 

[chrisbirley]

You could alternatively have a field called emailflag as a yes/no.

and on the on click function of the send email, have it set the yes/no box = -1.

i.e.

forms![formsname]![yes/nobox] = -1

i hope this helps

Chris