Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 4th, 2005, 03:33 AM
Registered User
 
Join Date: Apr 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bacnk
Default How to use mscomct2.ocx in Access97

Hi all,
I have a problem with registration mscomct2.ocx.
I have an application in Access97 that using Date Time and Picker.
I bring that application to another new computer.
The main application installed in that computer:
+ WinXP/Win98SE OS
+ Access97
+ without installing Access2K/XP, VisualStudio before

I registered mscomct2.ocx successfully by using command:
run-> regsvr32 \..\mscomct2.ocx

After,I run my Application but one of ActiveX control (Date Time and Picker) not showed in my Form. So I can't use one of that Date Time and Picker.

However, when I install VisualStudio 6.0 with choosing ActiveX Control or Acess2K/XP in new Computer then my application run well.

Summery, I want to know:
1. Why the one of Date Time Picker not able to use before install
VisualStudio6.0 or Access2K/XP whether I register mscomct2.ocx successfully.
2. Whether there are some files relate to mscomct.ocx need to register ?
3. The way to register mscomct2.ocx and some file relate to be able to run my application using Access97 on new computer(never ever installed Access2K/XP or VisualStudio6.0 before)

Thank you very much
 
Old April 4th, 2005, 08:38 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

How about you go delete http://p2p.wrox.com/topic.asp?TOPIC_ID=28776 so you don't have two threads with the same question?

I use this control successfully using Access 2K and up without installing VS6. Perhaps registering the control using regsvr32 was not successful but when you installed VS6 it was.

Another possibility is that Access 97 may not search the registry to locate the control. I don't know if this is the case. But that is the only variable from the way I do it to the way you tried it. If that is the case, when you installed VS6 you may have put a copy of the control in the folder where the References in your app could find it.

There are no other dependencies to mscomct2.ocx that I know of. As I say, I'm able to use it with Access 2K and up.

One thing might be to check to version of the control that you're installing manually.

Another thing would be to check the references in your app to see if the control is found.

Another could be to distribute the Access runtime with your app so people aren't using Access 97. There may have been a change to how References/Controls are handled after Access 97. If you have the developers version of Access 2K or XP, you can distribute the runtime without royalty fee. In fact, don't quote me, but I think that since you have VS you can distribute the runtime. Check your licenses.

One last option would be to not use the control but build your own date/time picker.

My lack of experience with Access 97 is showing.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
 
Old April 7th, 2005, 09:34 PM
Registered User
 
Join Date: Apr 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to bacnk
Default

Before I show you my problem, Thanks for your reply.

