p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

vba_access thread: RE: Get File & Path Name of Front End of database


Message #1 by "John Anthony" <janthony@s...> on Sun, 1 Jul 2001 08:30:36 -0500
John,

Thanks so much, this worked perfectly and really saved me a lot of trouble.

I really appreciate it.

John 

-----Original Message-----
From: John Ruff [mailto:John_Ruff@m...]
Sent: Friday, June 29, 2001 2:01 PM
To: VBA_Access
Subject: [vba_access] RE: Get File & Path Name of Front End of database
Importance: Low


To get just the path do this:

Dim i As Long
Dim strPath As String
    
For i = Len(CurrentDb.Name) To 1 Step -1
    If Mid(CurrentDb.Name, i, 1) = "\" Then
        strPath = Left(CurrentDb.Name, i - 1)
        Exit For
    End If
Next I

John Ruff - The Eternal Optimist :)


-----Original Message-----
From:	John Anthony [mailto:janthony@s...]
Sent:	Friday, June 29, 2001 12:10 AM
To:	VBA_Access
Subject:	[vba_access] Get File & Path Name of Front End of database

Is there anyway via VBA that I can get the file & path of the "front end" 
of my database?





  Return to Index