Opening another Program Code

[cjman]

This code opens the zebra program, I choose the label to print and close the zebra program the error "STY SQL FE can't find the module '0.' " is visible. What is wrong with this code. I run the module from a button. DoCmd.OpenModule (OpenZebraProgram.OpenZebraProgram)
Use Access 2007 FE, Sql Server 2005 Backend.

Function OpenZebraProgram() As Boolean
Dim strProgramName As String
strProgramName = "C:\Program Files\ZebraDesigner Pro\Bin\Design.exe"
Call Shell(strProgramName, vbNormalFocus)
End Function

 

[HiTechCoach]

First do not name the module the same as the function inside it. It will cause use only headaches. I would rename the module.

To call the function in your code I would use:

Call OpenZebraProgram

 

[cjman]

Thanks, HiTechCoach. I changed the module name and call it from the button like you said and it works great.