adding an extension with find/replace

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

Guest

Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with student
photos. I need to add the .jpg extension to all 2,510 of them, so I can use
a BLOB utility to embed the photos into the database. I have used the
find/replace feature to add the path: C:\Program Files\Datacard\ID
Works\Photos\0 (most of the ID numbers start with 0) but I can not figure
out how to add .jpg to the end of the ID number.
 
It would probably have been more appropriate to use an Update query to fix
the data in your table.

You could have set the path to "C:\Program Files\Datacard\ID Works\Photos\"
& [StudentID] & ".jpg"

If you've got the "C:\Program Files\Datacard\ID Works\Photos\" & [StudentID]
part in the field already, you should be able to add the ".jpg" to the end
now.
 
I see insert query but I do not see Update query. I tried using find/replace
with the path as you typed it but can not get it to work.
an example of the id number is 07657191
what i get replaced is C:\Program Files\Datacard\ID Works\Photos\ & [new
photos] & .jpg



Douglas J Steele said:
It would probably have been more appropriate to use an Update query to fix
the data in your table.

You could have set the path to "C:\Program Files\Datacard\ID Works\Photos\"
& [StudentID] & ".jpg"

If you've got the "C:\Program Files\Datacard\ID Works\Photos\" & [StudentID]
part in the field already, you should be able to add the ".jpg" to the end
now.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dowling-Douglas said:
Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with student
photos. I need to add the .jpg extension to all 2,510 of them, so I can use
a BLOB utility to embed the photos into the database. I have used the
find/replace feature to add the path: C:\Program Files\Datacard\ID
Works\Photos\0 (most of the ID numbers start with 0) but I can not figure
out how to add .jpg to the end of the ID number.
Click to expand...
Click to expand...
 
You can't use Find & Replace like that.

Where do you see Insert query, btw? In the Query builder, there's an Append
query and a Make Table query, but no Insert query. There is, however, an
Update query. (Look under the Query menu when the query's open in Design
mode)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dowling-Douglas said:
I see insert query but I do not see Update query. I tried using find/replace
with the path as you typed it but can not get it to work.
an example of the id number is 07657191
what i get replaced is C:\Program Files\Datacard\ID Works\Photos\ & [new
photos] & .jpg



Douglas J Steele said:
It would probably have been more appropriate to use an Update query to fix
the data in your table.

You could have set the path to "C:\Program Files\Datacard\ID Works\Photos\"
& [StudentID] & ".jpg"

If you've got the "C:\Program Files\Datacard\ID Works\Photos\" & [StudentID]
part in the field already, you should be able to add the ".jpg" to the end
now.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dowling-Douglas said:
Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with student
photos. I need to add the .jpg extension to all 2,510 of them, so I
Click to expand...
can
use
a BLOB utility to embed the photos into the database. I have used the
find/replace feature to add the path: C:\Program Files\Datacard\ID
Works\Photos\0 (most of the ID numbers start with 0) but I can not figure
out how to add .jpg to the end of the ID number.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top