I'm deploying an Access app in a Citrix environment - which I
have no permission to even look at, much less change.

On the last elevation everything went fine except for one user,
whose session could not resolve "Format$".

Screen snap at: http://tinyurl.com/3t3yzgg

Looks like a broken reference to me - albeit it is puzzling that
it was only for this one user and not 3 others.

Putting that aside for the moment....

I started looking through references and noted that my Dev box
has a ref to "Microsoft Office 11.0 Object Library" and my
documentation noted that a ref to "Microsoft Office 12.0 Object
Library" was required.

When I tried to change 11 to 12, I could not find it in the Tools
Just for good measure, I opened up a blank 12 spreadsheet and a
blank 12 Word doc.

Ok... so I reverted to 11.

But now the app is throwing errors when it tries to invoke an
Excel function: "1004: Cannot run the macro 'AccrIntM'. The macro
may not be available in this workbook or all macros may be
disabled."

Does this sound familiar to anybody? The user's Citrix
environment aside, it seems to me like there's something going on
here with Office 11 and 12....

I'll be able to get to the job site on Tuesday to look over the
user's shoulder and maybe pop a Tools | References list... but
until then...
--
PeteCresswell

"(PeteCresswell)" <x@y.Invalid> wrote in
news:m75it6pvqt3hdgn4sjjv73mpg80se5mrk8 (AT) 4ax (DOT) com:

You probably don't need that reference at all. Remove it and see if
your code compiles.

If you "need" it, I'd re-evaluate what you're using it for. There's
almost nothing of any use whatsoever in the that library (look at it
in the object browser and you'll see). It really oughtn't be a
default Access reference, in my opinion, as it adds nothing that
anybody really needs.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Per David-W-Fenton:
That was my experience.

I removed both references, no problems... and one problem went
away.

What puzzled me was how they got there in the first place. I'd
bet the mortgage money that I didn't put them there - and I'm the
only one working on this app.
--
PeteCresswell