[RESOLVED] Format() function not working at all

[FanGuy]

I've recently returned to VB6 and am having an issue with the Format() function. I wrote a program years ago and it worked correctly then. When I try to run it now it gives me that compile error "can't find library" at all the Format functions.

An example of how I'm using it is like so:
string = "C: " + Format(getHDUsed, "###,.00") + " GB"

I'm thinking that I'm missing some kind of add-in or library but I don't know which is associated with the Format function. Nor do I even remember how to install add-ins or libraries. If anyone could help me with this, it would be much appreciated.

[RobCrombie]

Change + to &

And if still problems, try a simpler Format instruction and see how that goes

[FanGuy]

Change + to &

And if still problems, try a simpler Format instruction and see how that goes

Thanks for responding.

Ive already tried + to & that doesn't seem to be the issue.

Format() is used thoughout the program and it seems like it doesn't want to work anywhere. Some examples are more simple than others.

[RobCrombie]

Private Sub Form_Click()
  Me.Print Format(Date, "yyyy mmm d")
End Sub

Does that work on your pc (it works on mine)

[RobCrombie]

Are your Project References like this (ignore the highlighting)

[zynder]

Did you put any reference? Check for MISSING OCX / LIBRARY in the reference and uncheck it. It may be deleted from the windows system32 folder.

[FanGuy]

It looks like this: (These are the ones checked off)

Visual Basic For Applications
Visual Basic runtime object and procedures
Visual Basic objects and procedures
OLE Automation
Messenger API Type Library
Windows Media Player
Windows Media Player
Windows Media Player
Messenger Type Library
Messenger Private Type Library
MISSING: Messenger Addins Type Library

And the the rest that are not checked

[RobCrombie]

If you are having trouble attaching the image, you can send it to me -
robhp AT iprimus DOT com

[RobCrombie]

In the meantime.
All the ticks in my image are normally there in every VB6 project.
So go ahead and ensure they are ticked in your project.

Whilst you are solving this, you should be doing it in a tiny stand alone example.
Once you get that working, then go back to your larger project.

[FanGuy]

In the meantime.
All the ticks in my image are normally there in every VB6 project.
So go ahead and ensure they are ticked in your project.

Whilst you are solving this, you should be doing it in a tiny stand alone example.
Once you get that working, then go back to your larger project.

will do thanks for all your help. This is something that I'm scratching my head over.

[RobCrombie]

Try running the attached

[FanGuy]

Private Sub Form_Click()
  Me.Print Format(Date, "yyyy mmm d")
End Sub

Does that work on your pc (it works on mine)

Sorry I didn't respond to this right away. This works when I open a new project. Even this works:

Private Sub Form_Click()
  Me.Print Format("123456789", "###,.00")
End Sub

But when I add it to my already existing project, it doesn't work. It gives me the same error.

[RobCrombie]

We have not seen an image of your References dialog

(VB can get huffy when there is a different problem elsewhere)

[FanGuy]

Reference Dia.:

http://s173.photobucket.com/albums/w...t=untitled.jpg

[RobCrombie]

Yup, probably that missing reference is confusing VB

[ganeshmoorthy]

MISSING: Messenger Addins Type Library

this the thing that causes the problem...if you know that you are using the functions from this library then browse it, else just remove this and you should get other errors, but it will not stop on the format function.

[FanGuy]

That was it!!!! I just unchecked the MISSING. It work perfectly now just like I remember.
Thanks so much.

Now how do I mark this as RESOLVED?

[zynder]

That was it!!!! I just unchecked the MISSING. It work perfectly now just like I remember.
Thanks so much.

Now how do I mark this as RESOLVED?

You did missed reading post #6 right?

[FanGuy]

You did missed reading post #6 right?

Yes, I gues I did.

[zynder]

Click the thread tools and Mark thread resolved.