[AccessD] adh replacements

Gustav Brock gustav at cactus.dk
Wed Jan 26 08:35:01 CST 2022


Hi Arthur

For that to work, you need to set a reference to:

Microsoft Office 16.0 Object Library

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af Arthur Fuller
Sendt: 26. januar 2022 15:29
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] adh replacements

Thanks, Ryan. There seems to be an error in the example:
    'Declare a variable as a FileDialog object.
    Dim fd As FileDialog
  "Undefined User Ty[e

This raises an error "Undefined User Type." Maybe it should be declared as Application.FileDialog?

On Wed, Jan 26, 2022 at 8:28 AM Ryan W <wrwehler at gmail.com> wrote:

> https://docs.microsoft.com/en-us/office/vba/api/office.filedialog
>
> Sent from my iPhone
>
> > On Jan 26, 2022, at 3:16 AM, Arthur Fuller <fuller.artful at gmail.com> wrote:
> >
> > Now that I have removed all the 32-bit functions that I got from 
> > Access Developer's Handbook, I'm wondering what the "modern" way to 
> > do some things, such as invoking the File SaveAs dialog. Suggestions?
> >
> > --
> > Arthur 


More information about the AccessD mailing list