Common Dialog --Filename

[jkejke]

In Visual Basic when I insert the Common Dialog box it has the ability to use the file name of a diskette on the A: drive--In Access 2000 want to do same---however commondialog does not have filename ability--am I overlooking or what?

 

[SkipVought]

Hi,

There are probably more ways than one to do this, but if i am in Word or Access, I add a reference to Excel and use the GetOpenFilename Method. Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[JustinEzequiel]

'I tried this on Access 2002:

Option Compare Database
Option Explicit

Private Sub Command1_Click()
    Dim dlg As FileDialog
    Dim i As Long
    Dim sFile As String
    
    Set dlg = Application.FileDialog(msoFileDialogOpen)
    
    With dlg
        .Show
        For i = 1 To .SelectedItems.Count
            MsgBox .SelectedItems(i)
        Next i
    End With
    
    Set dlg = Nothing
End Sub

 

[lafuma]

hi,

I also used "application.filedialog" in an Access 2002 database.

I want to open this database on a computer where Access 2000 is installed, but Access 2000 does not know this command.

Which command can be used in Access 2000 to select folders or paths?

LL

 

[SkipVought]

lafuma,

Please start a new thread!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[eric059]

The answer is to call the windows API directly.

I did it a few years ago.

You can find the answer in the book "Hardcore Visual Basic" and also some parts in Dan Appleman's book "Visual Basic Programmer's Guide to the Win32 API"

It helps if you have VB6 installed on your computer as it has tools/templates that will help you call the API properly.

The nice thing is you'll never get a goofy license error message from calling the API.