Save or Load Forms (1 Viewer)

Status
Not open for further replies.

Jeffr.Lipton

Registered User.
Local time
Today, 07:05
Joined
Sep 14, 2018
Messages
31
"Use Themes" was introduced in 2010, but it doesn't transfer when you copy and paste a form. Since I sometimes make substantial changes to my test database and would like to just transfer the whole form to Production, I wrote the attached procedures.
 

Attachments

  • Save and Load Forms.txt
    3.4 KB · Views: 242
Last edited by a moderator:

isladogs

MVP / VIP
Local time
Today, 14:05
Joined
Jan 14, 2017
Messages
18,186
Hi Jeff

I approved your post earlier but I'm having difficulty in replicating the issue you described in either Access 2016 (365) or 2010

I tried several things including:
a) copying a form
b) copying controls from one form to another
c) dragging a form from one open Access app to another
d) importing a form from another Access app

Each Access app can only have one theme. If you don't set a theme it uses the default Office Theme.
In a) & b) the theme is applied to the new form as that is built into the app

In c) & d), the imported form will take on the theme of the destination app so if that has a different theme, the form will indeed change appearance if it was based on theme colours from the top half of the colour picker e.g. Accent1, Text1 etc.



However if you you customise the form colours/appearance in the original app so its using standard colours rather than theme colours, its appearance will be retained when it is imported to a new app

Please could you clarify the situation that has caused you problems requiring a solution such as this
 

Attachments

  • FormColours.PNG
    FormColours.PNG
    17.1 KB · Views: 443
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom