Exporting Records to fieldname.txt

[B_Thomas]

I have a photo collection from years of the hobby that I had entered into an
uncomplicated Access table. The pictures are all identified by date taken
and description, with additional fields of subject, film, exposure, etc. I
never learned how to really use a database other than as a simple file
cabinet, and I have used filters and a query, but I would like to know if I
can print or export the picture records from each separate date as a file
with the date as the filename, without having to do it 2500 times? (I've been
at this for a while!). I would like to automate the query criteria as well.
Eventually, I hope to learn how to embed a preview of the pic in an
electronic portfolio. Any responses will help

 

[Dale Fye]

Cannot imagine why you would want 2500 separate txt files with dates on them?

1. Create a report that lists the info you want, to include the photos
date, set it to group by the PhotoDate field.

2. Next, create a form that allows you to select a date from a combo box
(use the control wizard to add this combo box).

3. Add a button to the form that allows you to view the report from Step #1
filtered by the date in the control on your form. If you use the control
wizard to add this command button, it should walk you through the process.

Now, you can see the report of the photos you took on a specific date
whenever you want, without cluttering up your hard drive with all of those
useless text files.

HTH
Dale