Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / November 2007

Tip: Looking for answers? Try searching our database.

Open Common Dialog with thumbnail view

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Arno R - 21 Nov 2007 15:01 GMT
Hi all.

When I need to search for pictures, I always have too choose thumbnail-view manually.
Is it possible to open the common dialog in thumbnail-view programmatically?
Example ??
At the moment I am using Ken Getz' code. at http://www.mvps.org/access/api/api0001.htm 

Thanks
Arno R
Salad - 21 Nov 2007 16:11 GMT
> Hi all.
>
[quoted text clipped - 5 lines]
> Thanks
> Arno R

I like Irfanview.  http://www.irfanview.com/.  I don't use it within my
Access apps but it's great for viewing pictures and thumbnails.
Arno R - 21 Nov 2007 17:28 GMT
>> Hi all.
>>
[quoted text clipped - 8 lines]
> I like Irfanview.  http://www.irfanview.com/.  I don't use it within my
> Access apps but it's great for viewing pictures and thumbnails.

Can I use Irfanview from within Access to select (the path to) pictures?
I need the pictures in Access of course. I need to save the path to Images for certain records.
So the common dialog is fine, but it would be nice if it would open in thumbnail-view.

Btw: I use ACDSee for browsing/viewing pictures.

Arno R
Salad - 21 Nov 2007 18:17 GMT
>>>Hi all.
>>>
[quoted text clipped - 12 lines]
> I need the pictures in Access of course. I need to save the path to Images for certain records.
> So the common dialog is fine, but it would be nice if it would open in thumbnail-view.

I don't see why not.  I upgraded my old version to see what the most
current command line options are.  Here are 3 of them
  /slideshow=txtfile - play slideshow with the files from 'txtfile'
  /slideshow=folder -   play slideshow with the files from 'folder'
  /thumbs -   force thumbnails

I suppose you could make a command line like
  i_view32.exe /slideshow=C:\Test /thumbs
to display all the image files in C:\Test as Thumbnails.

Irfanview is a small program and quick to download.  There's so many
command line options (see the help topic on it) that it should be able
to do what you like.  I suppose you'd need Shell() to open it with the
command line options tho.  I'm not sure why you need to store the
pictures in an Access table, maybe A2007 has good control of that.

> Btw: I use ACDSee for browsing/viewing pictures.

Probably has some similarites to Ifranview.  Irfanview is freeware
(non-commercial use).  If you press the About button in the program is
says "This copy of Irfanview is registered to You".  No time/eval periods.

> Arno R
Arno R - 21 Nov 2007 19:04 GMT
>>>>Hi all.
>>>>
[quoted text clipped - 36 lines]
>
>> Arno R

Well, I might try Irfanview. Not sure how much work that will be...

>  I'm not sure why you need to store the
> pictures in an Access table, maybe A2007 has good control of that.
As I said I only need the *path* to the Image. I am not storing the images themselves.

I wil explain further:
What I am looking for is a 'facility' to make the following easy:
A guy ( a shop owner) gets new goods, takes pictures from his goods, stores these pictures somewhere on his PC and ...
afterwards he adds records of his new goods to his database, and also wants to add (a link to) the pictures ...
I still think that presenting a common dialog to 'pick the pics' is sufficient, but thumbnail-view would be nice.

Thanks
Arno R
Salad - 21 Nov 2007 20:19 GMT
>>>>>Hi all.
>>>>>
[quoted text clipped - 52 lines]
> Thanks
> Arno R

I've been playing around with this because its an interesting concept
although I don't fully understand your needs.  Not sure if this is
anything you want to do but...I opened up my thumbnail jpgs in Irfanview
and selected a few and had Irfanview make an html page of them.  Well,
this converted the jpgs to thumbnail jpg images.  I went to the folder
where they were created and deleted the full size pics and html file.

I then created a table in Access...3 fields; ID, PicText (text to define
it), and PicFile (the hyperlink to the thumbnail).

Now I created a form and dropped those three fields into them and
created an image control.  In my OnCurrent event my code is
    Private Sub Form_Current()
       Me.Image6.Picture = HyperlinkPart(Me.PicFile, acAddress)
    End Sub

As I go through each record (single form) it displays the thumbnail to
the screen.  I suppose with a dblclick (no need to show the hyperlink)
and I could call/open the picture.  Thus Pic1.jpg is the full size pic,
Pic1T.jpg would be the thumbnail.

There's the old problem with continuous forms...if you had multiple
images (you can see more than 1 record) all images would be the current
image.

You might want to check out Tucows (http://tucows.com) as well.  There
might be something there.  Perhaps start with "Thumbnail view" for
searching.
Jens Schilling - 21 Nov 2007 20:36 GMT
Hi,

> Hi all.
> When I need to search for pictures, I always have too choose
> thumbnail-view manually.
> Is it possible to open the common dialog in thumbnail-view
> programmatically?
> Example ??

Karsten Pries (a german developer) once created a demo on how to use a
common file dialog with the ability to choose between different kind of
views.

Available views are :
List, Details, Large Icon, Thumbnail, Small Icon and Tile.

He clearly punctuated that it's only tested with AXP and Win XP, and noone
may expect that it can be used with older versions ( maybe you can try
A2000 ) .

I case of interest visit this page:
http://www.kpries.de/index.htm?Entwicklertools/filedialog.htm
(german language only).

There you have to look for the red labeled subsection "Spezialversion" where
you may find this:
Download: comdlgdemoXP.zip für Windows XP und Access 2002 (XP)

The german readme-file gives some more information, so maybe any translation
service (such as google language tool ) may be a little help.

Regards
Jens
Arno R - 21 Nov 2007 22:25 GMT
> Hi,
>
[quoted text clipped - 29 lines]
> Regards
> Jens

Thanks much Jens !!
Since I am a 'neighbour' (I live in Holland), I am able to read German.

I will test the code further tomorrow, but I did see it worked in Access 2003 and Win XP.
Quickly converted to Access 2000. It works !!
Converted to Access 97 ==>  Fails on Enum code ... (have to look at that)

Thanks much again !!

Regards,
Arno R
Jens Schilling - 22 Nov 2007 07:51 GMT
Hi, Neighbour ;-)

>>> Is it possible to open the common dialog in thumbnail-view
>>> programmatically?
[quoted text clipped - 3 lines]
>> http://www.kpries.de/index.htm?Entwicklertools/filedialog.htm
>> (german language only).

> Since I am a 'neighbour' (I live in Holland), I am able to read
> German.

OK, Arno - so it's much easier for you...

> Converted to Access 97 ==>  Fails on Enum code ... (have to look at
> that)

As you can read in the readme-file next to Enum-problems the
AddressOf-Operator is mentioned.
I my link collection I found a hint to the AddressOf-Operator refering to
Michael Kaplans homepage :

http://www.trigeminal.com/lang/1033/codes.asp?ItemID=19#19

I didn't checked it out but maybe you can find there some information on
that.
And if you got it to run with A97 please let us know.... ;-)

Regards
Jens
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.