X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Theme Colors - Vba Methods - Updated Database, Access 2016    
Craig Carroll
post May 25 2020, 08:19 PM

Posts: 7
Joined: 30-March 20

On May 6th, I created a thread named 'Theme Colors - VBA methods to "get"/"put" colors', which had an attached database. That attachment has been deleted, and it is replaced by this new version. It's much improved: now handles color properties for Form 'Datasheet'; handles any Custom Control properly; much more fault-tolerant; etc. Everything works for Forms & Reports (although the database doesn't contain any Report). Many thanks to UA member Guillem for lots of bug-reports, useful suggestions & fun conversations!

The "guts" of the database is a Public Function named 'GetThemeColorName' and a Public Sub named 'PutThemeColorName':
'GetThemeColorName' returns the Theme Color Name for any Property within any Section or Control or 'Datasheet' (or an empty string if it isn't a valid Theme Color; caller routines can handle errors). 'PutThemeColorName' uses a Theme Color Name to set all 3 Properties of a Theme Color into any Section or Control or 'Datasheet'
There is a read-only Sub which examines & displays all Properties of any Form or Report.
There is a "demo" Form where the 'Fore' & 'Back' & 'Border' colors for a Text Box can be manipulated to see 'PutThemeColorName' in action.
Finally, there is a Form which acts as a "shell" for Design View, from which any Theme Color can be saved into any Sections and/or Controls and/or 'Datasheet' (with several Undo options).
Attached File  ThemeColors.zip ( 194.63K )Number of downloads: 19
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    13th July 2020 - 05:34 AM