Changing ID number attached to a Picture??

[mrod0442]

Hello Newbie here, so I have this program that we use for ID pictures. Through the program we have the persons info and assigned ID number, when we import an image to his profile the program changes the name of the actual image to his ID number. In the program itself there is an button to change the ID number very easily, individually. My question is how can I change the ID numbers for 1600 people through the ACCESS, since it is an ACCESS program. When I change the number in the subjects table it shows the change when I open the Program but the image no longer shows up because the ID number is different. Any help would be appreciated and I have ACCESS 2013. Thank you.

[Dal Jeanis]

Basically, you will take a junk version of the database, find the code behind that button that does your desired act once, and then you will run that code in a loop to do it 1600 times.

You will test your code in the junk version of the database and will not run it in the real database until you have absolutely verified that it works exactly as desired.

You will probably have a file or table somewhere of the from- and to- ID numbers, and you will probably use a cursor to read that file/table as a recordset, in essence using VBA to pretend that someone is clicking the button once for each record.

You will test the process with a file containing, for example, three records. If that works, you will test it for a dozen more. If that works, then you can run your 1600 (minus the ones that are already done).

[June7]

You import the image into some program, not Access?
That other program uses Access for a database?
You have a link in another Access db to table in the other program?
You change the ID in that linked table?
The image then does not show in that other program?
There must be another table storing the images.
I don't think you should change that ID.
It is apparently being used as a PK/FK link between tables in that other program.
If you must change the ID, then will have to change in all tables that use the ID.
Changing PK/FK values is tricky.

[Dal Jeanis]

June - I was under the impression that it was just the name of the image file, on the network, that was being changed to the new ID. Apparently they have assigned a lot of people new IDs, and need to go "find" their prior pictures and get them renamed.

mrod0442 - try this first - find out where on the network these images are stored, and manually rename one to the new name. If the prior empID was AB1234 and the prior image file was AB1234.jpg, and the new empid is CD5678, then rename the image file to CD5678.jpg. then check to see whether the picture is now available.

If that works, then all you need is to rename the files using VBA.
Here's the minimum code to rename files on a windows OS LAN using MS Access VBA as the driver.

 Dim FSObj AS Object
 Dim strFromName AS string
 Dim strToName AS String

' create a FS object
   Set FSObj = CreateObject("Scripting.FileSystemObject")

'iteratively set the from/to names and rename the file
   strFromName = "C:\PutThe\FileName\Here\FROMFILE.JPG"   
   strFromName= "C:\PutThe\FileName\Here\TOFILE.JPG"   
   FSObj.MoveFile strFromName, strToName

' explicitly destroy what you have created
  Set FSObj = Nothing

[June7]

Okay, so they probably aren't 'importing' the image, just the file location path. Whatever changes they make, better be done carefully.

Does the stored path include the filename or just up to the target folder?

[Dal Jeanis]

My assumption from the initial description is that the import function imports a file from some device and saves it in "the usual place", and the button to change the employeeID executes code to change the name of the file in that same place.

[mrod0442]

The database contains student information, where would I find in Access the action or code that controls the button to "CHANGE ID". A MILLION THANKS to all for your help and input. Also the data is imported first into the program, then we take a picture and save it to a folder, once we import the picture to a specific student the program renames the Image to the Student ID number. If I change the ID number in the Access table, the image disappears from the View window because it has the original ID number.

Hello Newbie here, so I have this program that we use for ID pictures. Through the program we have the persons info and assigned ID number, when we import an image to his profile the program changes the name of the actual image to his ID number. In the program itself there is an button to change the ID number very easily, individually. My question is how can I change the ID numbers for 1600 people through the ACCESS, since it is an ACCESS program. When I change the number in the subjects table it shows the change when I open the Program but the image no longer shows up because the ID number is different. Any help would be appreciated and I have ACCESS 2013. Thank you.

[June7]

Is that 'program' an Access database with file extension of mdb or accdb? If it's mdb/accdb you should be able to do design edits and that includes modify code. If it is an mde/accde you cannot do design edits.

If design tools do not show on ribbon, open the 'program' with shift key held down. This bypasses any automatic code and exposes the full ribbon and navigation pane. Find the form in navigation pane, open it in Design view. Click on the Change ID button. On the Property Sheet, look for the Click event, click the ellipses (...) next to the event. This will open the VBA editor in the Click event procedure. Edit code as needed.

[mrod0442]

The file is an mdb file and I will try everything you just mentioned, thanks so much. I will post my results soon, thanks.

[June7]

Sorry, I should have mentioned if the code is VBA, the event property will likely show [Event Procedure]. If it's a macro it could show [Embedded Macro] or it could be calling a VBA function or possibly a general macro. I don't use macros.