populating a collection

New application from scratch: Prototyping will be in MS Access later ported to sql server....or something else.
1) I need to load a series of files into a collection.  e.g.  folder name "Photos" > 1.jpg, 2.jpg, 3.jpg, 4.jpg
 1.1) A thumbnail of the photo will display as we move thru the collection, next button if you will.
  1.2) duplicate file names may exist so if duplicates = true, append file name before adding to collection
2) I need to retrieve a subset of these files,  user defined,   e.g.  2.jpg and 4.jpg  and place them into a target directory.
   2.1 when 2.jpg is chosen from the list, display thumbnail, command button control, then to write the file to the target directory.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


While everything you've described can certainly be done, and done well by Access, virtually none of it will port to another environment.  SQL Server stores data.  MS Access code and forms do not port to other environments (Like VB.Net, Java, PHP etc.)  So other than the business logic, which you've described already, the rest of your efforts in Access will be thrown away.

Do you still want to proceed?
brianpowellAuthor Commented:
SQL Server stores data  = will eventually store the pics and not in some folder... then a stored procedure will be used..... for now all the pics are in a designated 'Main' folder.

brianpowellAuthor Commented:
MS Access is to be the UI.  bp.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

brianpowellAuthor Commented:
1.2) duplicate file names may exist so if duplicates = true,  the thinking here is when the insert into the collection errors, "duplicates not allowed", do a rename, then insert.
1. The windows file system does not allow duplicate file names so I'm not sure how you would get any unless you are processing multiple directories at one time and in that case, I would always include the full path in the file name.

2. You don't have to create a new collection.  What you want to do can be done by manipulating the FSO (which is itself a collection) directly.  You'll need to set a reference to the Windows Scripting Library.

3. It is not clear how you are going to create an interface.  Will you be using a single record form?  If you are expecting to use a continuous or ds form, the simplest thing would be to load the data from FSO into a table and bind the table/query to the form.
brianpowellAuthor Commented:
"The windows file system does not allow duplicate file names" = good point.  I have multiple users creating....and dups will happen but yes different directories. so multiple directories will need to be loaded.
brianpowellAuthor Commented:
The collection idea stems from holding and passing it.

Interface: Subform displays the pic and the controls are on the main form.... move next, previous, delete, ect....
As @PatHartman has said, the weapon of choice here is the FileSystemObject which requires a reference to the Windows Script Host Object Model
I'd use the FileDialog object that comes from the Microsoft Office xx.0 to set the opening directory, or change directories in stream

I would stick with storing files in the file system and not in databases.
There can be worlds of hurt in that approach.

display thumbnail

That my son, can be done, but it takes some doing.
YOU have to generate the thumbnails dynamically.
WIA can get that done.
As @PatHartman has noted, you can pound a directory listing into a 'temptable' and get after things.

You really may want to take a look at my articles
There are a bunch that are really relevant to what you want to do.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Did you mean to give all the points to Nick?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.