Browsing the hard drive for photos

[Jenny]

I want to browse the hard drive for photos in a form through a button. A
button would be pressed and a then a photo would be picked from the hard
drive and then pressed open. I want the path to the directory to then show
up in a text box as a hyperlink.

How do I do that?! Please help.

 

[strive4peace]

Hi Jenny,

not quite sure what you are asking -- here is something you may want to
look at:

you can limit files to JPG files, for instance, scan a drive, and build
a list

List Files Recursively and add to table
http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1402349

once you have this list, you could make a form with the table and it
chould show each picture in a single-form view. I have something
similar to this that I will send if you email me

~~~~~~~~~~`

if this isn't what you want, please explain yourself better


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Jenny]

Thanks for the reply.

I will try to explain again. I'm new to this.

On a form through clicking on a button I want to browse through files in one
folder which contains JPG files. When a file has been selected I want the
directory to this file to be displayed as a hyperlink in a text box next to
the button.

Is there a way doing this without the code and just by using macros or
queries? I'm clueless about the code.

Let me know if this makes any sense.

 

[strive4peace]

Hi Jenny,

don't be afraid of code it just takes a bit of time and some good
pointers to get on your way!

start with this:

Access Basics
http://allenbrowne.com/tips.html
Tips for Casual Users
Access Basics: free tutorial - Word document by Crystal (Access MVP)

This 30-page training tutorial will orient you toward the core concepts
of Microsoft Access -- good foundation for learning programming

~~~

then email me and I will send you 3 chapters of a book I started on VBA
-- be sure to put "VBA" in the subject line so I see your message

~~~

what you want to do is going to take some coding -- would be good to
learn anyway!

~~~

also, instead of storing as hyperlink, I would store as text, you can
always render hyperlink like this:

application.followhyperlink [filenamefield]




Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Ruth]

Jenny, you didn't meniton what version of Access you're using. If
you're using 2003, try looking at the Northwind database that comes
with Access. There is an employee directory with pictures that has the
same type of function you've mentioned available when you click on the
area of the form where the picture will display. Of course you'll have
to modify the code to match your form and drive locations, but it
should provide you a good start.

Ruth

 

[Jenny]

Hello Ruth,

I don't have a Northwind database in my Access 2003. There are no sample
databases available to look at. Is there anything else I can look at?

Is there anyway to do what I want to do without using code?

I'm just so close to finishing this database and i've done it all without
code and just using queries and macros. I don't know much about code and
learning it now will take some time. I'm working on this database at work
and I don't have much time.

Jenny

 

[Douglas J. Steele]

You can download Northwind from
http://www.microsoft.com/downloads/...72-8dbe-422b-8676-c632d66c529c&DisplayLang=en

Don't worry that that's the Access 2000 version: Access 2003 (and Access
2002, for that matter) both use the Access 2000 file format as a default.

 

[Tom Wickerath]

Doug,

Don't worry that that's the Access 2000 version: Access 2003 (and Access
2002, for that matter) both use the Access 2000 file format as a default.

Surprisingly enough, the sample offered for download, NWind.exe, extracts
the Access 97 version of Northwind, not the Access 2000 version. So, one
immediately gets a conversion dialog when opening the sample with Access 2000
or later.

Another little problem...
Although the file format is Access 2000, the functionality desired in the
original post, ie. "I want the path to the directory to then show up in a
text box as a hyperlink", is not included in the version of Northwind that
shipped with Access 2000. The 2000 version, like the 97 version, used OLE
Embedding technology. The version of Access that shipped with Access 2002 and
2003 is the first one that stored the filename in a text field (not a
hyperlink data type, but closer to what the OP requested).


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________