Peter Peterson
Member
- Local time
- Tomorrow, 09:35
- Joined
- Sep 14, 2020
- Messages
- 38
Hi,
I am a novice, but keen to learn more about MS Access including VBA.
I am using Office 365 Pro Plus on Windows 10 (latest update).
I am developing a small client database for myself - it has become too unwieldly using Contacts in Outlook.
I have a list (7 items) of where my clients are in the process within the Clients database.
On the Clients Form I have added seven Labels in a row, each labelled as per the Process list in the database.
I want to change the back color of the Label indicating where along the process the client is at, e.g. Lead, Setup Meeting, ... Complete
Currently I have written a Subroutine to set all seven labels to default, and then using a case statement set the relevant label back color which works.
However, my true novice skills now show themselves as I don't understand well enough where to run this subroutine from.
I am currently running it - Detail->On Paint which works, however, the routine runs every time I move the mouse over the Tabs, etc
Can someone please guide me what Event is best to run the routine?
Happy to sent to research myself as opposed to simply being given the answer - I will learn more if I know where and how to find my own answers.
Thanking you in anticipation of your support.
Regards
Peter
I am a novice, but keen to learn more about MS Access including VBA.
I am using Office 365 Pro Plus on Windows 10 (latest update).
I am developing a small client database for myself - it has become too unwieldly using Contacts in Outlook.
I have a list (7 items) of where my clients are in the process within the Clients database.
On the Clients Form I have added seven Labels in a row, each labelled as per the Process list in the database.
I want to change the back color of the Label indicating where along the process the client is at, e.g. Lead, Setup Meeting, ... Complete
Currently I have written a Subroutine to set all seven labels to default, and then using a case statement set the relevant label back color which works.
However, my true novice skills now show themselves as I don't understand well enough where to run this subroutine from.
I am currently running it - Detail->On Paint which works, however, the routine runs every time I move the mouse over the Tabs, etc
Can someone please guide me what Event is best to run the routine?
Happy to sent to research myself as opposed to simply being given the answer - I will learn more if I know where and how to find my own answers.
Thanking you in anticipation of your support.
Regards
Peter