Acc 2003 - common dialog

[Luke Bellamy]

Hi,
I've just installed Acc2003 and my old A2K2 MDB file
referenced comdlg32.dll. When I open it in Acc2003 it
tells me the reference is missing and when I browse and try
to correct the reference it tells me it cannot use that file.
I ensured that it was present in the registry.

Has anyone experienced this? I know there is a new way you
can open, searching techniques with A2K2 and A2K3 but wasn't
ready to jump to that yet.

Any ideas appreciated.

 

[Allen Browne]

Hi Luke

You can pretty much guarantee versioning problems with the common dialog. It
is much easier in the long term to bite the bullet and use the API calls.
Example for File Open/Save at:
http://www.mvps.org/access/api/api0001.htm

Although there is a FileDialog object in the later versions, that's not a
good way to go. Requires a reference to the Office library. Obviously won't
work with older versions. Won't work with mde/runtimes. And does not work at
all for Save As, even though it offers that in the Intellisense.

 

[Luke Bellamy]

Excellent - Thanks Allen.

Interesting feedback on the FileDialog object... it sounded good from the
documentation so had high hopes. Just can't beat the API calls

Luke

Hi Luke

You can pretty much guarantee versioning problems with the common dialog. It
is much easier in the long term to bite the bullet and use the API calls.
Example for File Open/Save at:
http://www.mvps.org/access/api/api0001.htm

Although there is a FileDialog object in the later versions, that's not a
good way to go. Requires a reference to the Office library. Obviously won't
work with older versions. Won't work with mde/runtimes. And does not work at
all for Save As, even though it offers that in the Intellisense.