Information générale
Catégorie:
Codage, syntaxe et commandes
>Hello!
>
>I am looking for a way to run Access from VFP. Here's the situation in a nutshell:
>
>I have a VFP app minimized to the system tray doing several things, one of which will (hopefully) be to fire up an Access application which performs an import without user intervention, then quits on its own. I just have to run Access and pass it a few parameters and away it goes.
>
>From the Start->Run menu, it works great, but I cannot find a way to get it to work from VFP without the DOS shell. Using the RUN or ! command does not handle the parameters correctly that I pass.
>
>Anybody out there do something similar that can help me out?
>
>JL Miller
>Logikos, Inc.
>"Desperate In Houston"
You may create a macro that does the import and invoke Access as a server like so:
oAcc=CreateObject("Access.Application")
oAcc.DoCmd.RunMacro("ImportMacro")
Also, you can execute several other methods from the application object to accomplish the same task. But a macros may be the quick way to do it.HTH
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement