File dialog Box for Graphics with view option 2

[TimTDP]

I need to select a graphic file.
How can I create a file dialog box that lets me navigate folders, and when I click on a file shows a preview of the graphic?

 

[sin1965]

which version of access are u using? and which os?

 

[TimTDP]

Access 2000.
XP Pro

 

[sin1965]

make a reference to the Microsoft Scripting Runtime and use the FileSystemObject to navigate the file structure yourself. Set up a few listboxes and bob's ya uncle. A picture box can hold the preview!
hth
steve

 

[TimTDP]

Any chance that you can provide sample code?
Thanks so far

 

[sin1965]

There will be a far amount of coding involved. Try this link to find out more about the FSO

http://msdn.microsoft.com/library/d...en-us/vbenlr98/html/vaobjfilesystemobject.asp

hth
steve

 

[RoyVidar]

The standard Windows File Open/Save dialog box, I think, should give that through clicking the view button and selecting preview. Here's a handy wrapper for that Call the standard Windows File Open/Save dialog box, but I'm not sure how to get it in "preview mode" programatically.

If you're using 2002 or higher versions, you should be able to use the FileDialog, for instance like this:
[tt]
dim dlg as filedialog
dim varFile as variant

set dlg = application.filedialog(msoFileDialogFilePicker)

with dlg
.initialview = msoFileDialogViewPreview
.filters.add "Piccies", "*.bmp;*.jpg;*.gif;*.ico;*.wmf", 1
if .show then
for each varFile in .selecteditems
msgbox varFile
next varFile
end if
end with

set dlg = nothing[/tt]

You will need a reference to the Microsoft Office Object library to use this (in VBE - Tools | References)

Roy-Vidar