Open other file from Approach

[ghazali]

Open other file from Lotus Approach database

I create reports and document database which content Report no, Decription, Year location and link;

As following Format

Report
no Description Year Location Link
A1 AAAAAAA 2001 C:\report\A1.lwp Butoon
A2 bbbbbbb 2001 C:\document\A2.lwp Button
A3 ccccccc 2001 C:\attachment|a3.lwp Button

I click the button , The system open the new windows which link with the stated in location field.

 

[paulbent]

If the path and filenames don't contain any spaces, use the macro Open command with parameter:

<<TableName.Location>>

substituting your own table and field names, which will cause the contents of the Location field to be substituted at run-time.

There's a bug in the Open command that causes a problem when there's a space. If you register at

http://www.xpertss.com

(free) and login you can access the Approach - FAQs - Fixes section. See the item, &quot;Macro Open command fails when the filename contains spaces&quot; for solutions to the problem.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk