File Dialog Error using MS 365 - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

File Dialog Error using MS 365

J David Bacon

3 years ago

I am trying to Import a CSV File into a Table. The VBA Code is as follows:

On Error GoTo fileError
DoCmd.SetWarnings False
DoCmd.OpenQuery "_DeleteDLTransactionQ"
Dim csvName As Variant, csvSelected As String, csvDialog As FileDialog

When the Dim Statement is executed, I get the following Error:

Compile error:
User-defined type not defined

A check in the References and Microsoft Office 16.0 Access database name object is Checked.

Compact and Repair does not fix the problem. I have used this Dim Statement before without any problems, and I get the same error when I in the other Databases.

	Kevin Robertson @Reply 3 years ago
You need to add the following reference: Microsoft Office 16.0 Object Library

	J David Bacon OP @Reply 3 years ago
The Reference to the Microsoft 16.0 Access database name object is checked. Is this different from the MS Office 16.0 Object Library, and if so, where can Imfind it.

	Kevin Robertson @Reply 3 years ago

	J David Bacon OP @Reply 3 years ago
I found the object reference'.and now the Dim csvFileDialog works correctly. Thanks for your help. Tomorrow I will review the Date Search Query etc, as you suggested.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View