Calling format function in textbox control

[Max Moor]

Hi All,
I'm getting closer... The splash screen in my app has a text box to
display the version. The control is:

="Version " & Format(GetVersion(), "Fixed")

Like with my logo, on my development PC, with all things in the world
installed, this works fine. On my test PC, with only the bare Windows 2000
OS installed, I get #Name.

I found that it is the Format function that it's choking on. Am I
missing a reference maybe? I have:

Visual Basic For Applications
Microsoft Access 10.0 Object Library
Microsoft ActiveX Data Object 2.1 Library
Microsoft ADO Ext. 2.8 for DLL and Security
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Office 10.0 Object Library

Can I possibly be missing something? Is there something else
maybe?

Thanks for the help,
Max

 

[Wayne Morgan]

A References problem is a good possibility. You will find information on
tracking these down here.

http://www.allenbrowne.com/ser-38.html

 

[Max Moor]

A References problem is a good possibility. You will find information on
tracking these down here.

http://www.allenbrowne.com/ser-38.html

Yes!!! The article and the Knowledge Base article it points to, got me
looking in the right places. It turned out that, even though I thought I
had the right version of MDAC being installed by my installer, I was really
installing 2.7. The database references 2.8.

Funny... The clincher clue came when I tried to open the MDB version of
the file on the test PC. It gave me a real direct error message about the
broken reference. The MDE version just opened quietly and happily. It
just didn't work. I guess I'll try the MDB right of the bat in the future.

Thanks for the help, Wayne.

- Max