If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access build application behaves differently on coworker's computer.
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 |
#2
|
|||
|
|||
Access build application behaves differently on coworker's computer.
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/AlbertKal...heme/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...... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
#3
|
|||
|
|||
Access build application behaves differently on coworker's computer.
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. |
#4
|
|||
|
|||
Access build application behaves differently on coworker's computer.
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.... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
Thread Tools | |
Display Modes | |
|
|