Complie Error 1

[dvannoy]

I have a couple of users that are getting a compile error when there using forms within the database...I tryed unloading and re-installing ms office and that did not work..I know the code works fine. I have it running on several different systems..

Can someone help?

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[Databaseguy]

Could you post the code? Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[dvannoy]

I was using the space command...the error message that comes up is, something about it not found in the library DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[Sameal]

Sounds like they could be missing some library files on their computer that your other computers have on them. Go to one of the computers that it is working on, document all the refrences in your VBA module that are being used as well as the files that go with each one. Then go back to the other computers and check to make sure each one of those files is there and is an up-to-date version. Hope this helps you a little bit. As for the space command, have no clue what your talking about, so I don't know which library file would be missing. You could try to find the documentation for it and maybe it would tell you which library that method belongs to?

 

[GingerR]

try this faq from General Access Forum


faq181-936

 

[archery]

This normally happens when there are "missing" libraries.
If your users are running an MDB file then do the following:

Open database in design mode (hold Shift key down when starting)
Open ANY module in "design" mode
Then select menu option - Tools/References

This will list all available libraries and the ones used by your application will be ticked.
If one of those ticked has "MISSING" there is your problem

Determine what is missing and install them on your users PC in the required directory (can find this out from YOUR PC by doing above steps)

 

[archery]

Oops !!!! - an addition to my previous post.

If your users are running an MDE you will NOT be able to do the before mentioned steps as you cannot get the database opened in design mode. You will have to get YOUR .MDB file onto their PC(s) and then do the above.

 

[GingerR]

the code in the faq mentioned above - does this for you whenever each user opens the db - put it in and you wont have to go running around to people's machines doing this manually. especially helpful when your users are spread out all over the place....

 

[archery]

To GingerR

Cool !! - thanks for this tip. Have just implemented it myself and (hopefully) it gets rid of a worry for me re a 250+ user system operating across a WAN.