Page 1 of 3 123 LastLast
Results 1 to 15 of 33
  1. #1
    davegri's Avatar
    davegri is offline Excess Access
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381

    Theme Manager for Forms

    Attached is an Access 2010 app that will allow you to customize the colors of all the forms in your app in a consistent fashion. This can save you literally dozens of hours over trying to modify a bunch of forms manually. The app has 70 preset schemes that you can modify (if you don't like the presets).
    You will need to copy the objects and a code module from the app into your project to try it out. Try it on a copy of your project first to be safe. When you are happy with the results, you can delete the objects and module from your project. After its done its job, it isn't required to stay in your project to retain the colors.


    The app is all VBA, no macros. It will work OK with your forms that contain embedded macros.
    If you have existing code or macros that manipulate colors, undesirable conflicts may or may not occur.
    Version 3 below is latest version. It will allow you to select (or exclude) the forms affected. This will let you easily have more than one theme applied in your DB forms.
    Attached Files Attached Files
    Last edited by davegri; 03-12-2019 at 10:25 PM. Reason: new version

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Nice tool, very useful indeed. But I have couple of questions:
    - I found that it adds bevel effect to buttons. Is there a way to "switch it off"? Edit: nevermind, I found out how
    - also it doesn't change colours of list box and tab controls. Can it be added?

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    Cyanidem, I'll have to wait a while to see what others ask about or want changed before I decide what changes I might make. I'm thinking another form for Preferences might be useful.


    Davegri
    Last edited by davegri; 03-12-2019 at 07:42 AM.

  4. #4
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Thanks Davegri,

    I figured out how to set command buttons as I wanted.
    Another thing I found - it doesn't change properties of labels in form header. Other labels work as intended.

  5. #5
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2010 32bit
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381

    Theme Manager for Forms Update

    Couldn't find a way to edit first post, so added this one. New updated Download, ver 1.1
    Enhancements:
    1. Added radio button to bevel buttons (on/off)
    2. Added code to make button hover color same as Header/Footer color.
    3. Added code to make button font (forecolor) either black or white, depending on button backcolor, to enhance readability.

    If you copied version 1.0 to your accdb and you want to upgrade, first remove from your accdb:
    frmTestTheme, frmSubfrmTheme, frmColorTuner, frmHelp, and basSetTheme.
    If you have made custom color changes, you can keep tblColors, else remove it also.
    Follow the instructions in tblHelp to install the app in your accdb.
    Attached Files Attached Files

  6. #6
    Karaline's Avatar
    Karaline is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2017
    Location
    Just North Of Antartica
    Posts
    38
    that took patience.

  7. #7
    lsalvucci is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    3
    Is there a way to add code to revert the changes back to the original colors schemes the DB had?

  8. #8
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    Is there a way to add code to revert the changes back to the original colors schemes the DB had?
    That would be a monumental effort. Easier to revert to the backup copy of your DB that the instructions suggested that you create.
    Last edited by davegri; 08-13-2017 at 12:14 AM.

  9. #9
    acrowe97 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2018
    Posts
    41
    Is there a way to make the outline of buttons the same color as the button color?

  10. #10
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    It just so happens the latest version v02 allows exactly that. I added a 'borders' column.
    All the objects in the DB now start with cc which will allow you to easily identify them when intermixed with your objects in the navigation pane.
    Last edited by davegri; 09-14-2018 at 04:11 PM.

  11. #11
    acrowe97 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2018
    Posts
    41
    Can it be applied to only certain forms, or does it have to be all of them (amazing program btw)

  12. #12
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    Can it be applied to only certain forms, or does it have to be all of them (amazing program btw)
    Sure. You can create a new database leaving out the forms that need to be unchanged.
    Then reassemble your DB forms from wherever the desired theme resides.

  13. #13
    acrowe97 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2018
    Posts
    41
    Thank you!!

  14. #14
    Cliff67 is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Jan 2019
    Posts
    2
    Thank you for the tool. Brilliant. If a user wants to change the form colours using this can others do different ones?
    I assume you modify the tblColours tabel to include a user column then when the DB opens you find the user then apply them?
    I want to add a default of the corporate colours, that could just be another option can't it

    many thanks

    Cliff

  15. #15
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,381
    include a user column then when the DB opens you find the user then apply them?
    Every PC should have its own copy of the database, or the database FE if it's split.
    So I don't see the need for this unless you have multiple people logging into the same PC.

Page 1 of 3 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Switchboard Manager
    By BigDoubleR in forum Access
    Replies: 2
    Last Post: 10-29-2015, 02:33 AM
  2. Design My Own Theme??
    By alanfallow in forum Access
    Replies: 2
    Last Post: 01-10-2014, 12:24 PM
  3. Replies: 4
    Last Post: 04-22-2013, 06:45 AM
  4. Replies: 3
    Last Post: 10-08-2011, 05:00 AM
  5. Replies: 7
    Last Post: 08-10-2011, 04:48 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums