Mark Hensler — Thu, 07 Dec 2000 07:54:17 +0000

hmm... I overlooked that, sorry.

All I can find in these books (2 VB books) is this:

Private Sub cmdShowOpen_Click()

'  Show the open dialog bos
CommonDialog1.ShowOpen

'  Show the filename selected
txtReturn.Text = "FileName = " & CommonDialog1.FileName

End Sub

You said your doing something with Access, are you using VBA then? I'm not to sure if there is a difference. I've never written anything for Access. So I'm just speaking from the standpoint of a Visual Basic 6 programmer.

Here is some more stuff...
I took this from this page, which I found from these search results for "common dialog box open" at msdn.microsoft.com

Public Function GetFileToOpen()
    Dim fileflags As FileOpenConstants
    Dim filefilter As String
    'Set the text in the dialog title bar
    CommonDialog1.DialogTitle = "Open"
    'Set the default file name and filter
    CommonDialog1.InitDir = "\"
    CommonDialog1.FileName = ""
    filefilter = "Visual Basic Files (*.vb)|*.vb|All Files (*.*)|*.*"
    CommonDialog1.Filter = filefilter
    CommonDialog1.FilterIndex = 0
    'Verify that the file exists
    fileflags = cdlOFNFileMustExist
    CommonDialog1.Flags = fileflags
    'Show the Open common dialog box
    CommonDialog1.ShowOpen
    'Return the path and file name selected or
    'Return an empty string if the user cancels the dialog
    GetFileToOpen = CommonDialog1.FileName
End Function

more helpfull links from MSDN:
CommonDialog Control (Open, Save As Dialogs)

that's all I can find now... need to get some sleep
Good Luuck,

merlin — Wed, 06 Dec 2000 10:35:25 +0000

as i mentioned, the dialog box worked. but now: how do i get the path of the selected file?
the file name i get:
object.filetitle
but how can i get that path? ???
in the docs there is nothing mentioned, but i'm sure it's somehow possible... thank you!

thank you!

merlin — Mon, 04 Dec 2000 16:44:24 +0000

yes, that worked!
well, to be honest, it was quite a lot of work too: i had to install ms access 2000, developer version, and then it worked...
thank you max!

ali

Mark Hensler — Sat, 02 Dec 2000 03:26:29 +0000

well, it says in this here book (some VB book off my bedroom floor )...

[I'm assuming your using Microsoft Visual Basic 6 (the program) to write this.]

On the left, in your 'toolbox' you'll need to find the 'Common Dialog Box' control. If it's not there, just right click the 'toolbox' and select 'components...'. Scroll down in the textbox untill you find 'Microsoft Common Dialog Control 6.0'. Check the box to the left and click 'OK'. Now the control should be in your 'toolbox'.

Moving on... Place the Common Dialog Box control anywhere on your form. Now name your control (let's say cdbDialog). Now wherever you need to use that 'give me a file' thingy, simply use:

'the following code is right out of the book
cdbDialog.DialogTitle = "File Open"
cdbDialog.Filter = "*.txt"             'show only text files
cdbDialog.FileName = "*.txt"           'default filename
cdbDialog.ShowOpen                     'trigger the dialog box

Need more help, feel free to ask. Also you might want to check out these search results (for 'common dialog box') at MSDN.

Good Luck,

merlin — Fri, 01 Dec 2000 07:14:24 +0000

yes, in visual basic. we have some really great cracks in vb in here, but well, they knew it can be done but didn't know how...
thank you for your help, i really appreciate that!

Mark Hensler — Fri, 01 Dec 2000 04:55:33 +0000

you mean like in visual basic?
I don't know that off the top of my head, but I think I can get it for you pretty easy...

or in html?

other language?