Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 24th, 2004, 04:32 PM
Registered User
 
Join Date: Nov 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Filedialog not defined.

Hi everbody,

I'm using Access 2000. Want to Open a file through a dialog and I am using the example. First line states:
"dim dlgopen as FileDialog" which produces an Compile-error : "User-defined type not defined"

Why ?? The FileDialog is a property of the Application Object.
 
Old March 24th, 2004, 05:19 PM
Authorized User
 
Join Date: Feb 2004
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've also got A2K and it has no such member. It does not show up in my object browser either for any of the standard libraries. You may want to look at the Shell32 API procedures.

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]
 
Old March 25th, 2004, 05:37 PM
Registered User
 
Join Date: Nov 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Jurgen,

Thanx !:D
You set me off into the right direction, had to enable "Microsoft Office 10.0 Object Library". And clean up the code from the example. The example is NOT copy/paste proof. (Nice going MS !!)
(The Access Help isnt helpfull anyway)

Jos






Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB.Connection user-defined type not defined Wall st Guru Excel VBA 2 March 26th, 2014 03:44 PM
Appl-defined or Object-defined error 1004 chp Excel VBA 3 April 4th, 2006 08:12 AM
User-defined type not defined (Icecream.mdb) dloren01 BOOK: Beginning Access VBA 0 June 22nd, 2005 10:36 PM
Choose all the JAR files by using FileDialog anand_indya J2EE 0 March 8th, 2005 10:01 AM
Application-defined or object-defined error James Excel VBA 1 August 12th, 2003 11:50 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.