ActiveX Controls

[weazer via AccessMonster.com]

I split my database with the back end on the server and the front end on the
c drive. I have the ActiveX Control calendar on my dat entry form. It works
fine on my PC but does nor work on anyone else's PC. The same goes for the
datedif function.

Any ideas.

Thanks.

 

[Guest]

Hi Weazer,

I split my database with the back end on the server and the front end on the
c drive.

In that case, I invite you to take a look at this article:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

I have the ActiveX Control calendar on my dat entry form. It works
fine on my PC but does nor work on anyone else's PC. The same goes
for the datedif function.

Make sure that you do not have any references marked as MISSING, since you
are calling the DateDiff function. That should work on all PC's, if you are
using it correctly on your development PC. Here are two excellent articles on
the topic of missing references and the problems they can cause:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Personally, I advise you to dump the ActiveX calendar control. It will cause
you no end in headaches. Here is a good alternative, which does not rely on
ActiveX technology:

Popup Calendar
http://allenbrowne.com/ser-51.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________