[AccessD] opening a specific file via double click...

Kostas Konstantinidis kost36 at otenet.gr
Wed Oct 25 02:46:31 CDT 2006


dear group for one more time i need your help
I have a text field in which the stored data are just names of files
(e.g. aaa.pdf)
Is that possible by double click on the specific field to load the file
with the same name as well?

thank's a lot
/kostas


----- Original Message ----- 
From: <paul.hartland at fsmail.net>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, October 24, 2006 5:06 PM
Subject: Re: [AccessD] A2003:Rename a file in a folder


> Darren,
>
> Off the tope of my head use the following:
>
> Dim strFile As String
>
> strFile = Dir(myCoolCSVfile.csv, vbHidden) ' Put the full path before the 
> filename
> If (strFile<>"" ) then
>     Name myCoolCSVfile.csv As YYMMDDHHMMSS.csv    ' Put the full path 
> before the filename and new file name
> Endif
>
> ' Your routine to put the new file into C:\MyCoolFolder
>
> Paul Hartland
>
>
>
> Message Received: Oct 24 2006, 02:58 PM
> From: "Darren DICK"
> To: "'Access Developers discussion and problem solving'"
> Cc:
> Subject: [AccessD] A2003:Rename a file in a folder
>
> Hi all
>
> I have a file that will be always named the same - EG myCoolCSVfile.csv
>
> It will be dumped into a folder...say C:\MyCoolFolder at random times
>
> I need some code to Check the C:\myCoolFolder to see if the file
> myCoolCSVfile.csv file exists in the folder - and if it does to rename it 
> to
> YYMMDDHHMMSS.csv
>
> Where YY = Year MM = Month DD = Day etc etc
>
> Does anyone have anything that might suit?
>
> Many thanks in advance
>
> Darren
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
> Paul Hartland
> paul.hartland at fsmail.net
> 07730 523179
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> 





More information about the AccessD mailing list