How to locate a file and extract filename into access table.

[bballpinhead]

I am on a project where I need the capability to locate a file through
MS Access such as a pdf and extract the file name into a designated
table. Is there a way that I can do this in a command button? PS. I
would like to be able to access any folder on my computer in a
directory view screen.
Thanks in advance.

 

[Roger Carlson]

Yes, look here for specifics:
http://www.mvps.org/access/api/api0001.htm

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SaveFileToSpecificDirectory.mdb" which uses this process.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[bgreenspan]

I am trying to do the exact same thing. I tried to implement Roger's
example but I keep getting errors. Perhaps I need a little more
guidance.
p.s. Roger - your website has some fantastic resources. Thanks

 

[bgreenspan]

I think I found an answer here

http://support.microsoft.com/default.aspx?scid=kb;en-us;824272&Product=off2003

The routine they show puts the selected files in a list box. I added a
line to assign the selected file to the variable in my table. It
works. I now have a table with links to any file I select.

- Bernie

 

[bgreenspan]

Using the instructions at

http://support.microsoft.com/default.aspx?scid=kb;en-us;824272&Product=off2003

I added a button that opens a file dialog box and allows me to select
the file I want. I added a line of code to load the file name
(complete with path) into the field in my form and table.

Now I am having trouble getting the entries to act like links. (they
look like them and the column is assigned to be hyperlink) But
clicking on them goes nowhere.

 

[Marcin]

I am on a project where I need the capability to locate a file through
MS Access such as a pdf and extract the file name into a designated
table. Is there a way that I can do this in a command button? PS. I
would like to be able to access any folder on my computer in a
directory view screen.
Thanks in advance.

===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================

 

[bgreenspan]

Back to the topic at hand... after that useless junk above...

I realized that my error was in how the hyperlink is hanndled.
#display-text#hyperlink-address#

Creating a string link that to store in the field produced the final
desired result. you can also add in the screen-tips, etc. separated
by hash signs #

I hope this helps,

- Bernie

 

[bgreenspan]

Fixed it and it works now...

I realized that my error was in how the hyperlink is hanndled.
#display-text#hyperlink-address#

Creating a string link that to store in the field produced the final
desired result. you can also add in the screen-tips, etc. separated
by hash signs #

I hope this helps,

- Bernie