If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding an extension with find/replace
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. |
#2
|
|||
|
|||
adding an extension with find/replace
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 http://I.Am/DougSteele (no e-mails, please!) "Dowling-Douglas" wrote in message ... 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. |
#3
|
|||
|
|||
adding an extension with find/replace
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" wrote: 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 http://I.Am/DougSteele (no e-mails, please!) "Dowling-Douglas" wrote in message ... 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. |
#4
|
|||
|
|||
adding an extension with find/replace
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 http://I.Am/DougSteele (no e-mails, please!) "Dowling-Douglas" wrote in message ... 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" wrote: 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 http://I.Am/DougSteele (no e-mails, please!) "Dowling-Douglas" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word XP saving RTF with doc extension | BobW | General Discussions | 5 | January 23rd, 2006 09:29 AM |
automatically updating textbox and adding it to tables | Stevenator2006 | General Discussion | 1 | January 11th, 2006 08:01 AM |
find/replace box should not move | cwmacminn | General Discussion | 10 | December 21st, 2005 03:55 AM |
Unsafe Attachments | Ron | Installation & Setup | 2 | June 9th, 2004 01:55 AM |
find/replace | Todd | Worksheet Functions | 2 | September 25th, 2003 06:50 PM |