Using common dialog control

[shep6]

If I choose to use the Microsoft Common Dialog Control 6 in an Access 2000 project, will the end user have any problems running the database, on a different pc. The reason I ask is that I recently created an Excel project and used the dialog control. The project was then sent to the client, and they got a "system error" when they opened the spreadsheet because of the dialog control I had used, I removed this from the project and it worked fine.

Any advice would be appreciated.

cheers

 

[gnosis13]

Did you ever find a way to distribute the common dialog with your application? I have the same problem. A+, N+, MCP

 

[oharab]

I've said it before & I'll say it again.
STEP AWAY FROM THE COMMON CONTROL DIALOG. THERE IS NOTHING TO SEE THERE!

Seriously I would not reccommend using that control to anyone. I have seen too many pleas for help when it doesn't work or there are problems when you send your database to another user!

A much better way would be to use the code from:

http://mvps.org/access/api/api0001.htm

It works everytime and you don't have to worry about setting references.
If it's not the open save dialog you are calling, let me know, I've got code that will call all of the common dialogs.


HTH

Ben


----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------