Format$ problem
Posted by Fred Donahoe on January 08, 2001 5:22 AM
This line of code works perfectly on my machine.
txtTotal.Text = Format$(txtTotal.Text, "$###,###,###")
but it higlights Format$ and gives a message "Compile error Can't find project or library" on everyone else's computer in the office. This same code, in a stand alone VB program, runs fine on every computer. Whats wrong? Thanks for your time and effort.
Posted by Greg on January 08, 2001 10:08 AM
response: You have a library reference in the macro that the other users don't have. Open up the macro on the other machine and go to tools, reference and there will be a list of the library references for that macro. There will be one that says missing, uncheck the box next to it and that should fix the problem. I had that same problem a couple days ago and that fixed it.
