×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access Themes using VBA

Access Themes using VBA

Access Themes using VBA

(OP)
Anyone have any idea how to set access themes using VBA?  Just switching to another default theme would be a start.  I've found where they are located (ie. currentproject.resources) but can't seem to find how to switch a theme with code.

RE: Access Themes using VBA

Have no idea as to the needed code, but modifying this kind of thing through code always requires either opening a Form in Design View in order to do it, or in cases of application wide changes, closing and then re-opening Access itself.

Having to go through this kind of song and dance usually makes the ends not worth the effort involved.  

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

RE: Access Themes using VBA

(OP)
just to not be ambiguous, I mean the theme in the access ribbon.  I want to have the user be able to set their own theme in runtime mode, but it appears that the ribbon is disabled in the runtime so was hoping that i could code the operation myself.  Any ideas?

RE: Access Themes using VBA

All design changes are unavailable in Run Time. Sorry! And you always need to state that you're talking about doing something in Run Time, if that's the case, because it makes a big difference!

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close