Here's a doozy of a situation. I am working on an Access database of hospital patients that needs to export each record as a separate Text file so it can then be imported into a different system accessed hospital-wide. Sadly, the other system requires that it be individual files per record.
I have all the specs for the text file worked out, and the export specification, but having difficulty with the next step.
What I am trying to do is set up a VBA routine for each file to be named at the time of generation automatically via a timestamp and some unique identifier, either an autonumber or some combination of characters that will keep the files unique in the event that the export be run again (which will happen, and need to be addressed as separate entities).
Anyone have any suggestions?
Thanks in advance!