Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Headers .....using field names

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
cooper_g_d
Asked:
cooper_g_d
  • 2
1 Solution
 
fredriknorlingCommented:
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
 
cooper_g_dAuthor Commented:
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
 
cooper_g_dAuthor Commented:
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

Technology Partners: 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!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now