May, you don't understand my problem.
My problem is:
+ There are some people use my application (Their computer install only Win98/XP ... OS, Access97 to run my Application, not install any more)
+ I have a pakage of my Application to setup on their computer.
So, I need only file mscomct2.ocx to register for my application after that application installed on computer (this computer is only installed Win98/XP..., Access97; not installed VisualStudio or any Access97 version after.
So, if you know to register mscomct2.ocx successfully with Win98/XP ... OS; without installing VisualStudio, any Access97 version after. Could help me ?

Althought, I installed my application succesfully, then register mscomct2.ocx successfully too. But when i run the applicaction, one of Date Time Picker is showed as empty rectangular. So I can't use my Date Time Picker.

Thank you very much!

Quote:
quote:Originally posted by rjweers
 How about you go delete http://p2p.wrox.com/topic.asp?TOPIC_ID=28776 so you don't have two threads with the same question?

I use this control successfully using Access 2K and up without installing VS6. Perhaps registering the control using regsvr32 was not successful but when you installed VS6 it was.

Another possibility is that Access 97 may not search the registry to locate the control. I don't know if this is the case. But that is the only variable from the way I do it to the way you tried it. If that is the case, when you installed VS6 you may have put a copy of the control in the folder where the References in your app could find it.

There are no other dependencies to mscomct2.ocx that I know of. As I say, I'm able to use it with Access 2K and up.

One thing might be to check to version of the control that you're installing manually.

Another thing would be to check the references in your app to see if the control is found.

Another could be to distribute the Access runtime with your app so people aren't using Access 97. There may have been a change to how References/Controls are handled after Access 97. If you have the developers version of Access 2K or XP, you can distribute the runtime without royalty fee. In fact, don't quote me, but I think that since you have VS you can distribute the runtime. Check your licenses.

One last option would be to not use the control but build your own date/time picker.

My lack of experience with Access 97 is showing.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
 
Old April 8th, 2005, 07:30 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

I think I understood your original problem. Perhaps the fact that I've never used Access 97 means that I don't know enough about it to understand how it works and any attempts to explain what to look for are inaccurate. I don't how to solve or even trouble shoot the problem for Access 97.

I was just suggesting possible work-arounds to the problem. Sometimes you just have to give up on the solution you are trying because the tools you are using were not designed to work the way you think they should.

One solution is to use the run-time instead of trying to fix Access 97.

Since you mentioned Access 2K, I was assuming that you had the ability to develop the application in that version. You are perhaps assuming that you are stuck with Access 97 because those other computer are only licensed to install Access 97.

Even though other computers don't have a license to install full Access 2K application, you may have a license to install the Access 2K "run-time" on those other computers. If you do have a license, then you could install the Access run-time while you're installing your app. Using Access 2K run-time instead the Access 97 full install my solve the problem you are having with the Date/Time picker control.

The "run-time" is a component that comes with every version of Access version 2000 or later. This MSDN article discusses it further. http://msdn.microsoft.com/library/de...ssolutions.asp

Another solution is to abandon the date/time picker control in favor of building your own forms to pick a date. John Viescas (http://www.viescas.com/) demonstrated how he did this at our last PNWADG meeting. If you build your own forms, you are not as dependent on what version of Access people are running or what version of the control is installed on their machine.

You asked if there were other dependencies for the date/time picker control. Your assumption is that there are. You may be correct. However, by installing VS or Access 2K/XP on the computer, you may be installing something that cannot be installed without a license to either VS or Access 2K/XP. It's difficult to tell what all gets installed. But you may be installing one or more DLLs that have new ways of managing forms, DLLs that aren't available unless you are upgrading your software or that are too complicated to install without a full software upgrade.

Maybe it's time to move forward to Access 2K/XP instead of trying to fix Access 97. OTOH, maybe the Access run-time won't install the proper components such that the Date/Time Picker control will work.

At any rate, if you must stick with Access 97 and the Date/Time Picker control, I'm no help. Sorry.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
 
Old April 25th, 2005, 05:15 AM
Registered User
 
Join Date: Apr 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Following on from the (almost) throwaway comment made by Randall, I have encountered this problem before, and to assist other people (as well as myself), I have written a date picker that requires no end-user control registration etc. It is a free download, although you can, if you wish, donate to me (shameless plug over!). You can find it at the following link:
http://www.programmersheaven.com/sea...p?FileID=30310.

Hope this helps you.

Regards

Tony Steer
 
Old April 26th, 2005, 07:52 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

Tony, I sure hope you weren't taking a stab at me with the "throwaway" statement. Not a good way to influence people to want to "donate" to you. At least I took a shot at sending bacnk somewhere for an answer.





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to register mscomct2.ocx (once again) bacnk Access 0 April 10th, 2005 10:44 PM
How to use mscomct2.ocx in Access97 bacnk Access 0 April 4th, 2005 03:32 AM
mscomct2.ocx CloudNine Access 2 January 15th, 2004 08:12 PM
MSFLXGRD.OCX and MSDATGRD.OCX Clive Astley Access 1 July 25th, 2003 08:47 AM
mscomctl and mscomct2 ocx"s" alb Beginning VB 6 3 July 21st, 2003 12:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.