Solved

current folder

Posted on 2013-12-09
2
125 Views
Last Modified: 2014-02-06
When I use CurrentProject.Path, I get something like this: C:\ABC\123

I just want to return 123.  How would I do this?  Thanks.
0
Comment
Question by:Sasha42
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39706512
Hi,

a = Mid(YourString, InStrRev(YourString, "\") + 1)

Open in new window


Regards
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39706514
s = CurrentProject.Path
msgbox mid(s, instrrev(s,"\") +1)

Open in new window

0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question