Solved Changing Color Theme via VBA in Runtime

[strive4peace]

Peter, Nothing attached ...

Now there is an attachment -- thanks for noticing there wasn't Colin @isladogs ... @petertheme edited his post to have the attachment

 

[Pac-Man]

Thanks a lot @petertheme for the db and help, @strive4peace, @isladogs, @Gasman for input.

The way I implemented in my db is user select the theme from a combo (with rowsource from a table which contain path to the corresponding theme file as all theme files are stored locally in certain folder) and attachment is updated in the Resources table so there is even no need of updating the property. Default theme can be reselect from the combo if user wants it.

 

[Pac-Man]

There is one thin more, theme is updated after restarting the db. Is it possible to see the changed theme without having to restart the db?

 

[Garcimat]

Suggest you look at this: ThemeMyDatabase

it is not working

 

[isladogs]

it is not working

Vague comments like that don't help anyone reading this thread
What exactly does that mean? Link not working? You don't know how to use the application? Or what?

 

[Garcimat]

Sorry, I could not access the zip file, I tried again now and it worked fine.
Thank you