Solved

Headers .....using field names

Posted on 2000-02-21
3
162 Views
Last Modified: 2013-12-18
I am wondering if one is able to enter a field name (ie. @CompanyName and @AccountNo)in the Header box under Document Properties in either the Database as a whole or in the document itself.  Ideally I would like to have it entered in the Database so that it would affect all letters and memos.  This way it would draw on the 2 field names so that the user would never have to enter anything (it seems to printout whatever is entered as text when I try).

If this is not possible, I would like to use Lotus script as code behind/attached to a print button on the actual document.  Not having a lot of experience in this area I have tried the following code to no avail:

Sub Click(Source As Button)
  With ActiveSheet.PageSetup
     .LeftHeader="&10"("@CompanyName)          vbLf + "Acct. #"& ("@AccountNo.")
     .RightHeader = "10Page #" & P
     .Orientation=xlPortrait
     .LeftMargin=Application.InchesToPoi        nts(0.5)
     .RightMargin=Application.InchesToPo        ints(0.5)
     .TopMargin=Application.InchesToPoi        nts(1.25)
     .BottomMargin=Application.InchesToP       oints(1.0)
     .HeaderMargin=Application.InchesToP        oints(0.75)
     .FooterMargin=Application.InchesToP        oints(0.5)
      Print ActiveSheet
   End With
End Sub

I don't know what code would be used for suppressing printing on the first page???

When I activate this sub routine, I get an error message "Variant does not contain an object".

Any help with this would be appreciated.

Gary
   
0
Comment
Question by:cooper_g_d
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
fredriknorling earned 100 total points
ID: 2546122
You can´t enter any field in the print box and that can not be accessed tru Lotus Script neither. I think that the only thing you can access that object with is with C api.

The error message you´ll get is because there is no object called activesheet in notes.

/Fredrik
0
 

Author Comment

by:cooper_g_d
ID: 2548756
I just can't believe that one cannot create a Lotus Script for creating a header??? There must be some alternatives.  I would like to receive other opinions.....what is  "C api "?

0
 

Author Comment

by:cooper_g_d
ID: 2548761
I just can't believe that one cannot create a Lotus Script for creating a header??? There must be some alternatives.  I would like to receive other opinions.....what is  "C api "?

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Invoke VBA from lotusscript after mailmerge 11 251
Domino Application - View Refresh on Subform 15 101
External emails not coming through 3 144
lotus domino server console error 1 89
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question