Hello, consider this database: Motorcycles.accdb which has a table tblMotorcycles with 4 fields:
MotorcycleID
MotorcycleBrand
MotorcycleModel
MotorcycleImage
The last field (MotorcycleImage) is an Attach type where images are attached.
Let's suppose the IDs from 1 to 100 contain Harley Davidson models, from 101 to 200 contain Honda models and from 201 to 300 contain Yamaha models. How do I attach 100 images at once?
Consider the images are located here:
C:\Documents and Settings\User\Desktop\Images\HarleyDavidson\
C:\Documents and Settings\User\Desktop\Images\Honda\
C:\Documents and Settings\User\Desktop\Images\Yamaha\
And they are numerically organized like this (in their respective folders):
HarleyDavidson0001.jpg
HarleyDavidson0002.jpg
HarleyDavidson0003.jpg
...
Honda0001.jpg
Honda0002.jpg
...
Yamaha0001.jpg
Yamaha0002.jpg
...
E.g.: From ID 101 to 200 attach all images from Honda0001.jpg to Honda0100.jpg, in the MotorcycleImage field, from their respective folder.
In other words, how do I attach from a certain range a certain amount of files, always considering that the files attached are in sequence. And how do I remove images from a certain range (e.g.: remove all images from IDs 150 to 200)?
Could you understand or you need more additional information?
Thanks!