[?] pass parameters to Access 97

With:
Set oApp = CreateObject("Access.Application.8")
oApp.Visible = True
oApp.RunCommand MaximizeApplication
oApp.OpenCurrentDatabase "c:\temp\db1.mdb "
oApp.UserControl = True

I can open a db1 mdb, but how I can pass a parameter to mdb???
if I open a db from command line I can use:
"msacces db1.mdb /cmd parameter1"
but in vbs????


Thanks and excuse me form my english


--
Pennywise
Questo messaggio è composto al 100% da
elettroni riciclati. Nessun atomo è stato
ionizzato per trasmettere questo messaggio.

name
Wed Feb 11 03:18:10 CST 2004

Your are basically GUI the exe.

==

Get familiar with programmation

or automation.


---------------

While you can catch or kick a ball.

Learn how to make one.







"Pennywise" <pennywisezxc@ccvvdd.it> wrote in message
news:Xns948C628F9F032pennywisekyahooit@127.0.0.1...
> With:
> Set oApp = CreateObject("Access.Application.8")
> oApp.Visible = True
> oApp.RunCommand MaximizeApplication
> oApp.OpenCurrentDatabase "c:\temp\db1.mdb "
> oApp.UserControl = True
>
> I can open a db1 mdb, but how I can pass a parameter to mdb???
> if I open a db from command line I can use:
> "msacces db1.mdb /cmd parameter1"
> but in vbs????
>
>
> Thanks and excuse me form my english
>
>
> --
> Pennywise
> Questo messaggio è composto al 100% da
> elettroni riciclati. Nessun atomo è stato
> ionizzato per trasmettere questo messaggio.

Pennywise
Wed Feb 11 04:52:21 CST 2004

"name" <nospam@user.com> wrote in news:u3Ro4$H8DHA.2412
@TK2MSFTNGP09.phx.gbl:

> Your are basically GUI the exe.
>
> ==
>
> Get familiar with programmation
>
> or automation.

Thereshold??

[cut]

Bob
Wed Feb 11 06:33:51 CST 2004

Pennywise wrote:
> With:
> Set oApp = CreateObject("Access.Application.8")
> oApp.Visible = True
> oApp.RunCommand MaximizeApplication
> oApp.OpenCurrentDatabase "c:\temp\db1.mdb "
> oApp.UserControl = True
>
> I can open a db1 mdb, but how I can pass a parameter to mdb???
> if I open a db from command line I can use:
> "msacces db1.mdb /cmd parameter1"
> but in vbs????
>
>
> Thanks and excuse me form my english

Are you doing this from ASP (or any server-side technology)? If so, see
this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;257757

Otherwise, you need to go to Access online help and look up the section
about Automation. IIRC, you need to use DoCmd to run whatever procedure in
your database requires the parameter.

Bob Barrows


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Bob
Wed Feb 11 06:35:07 CST 2004

Pennywise wrote:
> "name" <nospam@user.com> wrote in news:u3Ro4$H8DHA.2412
> @TK2MSFTNGP09.phx.gbl:
>
>> Your are basically GUI the exe.
>>
>> ==
>>
>> Get familiar with programmation
>>
>> or automation.
>
> Thereshold??
>
> [cut]

Just ignore these messages from "name". Nobody can understand them so you're
not alone.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"