System language to influence VBA?

[kysterathome]

Hi all,

I am working on a rather large project in Access, both at work as well as at home. However, when I take the DB home on weekends, I painfully discover on Mondays that a number of codes don't work anymore (e.g. date, format, Mid).

And I am wondering, is that because I have a German MS system at home and an English Microsoft NT system at work? Sounds logic to be the problem. But how can I avoid getting into trouble... half of my Mondays I am using to import the new stuff I produced on the weekends into older versions I worked on on Fridays...

Please help!

Kysterathome

 

[HitechUser]

kysterathome

You may find this helpful.

Microsoft

...click Microsoft Access Help on the Help menu, type international settings in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

I hope this get us closer..

 

[PHV]

When code don't work anymore double check the references:
in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[VBslammer]

STOP working at home ...life is too short...

VBSlammer

Unemployed in Houston, Texas

 

[kysterathome]

Well, PHV, I thought about that, esp. because at work it says can't read project or Library, or smth like that ... but then I ticked pretty much all of the references, but nothing really changed... also, there are hundreds of references... wouldn't that slow down the loading time, if Access has to load all of them? Just wondering.

VBslammer You have a point. But hoping this will bring me some bonus points - right now our department is working with 5 differnet Excel spreadsheets with over 5000 entries each. I believe having one userfriendly interface will make people more comfortable with their work. *wife currently not too happy though*

Kysterathome

 

[jsteph]

kyster,
Don't check them all, just look for a 'Missing...' one that's checked. It's probably DAO or ADO, so go with a version that you have in common to both machines, ie the lowest common denominator. Or get the latest MDAC and upgrade both machines to that.
--J

 

[VBslammer]

kyster,

I've been there, done that too. I used to work in an office where all the tech decisions were being made by a man everyone called "The Spreadsheet King!!!" He could write formulas that were virually unreadable, and had the entire logistics operation standing on the stability of a 35MB spreadsheet that took over a minute to load - I couldn't stand it. I began development on an Access prototype (in my spare time ) to replace the spreadsheet system, but all the executives were uncomfortable with the idea, because they weren't willing to venture outside their familiarity with "the spreadsheet."

When the power users in charge start building tables in their spreadsheets, it's time to move up to a DBMS. The hard part is convincing them to let go of their "babies."

Oh, and FYI - my wife gets just as mad

VBSlammer

Unemployed in Houston, Texas

 

[kysterathome]

VBslammer, that's my biggest fear that there will be a big resistance ... however, I figure, the more userfriendly and the better the reports, the faster the adaptation process.

Fingers crossed