 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Browsing the hard drive for photos
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. 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 * > 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. 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. > Hi Jenny, > [quoted text clipped - 31 lines] > > > > How do I do that?! Please help. 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 * > Thanks for the reply. > [quoted text clipped - 45 lines] >>> >>> How do I do that?! Please help. 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 > 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. 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 > 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 [quoted text clipped - 12 lines] > > > > How do I do that?! Please help. You can download Northwind from http://www.microsoft.com/downloads/details.aspx?FamilyID=c6661372-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.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hello Ruth, > [quoted text clipped - 29 lines] >> > >> > How do I do that?! Please help. 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 __________________________________________ > You can download Northwind from > http://www.microsoft.com/downloads/details.aspx?FamilyID=c6661372-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. |
Reply to this Message |
 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.