Recently I've been working with my friend on a Access project require some upgrade. In one of forms I've used ListView Active X control, the reason was that it looks good, add a professional look and most of all we have good control over it to fill data or to set column headers etc.
All went very well, until I've sent the Ms.Access file to my friend for testing, then comes the worse part, at the start of file got error something like Active X control not properly registered. I've sent a link to VB controls file which could be downloaded from MS site, and do the un-register then again register the control mscomctl.ocx. After that atleast 2 out of 3 forms work fine, but one form still shows error regarding MouseMove event:
"The expression MouseMove you entered as the event property setting produced the following error: There was an error loading an ActiveX control on one of your forms or reports"
And funny thing is there is not MouseMove event use in all forms with ListView control.
So long story short I have to replace ListView with traditional listbox of Ms.Access. The reason for posting this to the group is to know is there any workaround available so that if we distribute our application using ListView to clients, they don't have to go through all file downloading and do the regsvr32 mscomctl.ocx type stuff? Can we some how distribute ActiveX controls alongwith Ms.Access application, and all settings can be done via VBA coding so that at startup Ms.Access should check whether there is any problem with ActiveX control, and fix it?
I am already working on another application, this is an Accounting Software and I am already use many ListViews, so you can understand my concern :|
Tidak ada komentar:
Posting Komentar