A
ArielZusya
I've got a form I use to keep track of documents used in a research project.
The form contains notes on the document (author, year, last reviewed, etc.)
and has a field with a hyperlink to the file and a field with a hyperlink to
the location on the web where the file was originally found. The directory
structure used for these documents is as follows:
..\ the root, containing the database and the folders containing the other
docs
..\[doc type]\ each doc type gets its own folder (ex: journal article,
book, etc.)
..\[doc type]\[author]\ each author gets his or her own folder
So, a journal article written by Professor Smith would be in:
..\journal\Smith\
the file naming convention is as follows:
[year] - [ref#] - [name].pdf
so if Professor Smith wrote his journal article in 2004 and called it "Notes
on something important" and had the reference number "123 JRS 221" the file
name would be:
2004 - 123 JRS 221 - Notes on something important.pdf
the link to the file would be:
#.\journal\Smith\2004 - 123 JRS 221 - Notes on something important.pdf#
and the link to the file online would be:
#http:\\www.somewebsite.com\search=123 JRS 221&lookup+Ref#
I'd like to find a way to look at the rest of the data entered on the form
which contains a field for author, type, year, ref number, and title, and
have it automatically populate the file and web link fields. I can figure
out how to create the concatenation statement and it works flawlessly if the
user is using 2007 but for some reason in 2003 and XP the user can't actually
click on the link created. What am I doing wrong? Your help will be greatly
appreciated. Thanks!
The form contains notes on the document (author, year, last reviewed, etc.)
and has a field with a hyperlink to the file and a field with a hyperlink to
the location on the web where the file was originally found. The directory
structure used for these documents is as follows:
..\ the root, containing the database and the folders containing the other
docs
..\[doc type]\ each doc type gets its own folder (ex: journal article,
book, etc.)
..\[doc type]\[author]\ each author gets his or her own folder
So, a journal article written by Professor Smith would be in:
..\journal\Smith\
the file naming convention is as follows:
[year] - [ref#] - [name].pdf
so if Professor Smith wrote his journal article in 2004 and called it "Notes
on something important" and had the reference number "123 JRS 221" the file
name would be:
2004 - 123 JRS 221 - Notes on something important.pdf
the link to the file would be:
#.\journal\Smith\2004 - 123 JRS 221 - Notes on something important.pdf#
and the link to the file online would be:
#http:\\www.somewebsite.com\search=123 JRS 221&lookup+Ref#
I'd like to find a way to look at the rest of the data entered on the form
which contains a field for author, type, year, ref number, and title, and
have it automatically populate the file and web link fields. I can figure
out how to create the concatenation statement and it works flawlessly if the
user is using 2007 but for some reason in 2003 and XP the user can't actually
click on the link created. What am I doing wrong? Your help will be greatly
appreciated. Thanks!