Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determining Filepath

Status
Not open for further replies.
bulletproof1979

bulletproof1979

Programmer
Jan 15, 2003
1
GB
I'm fairly new to VBA coding so this is probably a very straightforward one, but does anyone know how to get a database display the location it is currently running from?
 
Sort by date Sort by votes
Ok... the following line will give you the entire path (including the filename) of the database that you are running:

currentdb.name

Then, you can parse out the filename, and you ahve the folder (directory) that the database is in.

GComyn
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

RMcCallan
  • Locked
  • Question
Saving attachment location to Access table - filepath object?
Replies
2
Views
65
vbajock
vbajock
dawnd3
  • Locked
  • Question
determining whether or not to open a report 1
Replies
4
Views
48
PHV
PHV
derekstewart
  • Locked
  • Question
Determining Expected Date
Replies
8
Views
62
derekstewart
derekstewart
homeguard
  • Locked
  • Question
Determining the day of the week from a date.
Replies
2
Views
25
homeguard
homeguard
mmorancbt
  • Locked
  • Question
Multiselect listbox - determining item just selected or deselected
Replies
2
Views
28
mmorancbt
mmorancbt

Part and Inventory Search

Sponsor

Back
Top