VBA code in Access
Posted: Wed Jul 02, 2003 2:11 pm
We are using R&R 10.0.013 with Server/Workstation installation.____We have an Access database with vba code to run R&R reports. It was working on Windows 98 workstation. However, it will not work on Windows XP or 2000. In the code we declare the function using __Declare Function execRuntime Lib "rrrpt32.dll" (ByVal hReport As Long, ByVal bWait As Long, ByVal fsCmdShow As Long, lpCode As Long, lpPageCount As Long, ByVal emsg As String, ByVal emsgsize As Long) As Long____But when execute the program, nothing happens. If I installed the full version of R&R on my XP workstation, the vba code works. However, we don^t want to install thr full version of R&R on workstations. We want to use Server/Workstation installation. ____Is there anything we need to do to fix this problem? Thanks.