many software in access

iraidotel@yahoo.com

Registered User.
Local time
, 06:44
Joined
Dec 17, 2014
Messages
36
dear all
I want to create a database that can open other programs
Her eg excel, word etc.
The program can be active and can be used
as an illustrative example I

thereby
please enlighten her

greetings, ira
 

Attachments

Look into the "Shell Function" https://msdn.microsoft.com/en-us/library/xe736fyk(v=vs.90).aspx

This example opens the calculator.

Code:
[COLOR=blue]Dim[/COLOR] procID [COLOR=blue]As[/COLOR] [COLOR=blue]Integer[/COLOR] 
[COLOR=green]' Run calculator.[/COLOR]
procID = Shell([COLOR=#a31515]"C:\Windows\system32\calc.exe"[/COLOR], AppWinStyle.NormalFocus)
[COLOR=green]' The preceding path is for Windows XP. [/COLOR]
[COLOR=green]' The Windows 2000 path is C:\WINNT\system32\calc.exe.[/COLOR]
 
dear all
I want to create a database that can open other programs
Her eg excel, word etc.
The program can be active and can be used
as an illustrative example I

thereby
please enlighten her

greetings, ira

Your example was not opening Excel. I have Excel embedded into a form.


Are you wanting to launch the other program or use it as an OLE server embedded into a form?
 
There are many ways to approach this problem. The correct answer depends on whether you were planning to open the external application on a specific file and then when the user is done, do something with the file just created/modified.

If you are just opening a utility for the sake of opening a utility on an arbitrary file, the Shell method described above is correct.

If you are planning to run the utility on a file that you need to process later via Access, you might have to look into Application objects. Doing so would require VBA programming and a bit more planning.

Please clarify your intent a bit more.
 

Users who are viewing this thread

Back
Top Bottom