Can I access the Lotus Form through Microsoft Access VBA?

Asked By evonros 0 points N/A Posted on - 03/06/2012

Hello,

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?

Thanks.

• Status: Open
• Question Views: 1397
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Kanhai Else 0 points N/A #93766

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 https://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.

Good Luck.

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/15/2012
• Question Category: MS Access