General discussion

Locked

Access: get the filename

By andrewafresh ·
Hi, is there a way to pass the filename of an Access application to a variable using VBA? perhaps by inspecting a property of the

Thank you
Andrew

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

CurrentProject

by onbliss In reply to Access: get the filename

...can be used to access different properties and methods pertaining to the Access application.

So in your VBA code, you could use something like filename = CurrentProject.Name to access the name. There should be properties for path, fullname etc.

Related Discussions

Related Forums