Common DialogBox

[drkestrel]

I am trying to create a Common Dialog Box that would pop up the standard file open dialog and return me with the filename selected.

I attempted to do this at Access 2000 by
1) Going to design view of the desired form
2) Insert Menu
3) Select ActiveX Control
4) Select COMMON DIALOG CONTROL

Then I get error-
The OLE Server isn't registered
To register the OLE server, reinstall it!

Hey, how could I do these??

 

[TheInsider]

Hi,
check out "thread222-34387" in the "Visual Basic(Microsoft) - General discussion" forum. It covers this.

Rob Marriott
rob@career-connections.net

 

[drkestrel]

The thread refers to problem in VB, but my problem actually happens in VBA for Access 2000

 

[TheInsider]

True, but an ActiveX control such as the common dialog is based on COM which works in all programming environments. It is the same control. Have you tried the stuff in the thread yet?

Rob Marriott
rob@career-connections.net

 

[drkestrel]

SOS

I tried, but unfortunately, it doesn't work.
I tried on two machines, one with that OLE Server isn't registered error, and the other one with "You don't have the license required to use this ActiveX Control. You tried to open a form containing an OLE Object or an ActiveX Control or your tried to create an Active X Control. To obtain the appropriate license, contact the company that provides the licensed OLE object or Active X Control."

I tried to run the VBC file for VB6 which did not work because it could not detect VB6 on my machine (cos I only have VBA for Access 2000 installed!), tried the VBCMPFIX.EXE for VB5 which was installable for me, but did not work.

Note that I also fail to-
Add references to c:\Windows\system\commdlg.dll from Tools->References
OR to
Register ActiveX Control browsing to c:\Windows\system\commdlg.dll

How could I get common dialog working on them!!?!?!

 

[chell]

Hello;

The following info works for Access 97 and might be useful for Access 2K. The source of the info is "Access 97 Developers Handbook".

The license for common dialog control comes with VB or the developers addition of access.

You could access the common dialog controls directly thru the windows API.

To get a dialog up that allows the user to select a file and which returns that file name to your application, Acess 97 has an undocumented function buried in its main program file (MSACESS) which can be called from VBA. Email me at mcpeekm@macmiller.com if you want more info.

Hoping some of this helps,
Chell

 

[rlamoreaux]

I had the same issue using w2k and access 2000, Works fine XP. I had a copy of vb6 learning edition, I installed it now alls well