<div>
LSM...: it works! (why am I not surprised...)<br />
<br />
Fyed: very comprehensive and will remain in my list of &quot;useful things to know about&quot; but for the moment, I will use LSM...'s simpler solution.<br />
<br />
peter
</div>


LSM...: it works! (why am I not surprised...)

Fyed: very comprehensive and will remain in my list of "useful things to know about" but for the moment, I will use LSM...'s simpler solution.

peter

<div>
<div class="content wysiwyg-content">
Like it says in the title, I need to find a file on the desktop of the User that has my app open. I have code to look for file in a folder already - but where do I make it look at that desktop folder for the current User? Is there an easy way?<br />
<br />
many thanks.
</div>
</div>


Like it says in the title, I need to find a file on the desktop of the User that has my app open. I have code to look for file in a folder already - but where do I make it look at that desktop folder for the current User? Is there an easy way?

many thanks.

Finding the desktop folder of the current User in Access 2007 VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.