Re: Retrieve most recent file
From: solex (solex_at_nowhere.com)
Date: 05/20/04
- Next message: Tom Glasser: "Password for Links to SQL Database"
- Previous message: Daniel P: "Re: Hyperlink for Roger Carlson or anyone else who might help"
- In reply to: Daniel P: "Retrieve most recent file"
- Next in thread: Elwin: "Retrieve most recent file"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 May 2004 16:58:47 -0400
You could do a number of things. All of which relate to using the Dir()
command to (1) loop through and parse the version number out so you can
compare it to the other versions or (2) check the file date persumably the
file with the latest date will also be the most recent version (an
assumption on my part)
Regards,
Dan
"Daniel P" <anonymous@discussions.microsoft.com> wrote in message
news:4246C6BA-64BF-4B91-9B01-D117DA1A7063@microsoft.com...
> Hello,
>
> I currently use the following line of code to identify a specific file to
be able to back it up automatically:
>
> SourceFile = "\\Pointeclaire\Public\CAMTA Database\BackEnd\CAMTA_be V02
R06.mdb"
>
> However, as you can see there have been and are go to be many revision to
the database file in question. How can I code it so that I no longer am
required to keep changing the source file manually? What coding will
retrieve the file "...\CAMTA_be Vxx Ryy.mdb" where xx and yy would be the
greatest values that the computer can identify in the directory in question?
>
> Thanking you in advance for your help,
>
> Daniel
- Next message: Tom Glasser: "Password for Links to SQL Database"
- Previous message: Daniel P: "Re: Hyperlink for Roger Carlson or anyone else who might help"
- In reply to: Daniel P: "Retrieve most recent file"
- Next in thread: Elwin: "Retrieve most recent file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
