Search results

  1. S

    cc: on an automated lotus notes email.

    I am trying to cc: someone on an automated lotus notes email. Please review: Dim RECIPIENT As Variant 'Sent to mail to: Dim RECIPIENT1 As Variant 'Also Sent to mail to: RECIPIENT = TMSCHMI RECIPIENT1 = RPALLEN Set oDoc = oDB.CREATEDOCUMENT Set oItem =...
  2. S

    paragraphs in email body

    I am trying to provide text in a lotus notes email. and can't get any new lines. it all has to be one string. below is my code: oDoc.body = "The cat jumped into the car. The car rolled down the hill. the car sank in the pond." I would like it as: The cat jumped into the car. The car rolled...
  3. S

    open form to same record

    I am hoping some one has a solution to this one............ I have a form with a tab control in it. From this tab control I have a button that opens a seperate form for more detailed information. All my data is in one table, however when I launch the seceond form I am back at record number 1...
  4. S

    hyperlink help

    I need to create a macro that will allow a user to link their word document to the hyperlink field in a table of instituions with which we do busienss. My table has the field set as a hyperlink. I want to create a command button that will run a "macro" or code that will walk the user though...
  5. S

    IIF statement in criteria

    I have the following statment in the field criteria of a query: IIF([table1]![fielda] = "All", Is Not Null,[table1]![fielda]) What I am really after is if I have "all" in the field I am trying to match select all possibilities, if it is not "all" select the one I have selected. the criteria I...
  6. S

    refreshing comboboxes

    I have been searching this forum for help on refreshing a cascading combo box, and I either get lost or am not finding what I am looking for...So I thought I would just ask............ I have a combo box for regions (combobox1) and then a combo box to find the bankers that are assigned to that...
  7. S

    operator error?

    I have a filter table and a main data table The filter is a bunch of yes/no fields based on product. My data field tells me the number of accounts the person has. I want to say if I check the product show me all the account that have at least one account. My criteria in hte data field is...
  8. S

    leaving list box null to choose all

    This may be an elementary question. In my form.....I have several list boxes to choose: Region and company size and SIC code and various other criteria. This is put into a table which I then run a "filter" query off my main data table. I am fine if I fill in every box. Now, I want to...
Back
Top Bottom