Hi,
In previous versions of Access I used RunApp from the drop down list of
macro options on the macros builder form.
In Office 2007 it seems to be missing although the docs imply it's there.
As it isn't for me I'm assuming that's because it's filtered out by nanny
Access 2007 as 'unsafe'.
I've made the database location a 'trusted' folder, clicked the nanny bar to
enable unsafe macros, tried running the database off a local drive and
RunApp is never there.
So, my question is, ideally running the Access database from a network
drive, how do I enable RunApp? That is, make it visible in the drop down
list of macro options on the macro building screen? Once it's visisible
there, I'm assuming it will work without further messing!
Thanks!
Pete
Jeff Conrad [MSFT] - 26 Feb 2008 19:04 GMT
See this FAQ page on my site Peter:
http://accessjunkie.com/faq_02.aspx

Signature
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
> Hi,
>
[quoted text clipped - 13 lines]
> list of macro options on the macro building screen? Once it's visisible
> there, I'm assuming it will work without further messing!
Peter Boulton - 26 Feb 2008 19:20 GMT
> See this FAQ page on my site Peter:
> http://accessjunkie.com/faq_02.aspx
[quoted text clipped - 5 lines]
>>
>> In Office 2007 it seems to be missing
Thanks Jeff! Found it!
Your site looks very interesting - I have bookmarked it to come back to when
I have more time.
Cheers,
Pete
Jeff Conrad [MSFT] - 27 Feb 2008 02:45 GMT
You're welcome, glad my site was helpful.
Good luck with your project.

Signature
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
> Thanks Jeff! Found it!
>
> Your site looks very interesting - I have bookmarked it to come back to when I have more time.