Automatically inserting part of a file name into another field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing a list of file names and wish to insert into another field the
file name without the file extension.

Example: tblPhotos has two fields: PicID (key) and PicName

file name 540987.jpg is imported into the field PicID
I would like to automatically populate the field PicName with the 540987 so
that it can be related to a key field in another table.

Thanks in advance for you help......
 
Thanks, that did just what i wanted it to.....that will teach me to get rid
of programming books!

Wendy
 
Back
Top