Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling an Oracle Application with an Access command button

Status
Not open for further replies.

pleasehelpalot

Instructor
Oct 4, 2005
92
0
0
US
I hace an Access application with a command button that I want to open an Oracle application. This is the 'on click' event code I'm trying but it can't find the fmx file.

On Error GoTo Err_CommandLP_Click

Dim stAppName As String

stAppName = "C:\dev6i\BIN\ifrun60.EXE C:\PTS\FCOM0010.fmx lapspur/lapspur@personE"
Call Shell(stAppName, 1)

Exit_CommandLP_Click:
Exit Sub

Err_CommandLP_Click:
MsgBox Err.Description
Resume Exit_CommandLP_Click

I'm out of my league with this so I'd appreciate any help help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top