Hello again!
I am trying to open another database from a database on the on click event.
I have tried the following vb:-
Private Sub Command8_Click()
Dim RetVal
'Run new database
RetVal = Shell("S:\FINANCE\RISK\DATABASE\AVIATION.mdb", 1)
End Sub
However, this returns the runtime error 5 message / invalid call procedure.
Is this because I am trying to open an mdb with the shell function rather than an exe?
If so, does anyone know how to open another database from a command btn?
Thanks a lot,
Kirsty.
I am trying to open another database from a database on the on click event.
I have tried the following vb:-
Private Sub Command8_Click()
Dim RetVal
'Run new database
RetVal = Shell("S:\FINANCE\RISK\DATABASE\AVIATION.mdb", 1)
End Sub
However, this returns the runtime error 5 message / invalid call procedure.
Is this because I am trying to open an mdb with the shell function rather than an exe?
If so, does anyone know how to open another database from a command btn?
Thanks a lot,
Kirsty.