Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / March 2005

Tip: Looking for answers? Try searching our database.

open access VBA shell command without Netmeeting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TonyBongiovi - 29 Mar 2005 21:01 GMT
I want to open another instance of Access from VBA code in a running instance
of Acccess, and I can do that, but how do I prevent Netmeeting from
automatically running and asking the user for their Name, email address,
password etc. and Then running Netmeeting?

The Code I'm running:

stAppName = "C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE
/C:\CCDataShopNoticeGeneration\AccessData\AutoInstall.mdb "
   Call Shell(stAppName, 1)

Are there comand line switches that will prevent Netmeeting from running?
When I open this database manually Netmeeting does not execute. It only runs
from the VBA command above. I have to prevent it. I don't want Netmeeting to
run at all. It will prevent what I'm trying to do!

Thanks :))
Graham Mandeno - 29 Mar 2005 22:03 GMT
Hi Tony

I have no idea why NetMeeting is running, but the problem with your command
line is that there are spaces in the filename but you have not enclosed it
in quotes.  Try this:

   stAppName = """C:\Program Files\Microsoft Office
2000\Office\MSACCESS.EXE"" " _
       & """C:\CCDataShopNoticeGeneration\AccessData\AutoInstall.mdb"""

Note that two adjacent double-quotes in a VBA string is interpreted as an
embedded double-quote.
Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

>I want to open another instance of Access from VBA code in a running
>instance
[quoted text clipped - 16 lines]
>
> Thanks :))
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.