Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 19th, 2006, 07:41 AM
Authorized User
 
Join Date: May 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access change looks

I completed my forms and I want to give the database appearance
more like the XP or 2003 look. Right now it still has the buttons
like in access 2000, (I'm using 2003) database was started in ver. 2000),. It there a way to upgrade this appearance.
Thanks
;)

John Paul
__________________
John Paul
 
Old May 19th, 2006, 11:15 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

The buttons should follow the appearance of the computer they are installed on. If it is on a Windows XP box, it should have Windows XP buttons. Those are determined bythe performance / appearance settings of the particular desktop. That is my understanding anyway.

You really can't change the appearance of the buttons unless you get an aftermarket button system.

Okay, if you want to really get into a lot of code, you can swipe buttons off of web sites and FrontPage, and then code the individual images. I have done this but it is very tedious.

The upshot is that the buttons are determined by the OS, not the Office suite. As I say, that is my understanding.

HTH


mmcdonal
 
Old May 19th, 2006, 11:26 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

I used to think the same thing, but I have 2 databases on my PC that have different buttons. If I move forms between them, the buttons seem to take on the button style of the target database. So it could be a references thing, or dependant on the original type of the database.

You could try creating a new database in 2003, and then importing all your tables, forms etc. into it.

Mike

Mike
EchoVue.com
 
Old May 19th, 2006, 11:52 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Yeah, I like the second idea. I was not sure about what determines the button appearance. Thanks for the clarification.


mmcdonal
 
Old May 22nd, 2006, 09:14 AM
dpw dpw is offline
Registered User
 
Join Date: May 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In a database created using Office Access 2003, most form controls automatically inherit the Windows theme, if you are using Microsoft Windows XP SP 1, and the chosen theme is not Windows Classic. Controls that do not inherit the Windows theme are labels, images, object frames, subforms, lines, and rectangles.

On the Tools menu, click Options.
On the Forms/Reports tab, select or clear the Use Windows Themed Controls on Forms check box.

Note To change the Windows theme, open the Display window in Control Panel. On the Themes tab, select a theme other than Windows Classic in the Themes list box.

 
Old May 22nd, 2006, 09:19 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Thanks for that dpw. You learn something new everyday.

mmcdonal
 
Old June 1st, 2006, 12:05 PM
Authorized User
 
Join Date: May 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Very good! That gave me more control on the Looks.
thanks:D

John Paul





Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the Appearance of a list box (Access VBA) hewstone999 Access VBA 1 February 29th, 2008 09:12 AM
Access/change html-tags contained in elementvalues polarbear XSLT 3 December 26th, 2007 07:23 AM
change access error messages Vince_421 Access VBA 1 February 16th, 2007 08:42 AM
Need to change MS Access 2000 Query gilgalbiblewheel Classic ASP Databases 0 June 13th, 2005 11:10 PM
SQL to change a column name in MS Access nidgep Classic ASP Databases 1 August 13th, 2003 10:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.