How to use colour to distinguish between different versions of a database.
How can I change the colours of the Access application window and/ or the database window (ie, the window that shows all of the tables, queries, etc) and/ or all of the forms of a database in order to provide a constant visual cue to distinguish, say, between the development version, user version, sandbox version of a database? I would like these chanegs to be made automatically via code when the database opens.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is there any way to change the colour of the application window, database window, and /or form window headers (see attached)?
aa.doc
aa.doc
I create my own. This has the added aspect of anyone who gets access to your application, who shouldn't probably will not think about looking in the database properties for values such as this.
This is where I normally put the connection string or name of the backend Access database, it is not hard coded or in a table.
This is where I normally put the connection string or name of the backend Access database, it is not hard coded or in a table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Colors ? Not really a problem ...
download these images and view on an LCD with good color and resolution to get full effect.
mx
Capture1.gif
Capture2.gif
download these images and view on an LCD with good color and resolution to get full effect.
mx
Capture1.gif
Capture2.gif
ASKER
Hi mx,
< http://www.lebans.com/changemdibackground.htm>
Can you point to the code that allows you to change the colours of the application window and database window?
< http://www.lebans.com/changemdibackground.htm>
Can you point to the code that allows you to change the colours of the application window and database window?
"database window?"
Don't know of a way to change the db window, if you are referring to the database container where tables, queries, forms, etc., are listed.
Application Window aka MDI Background ... the Lebans app does that nicely.
mx
Don't know of a way to change the db window, if you are referring to the database container where tables, queries, forms, etc., are listed.
Application Window aka MDI Background ... the Lebans app does that nicely.
mx
ASKER
Hi mx,
<MDI Background>
What does 'MDI' stand for?
<MDI Background>
What does 'MDI' stand for?
MDI = Multiple Document Interface
mx
mx
ASKER
Thanks gents, and sorry for the delay in closing this question.
ASKER
Do you know which database properties would apply?
Do you know what other parts of a form can be colourized besides Section, Detail, and the form's controls?