N/APosted on - 03/06/2012
I am trying to create Access Database, which uses VBA buttons to open a specific form in Lotus Form Viewer. I can readily access the form viewer but I can’t seem to actually view the form.
Is there another way I can view the form through Microsoft Access VBA?
Can I access the Lotus Form through Microsoft Access VBA?
The Shell command may not work as this should just open the file as if download at ftp://. In order to solve this issue, you need to use a macro as shown below available in a link at software topic. Just download the macros and incorporate them in VBA code.
The problem can be solved using macros. Some macros are already built and available at http://msdn.microsoft.com/en-us/library/office/aa220276(v=office.11).aspx
The problem is based on bugs in the current version. In fact, it should be solved in the upcoming versions. The main problem is with setting up the settings for Lotus forms. Try the Macro.