Recent content by Schmidtty

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 =...

PERFECT! Thanks for the help.

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...

That code then gives me a prompt for the field. I just want it to read the record in form one and open to form 2 ?!?!?!?!?

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...

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...

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...

perfect!!!! thanks much

should the event procedure go in combobox2 - bankerid? or the initial combobox1 - region?

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...

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...

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...