[AccessD] Relative reference?

Thank you Michael, I will try that.
Tina

Michael R Mattys wrote:
> Tina,
>
> I think it's CurrentProject.Path
>
> Michael R. Mattys
> MapPoint & Access Dev
> www.mattysconsulting.com
>
> ----- Original Message ----- 
> From: "Tina Norris Fields" <tinanfields at torchlake.com>
> To: <accessd at databaseadvisors.com>
> Sent: Monday, June 30, 2008 7:50 AM
> Subject: [AccessD] Relative reference?
>
>
>   
>> Hi All,
>>
>> Can I use relative reference to point to a file from within Access.  In 
>> other words, if the database and the Word document are in the same 
>> directory (in this case "TinaVersions"), can I use
>> ".\TinaDonationTestLtr2.doc" instead of the complete pathname 
>> "C:\Documents and Settings\Tina\My 
>> Documents\TP\TP_Clients\Habitat\TinaVersions\TinaDonationTestLtr2.doc" 
>> in my Sub?
>>
>> I would very much like to be able to use relative rather than absolute 
>> reference if that is "do-able."
>>
>> Thanks
>> Tina
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>