Keeping track of files

[Viktor via AccessMonster.com]

Hi people, I have one very stupid question -

Is access abe to keep track of files with hyperlinks.

example:Table Files(tbFilesID, tbFilesFilename,....)

I want to create a function that will import files with their names and
create a link to the document.

So, later, when I look for something in the name and I find the file, I
should be able just to click the link and get the file.

Thanks,
Viktor

 

[Jeff Boyce]

If you store a hyperlink in a field in Access, AND if the file is still
named the same and in the same place, you should be able to click on the
hyperlink in the field (or in a control on an Access form) and open the
referred-to file.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Viktor via AccessMonster.com]

Thanks Jeff,

I did it and it works fine. Yet I'd like to create a form with "import
function" with "browse" button, which will take the wanted file, put it in a
certain folder, and create a link to that file. Is this possible in access
2003, or I should get my self in learning vb.net ?

Thanks,
Viktor

 

[Jeff Boyce]

Yes, Access can handle that, though you'll be using VBA/code to accomplish
it.

If you decide to migrate to vb.net, you will need to re-develop your
application from the ground up. Is there a reason Access is not working out
for you?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Viktor via AccessMonster.com]

Yes, there is one very serious reason access is not working out for me - I
still don't know how my way through access on a higher level . Your
answer is exactly what I was looking for - that it can be done in access
using VBA code. I'll try to do it and hopefully I'll succeed. One big thank
you for the answers and one more easy question - any links to sites with
sample vba code for access???

Thank you,
VIktor

 

[Jeff Boyce]

There are literally thousands (and probably more) of sites with sample
Access/VBA code. You might want to narrow your criteria <g>...

Try:
www.mvps.org/access
as one possible starting place.

Also check Jeff Conrad's site:
http://home.bendbroadband.com/conradsystems/

Regards

Jeff Boyce
Microsoft Office/Access MVP