VB Code that can change the color of my sub query

Asked By hugh jackson 450 points N/A Posted on - 10/21/2011

I am using SQL sub query and I have a list of email addresses on it. These are the list of the customer’s software that will expire in 45 days or less. With just a single click, an email will be sent to the customers address. What I want to do now, is to make a formatting that will change the font color of my list when an email is sent.  In this way, anyone who uses this database can easily view if the email has been sent to a specific customer at a later date. Is there a simple Visual Basic code that I can put into the email script and will turn those sent addresses to green color on my sub query?    

• Status: Open
• Question Views: 773
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By james.hanks 0 points N/A #107686

VB Code that can change the color of my sub query

Where are you going to write the list of the email addresses in your VB interface? I would like to suggest that you use listbox or a combo box. Just use the SQL query and list it in the listbox or combo box. After that, use a control statement, I suggest the if statement to check if the email addresses in the list are already been used for sending mail or messages. If they are you can use the ForeColor property of the listbox. In the ForeColor property, you can choose from different colors available. Hope this helped solve your problem.

About james.hanks

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: Database