Building a card game with cards.ocx

[G37Sam]

I know many here hate to work with custom ActiveX control but entertain me please. I am using Windows XP with Access2007 FYI

I started by copying cards.ocx (availabe online for free) into C:\windows\system then registering the .ocx file using the following command in cmd

regsvr32 cards.ocx

That worked perfect

From within the form's toolbox, I choose ActiveX control and choose cardsocx only to get an error stating:

"A problem occurred while Microsoft Access was communicating with the OLE Server"

Is there something I missed?

 

[vbaInet]

Try this method to register the ActiveX control:

http://support.microsoft.com/kb/918574

 

[G37Sam]

Still getting the same error, I'm guessing the mentioned method is no different from regsvr32, nor is the one mentioned here either: http://support.microsoft.com/kb/173091

The thing that's bugging me most, is that if I register the ocx using Visual Basic 6 (or .net) then Access starts to recognize it. If I move to another machine with no VB6 VB.net, access then gives me the same error again

 

[vbaInet]

Perhaps that ocx isn't supported in Access 2007. Send me a copy and I'll try and register it on mine.

 

[G37Sam]

Here's a download link to the ocx file: http://www.ocxdump.com/ocxfiles/C/cards.ocx

 

[G37Sam]

Any luck?

How about using the cards.dll in system32 that's automatically installed with Windows, would that be possible?

 

[vbaInet]

Not had a chance to have a look Sam. Got home and fell asleep

And I can't install it at work.

Have you tried the one that is already installed?

 

[G37Sam]

Haha sorry man didn't mean to pressure you

I got the cards.dll to work on VB6 with the help of a tutorial, couldn't do anything about it in Access though. Cards.dll however draws on the form rather than create a control so I'm assuming some sort of API would have to be used, that's where I chickened out

 

[vbaInet]

The cards.dll must contain a couple of classes that expose functions for drawing on the form. Obviously intellisense will expose the properties, methods and functions but the difficulty is getting documentation on its use

No pressure, I planned to look at it but was just too tired

 

[vbaInet]

Just tried to install it without success. Perhaps the ocx wasn't made with Access in mind.

If RunCommand doesn't register it then it's not compatible with Access.

 

[G37Sam]

Thanks for your feedback vbaInet, appreciate it

 

[Max D]

ActiveXs have problems with 64-bit versions of office. Beside that, try to put your ocx at some other location (like c:\) - it can make a difference.

Also you can try to open your OCX via some editor or viewer and check DLL it uses. Maybe it relies on some DLL that is missing on targed PCs.

 

[G37Sam]

I am on a 32-bit Vista though

If it's not too much to ask, can you give it a shot and see if it can be done from your end?

 

[Max D]

CARDS.OCX installed ok at my WinXP via simple regsvr32 command and works ok at Access.

I found references to this files inside:
MSVBVM50.DLL
VBA5.DLL
PICCLP32.OCX

Check, if this files are present at "bad" PCs

 

[G37Sam]

I owe you a beer! Let me know if you're ever in Dubai

 

[vbaInet]

I owe you a beer! Let me know if you're ever in Dubai

Maybe you could offer Max D a free ticket and free accommodation so he can come and get the beer.

 

[Max D]

I owe you a beer! Let me know if you're ever in Dubai

Glad it helped you! I'm too far from Dubai and i'm not drinking alco already