By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,947 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

Access hyperlink needs to change when year does?

P: n/a
I have a link that is create on get lost focus from a field that (see
next line
G:\Call Center\APP\APP_2006\APP0001\APP000.tif

What I need to figure out is how can I get the '2006' to change with
every new year so this does not have to be recoded.

The reason why this needs to occur is the user has hundreds of scanned
files that are placed in the above directory

Please if you know how to code this please explain I am drastically
needing assistance.

Turf

Sep 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
strFilePath= "G:\Call Center\APP\APP_" & Year(Date) &
"\APP0001\APP000.tif

Sep 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.