Hi and a hope of help over listing file names in Access

[RichardP1978]

Hi, newbie here to this forum, been looking about for ages to try and find an access based forum.

I am not a great coder, have not really done it, nor remotely understand it, but I have still managed to write a database in access for the office.

We run a residential care home, where we had 5 databases (MS Works) which held different information of the residents within the home but duplicated name, dob, etc. I have successfully writen a access database which works well. But now I want to start pushing it a degree further if I can.

We took delivery of a HP officejet all in one printer, and it has a scanner with document feeder which we scan letters in so we can share them with head office, but what I would really like to do, is scan letters in relating to a specific client, and be able to save the file name as a link, so an other user on an other PC can open the document on their PC. Basically, I want to avoid us going to the filing cabinet to refer to a letter which was written to us.

I am using XP Home, with Office 2003 Pro, and Acrobat 8 Pro.

Any ideas where to even start looking?? I did do a search, but have no idea how to start.

Thanks in advance.

 

[KeithG]

I would just scan the letter save to you shared folder then create a hyperlink field and enter the location.

 

[RichardP1978]

So a hyperlink would work on a 'local' file name? I thought they would only work on the web.

Cheers!

 

[Oldsoftboss]

Does this help