Common Dialog Active X Control in Vista

[JLW]

I recently transferred my Access 2003 database to my Vista laptop and found
that the active-x common dialog control no longer works. In fact the
container for the control looks likes it is empty although I can still see
the properties dialog box for it.

On another Vista conversion matter, there are also a number of annoying
warning messages that appear every time I start up the database which I would
like to turn off. Does anyone know of a solution please. Thanks.

 

[Scott McDaniel]

I recently transferred my Access 2003 database to my Vista laptop and found
that the active-x common dialog control no longer works. In fact the
container for the control looks likes it is empty although I can still see
the properties dialog box for it.

Get rid of the CD control, and use the API code from the Access Web:

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

It's a bit more work but worth the effort ...

On another Vista conversion matter, there are also a number of annoying
warning messages that appear every time I start up the database which I would
like to turn off. Does anyone know of a solution please. Thanks.

What warning messages are you getting? If they're the Access security messages, then you can set the Macro security to
Low (although MS doesn't recommend it). There are other methods of removing these messages, if need be, but they entail
a good bit more work.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[JLW]

Thanks Scott, I havn't implemented this yet but it looks like a good
solution. I still wonder why the control isn't working any more but I have
learnt more from it's failure so that's good.

I realised how to sort out the macro warnings pretty quickly after I sent
the e-mail by setting the security to low. I will leave the more
sophisticated option to another day.

Many thanks again.