VBA code in Access
VBA code in Access
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.
=> RE: VBA code in Access
Do you have an RRW.INI that contains the PROGDIR32= __so that RRWRUN.EXE can be found.__That may be what is missing.____Kathleen__R&R Support
==> VBA code in Access
Thanks. It works. But I have another problem since upgrading to Windows XP.____We also use Amyuni 2.07 printer drive in the code to concatenate files. It worked fine under Windows 98 with concatenation of ChartRunner charts(third party software for creating statistical graphs) with R&R reports. However, on Windows XP, every time when I run the same vba code to concatenate ChartRunner charts with R&R reports, I got the error message saying "File concatenation failed". I set the PDFDriver=0 in the rrw.ini file. How can I fix this problem? Thanks.__