Access build application behaves differently on coworker's computer.

[nabirman]

This may seem like an easy issue but I'm a bit stumped.

I wrote a decent sized application in Access using a few forms and a
whole bunch of VBA. My computer along with the computers used by my
coworkers have Access 2003 (11.6566.8028) SP2. When I open the
application all the forms and buttons are bubbly and the colors aren't
flat. But when my coworkers open up the application on their machine
everything has been flattened out and looks pretty bad.

The other issue comes when importing an excel table. There is a table
with about 5 columns and one of the columns is imported incorrectly on
my coworker's computers. The offending column has been formatted as
both general and text to see if that would help but it hasn't. What
happens is that the column is usually a group identifier made up of
numbers. Every now and then a group pops up with an A at the begining.
When my code imports the table it attaches "FI-" to the begining of
each one of these number codes and then appends it to a master table.
My computer has no problem handling the numbers with an A at the
beginning. But when my work workers import the table they get a "FI-
" instead of "FI-A999". Why would this behave differently on
different computers. I've check the add-ins and all that but haven't
found any differences there which makes me think it's either an Excel
issue or a Windows issue.

Any help on these issues would be a huge help.

Thanks

 

[Albert D. Kallal]

Perhaps you have themed controls...and the target machine does not?

the windows xp box must be at least sp1 or later (can't imagine a machine
still at pre sp1 these days).

If the box is win2000..then you going to get non themed controls....

If you are wondering what the difference looks like...here is some screen
shots of the SAME screen..the only difference is that themed controls are
turned off on the left side....

http://www.members.shaw.ca/AlbertKallal/Atheme/index.htm

Check the users ms-access settings..as the themes may be turned off....

tools->options->forms/reports

[x] use Windows themed controls on forms.

You can also set this value in your start-up code....

Application.SetOption "ShowWindowsInTaskbar", False
Application.SetOption "Themed Form Controls", True <------
Application.SetOption "Show Startup Dialog Box", False
Application.CommandBars.AdaptiveMenus = False

Note several of the start-up options I set via code......

 

[nabirman]

Check the users ms-access settings..as the themes may be turned off....

tools->options->forms/reports

[x] use Windows themed controls on forms.

Thank you.

I took a look at the application on both of the other machines and that
option is enabled already.

 

[Albert D. Kallal]

I took a look at the application on both of the other machines and that
option is enabled already.

Ok...does the screen difference look like the samples I showed?

If yes..then the problem is that sp1 (or later) is not installed for
windows...or you are running win2000...in both of these cases...themes will
not work with a2003....