Recent content by bpeirson

Hi, I'm working with Lotus Notes 9 (IBM Notes). I'm trying to check for a value in a series of fields using a loop. There may be an obvious answer here but I can't find it. n := 1; @While(n <= @Elements(myNames); @If( FIELD(myNames[n]) ="4" ; fullNote := fullNote + ", " + myNames[n] ; ); n...

Remou, will the ADO code you posted create a new table or add data to an existing table? I have realized that not all the computers running my code will have Access installed so I need to use a method available to all computers. I have no experience using ADO or Jet. A push in the right...

Thanks for the alternate method. I found my problem, there was phantom data in the columns to the right of the true data. When I did a manual import from Access I saw that Access was trying to import 45 columns when only 8 columns exist in the table. Brad

Thanks, everything starts out well enough now but I get an error while calling appAccess.DoCmd.TransferSpreadsheet. The error is The F1 will change to F9 if I include headings in the table. The MSDN site is not very forthcoming with information unless you are a skilled programmer. Any help is...

I can import data from Access to Excel then calculate table entries but I can't export back to Access using VBA. After I start an instance of Access from Excel's VBA I don't know which methods to use to "Get External Data" and add it to the original table I found it in. I would like all the...

I have a Crystal report which is formatted to print to a landscape 4" x 3" label. Whenever I send this to the printer the text is rotated 90 degrees relative to the label. When I switch to portrait the text is oriented correctly but the dimensions of the label are switched to 3" x 4" and my...

On the page setup dialogue I can choose landscape or portrait. When I choose one or the other the width and height dimensions switch. I understand all of this, however. When I print, the printer (SATO CT-400 DT) always orients the report the wrong way. If I can force Crystal to print in...

This has been cross posted from forum602. I was informed I might get better results here. We have a Lite-On DVDRW LH-20A1P installed in our server which is running Server 2003. The driver was updated yesterday, the Lite-on website includes DVD-RAM as one of the features available with this...

Thanks, I will go to the other forum for more help.

We have a Lite-On DVDRW LH-20A1P installed in our server which is running Server 2003. The driver was updated yesterday, the Lite-on website includes DVD-RAM as one of the features available with this drive and the drive is listed as "DVD-RAM Drive (D:)" in "My Computer". The problem is when I...

I am trying to use the formulas for 3 reasons: The running total fields won't let me do a running total of one field multilpied by another field. As I was building the report column by column it seemed OK to use a formula for time because it worked so well for weight. Our preferred format is to...

For those who have been patiently waiting for the answer. My front end is embedded with a previous version of Crystal. It does not support this function which is new to 2008. Brad

Based on your suggestion I separated the "timeinminutes" formula from the "weightinppounds" formula. First I put it in the detail section with the weight, then in its own detail section. Same reults either way. Then I tried "timeinminutes" in its own group. Then I swapped the groups. When I...

A few weeks ago I recieved code similar to that listed below from lbass on this forum. It worked great as written. Then I copied and modified the code to what is shown. //To be placed in the details section whileprintingrecords; numbervar WeightinPounds; numbervar timeinminutes; timeinminutes...

LB Your code works as advertised. Problem one: I seem to have had poorly linked data, I think a redundant field caused the report to create a new group for every record. It then displayed every record for every new group. Problem two: My front end software was suppressing 109 records which...