adding an extension with find/replace

[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.

 

[Douglas J Steele]

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.

 

[Guest]

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

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!)

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.

 

[Douglas J Steele]

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!)

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

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!)

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.