Command Button

[Zorro]

does anyone know how to open other application through vb
i.e:
i create a form and at the form there is a command button.
when i click the button, a file from ms access application will open.

does anyone know how to do it?
or a sample?

[Ali Rizwan]

does anyone know how to open other application through vb
i.e:
i create a form and at the form there is a command button.
when i click the button, a file from ms access application will open.

does anyone know how to do it?
or a sample?

Hello
Try this one

ShellExec("C:\testfile.doc")

[QVeen72]

Hi,

There are 2 ways to do it.. Create MSAccess Object and call the Form..

Another way is, Shell the Application

In ur MDB File, Create a Macro and Write Action for "OpenForm" and call the Form Name. Save the Macro say "Macro1"
and in VB6 write this code:

    Dim RetVal
    RetVal = Shell("C:\\Program Files\Microsoft Office\OFFICE\MSACCESS.EXE  c:\\MyDB.mdb /x Macro1", vbMaximizedFocus)
 

Regards
Veena