<div>
You can use the shell command to open an application while in Access. &nbsp;See VBA Help (Ctl-G or Alt-F11) and enter Shell Function in the Answer Wizard for details.
</div>


You can use the shell command to open an application while in Access.  See VBA Help (Ctl-G or Alt-F11) and enter Shell Function in the Answer Wizard for details.

<div>
Maybe an invisible textbox on the form containing the Access developed filename and path and a command button when clicked to activate the shell command?
</div>


Maybe an invisible textbox on the form containing the Access developed filename and path and a command button when clicked to activate the shell command?

<div>
I copied the example from Shell help and modified:<br />
<br />
Public Function testopenOneNote()<br />
Dim RetVal<br />
RetVal = Shell(&quot;C:\testfolder\Misce<wbr />llaneous.o<wbr />ne&quot;, 1)<br />
End Function<br />
<br />
Then I did a RunCode in a macro and got this error:<br />
Runtime error '5' Invalid procedure call or argument<br />
I also called it from a command button in a form and got the same result.
</div>


I copied the example from Shell help and modified:

Public Function testopenOneNote()
Dim RetVal
RetVal = Shell("C:\testfolder\Miscellaneous.one", 1)
End Function

Then I did a RunCode in a macro and got this error:
Runtime error '5' Invalid procedure call or argument
I also called it from a command button in a form and got the same result.

<div>
Works great....wish I'd known about 'shell' a few years back...thanks.
</div>


Works great....wish I'd known about 'shell' a few years back...thanks.

<div>
Didn't I give you the answer?
</div>


<div>
I goofed....I didn't even look up...thought they were all from you.
</div>


I goofed....I didn't even look up...thought they were all from you.

<div>
<div class="content wysiwyg-content">
I'm in design phase for a client who wants to use tablet pcs....with OneNote keeping client interview info. &nbsp;While in an Access form can I open OneNote to notes kept for a particular client if I'm able to develop the filename in Access? &nbsp;How?
</div>
</div>


I'm in design phase for a client who wants to use tablet pcs....with OneNote keeping client interview info.  While in an Access form can I open OneNote to notes kept for a particular client if I'm able to develop the filename in Access?  How?

Open a OneNote 'file' while in Access?

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.

Microsoft Access

Microsoft OneNote is a computer program for free-form information gathering and multi-user collaboration. It gathers users' notes (handwritten or typed), drawings, screen clippings, and audio commentaries into one program.