Getting Access filename only in 97

  • Thread starter Thread starter MarkCapo
  • Start date Start date
M

MarkCapo

Using Access XP you call the currentproject method and
pick up its name property to return the filename of the
current application file. I need to to a similar
function in 97 which only picks up the filename directly
rather than using a procedure that loops through the path
and filename to pick out filename from the
application.name result.

Can anybody help with this!

Thanks

mark
 
You can go:

Dim strFName As String

strFName = Dir(CurrentDb.Name)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import File Information 0
TransferText with last month's Date in filename 2
Need to grab Path and Filename to run Import txt file process... 19
Openning an Excel File in Access 2
Importing multiple CSV files and adding the filename as a field 4
Access 2003 - Create PDF batch filenames from Access report 2
Manipulating filenames to be stored in an Access table 2
Button on Form to refresh hyperlink data in table - error 1004 & 3 1

Back
Top