Search results for query: *

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

...timeinminutes := timeinminutes + {Routing.CycleTime} + {Routing.SetupTime}/{QuoteDet.Qty1}; WeightinPounds := WeightinPounds + {Materials.PartWt}*{Materials.Qty} As soon as I added the second formula, "timeinminutes" the "WeightinPounds" formula iterates for every instance of...

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

I put the formula @cnt into the Group header and details section. In the "Section Expert" the "New page after" is not directly available for the details section. This choice has two sub categories, "End of Section" or "__ Visible Records". I think the "End of Section" isn't what I need. When I...

I meant the records are numbered as I expected, starting at 1 and working up. The function still does not work, I enter 15 for the number of visible records and 28 are displayed at printout. I'm using a test printout with over 300 records so I don't get a false positive due to a coincidental end...

We have decided not to include the first item in the text box. This means that each record will only take a single line 100% of the time. Brad

The record number displays as I had expected. It starts at 1 and increases by +1 with each new part down the list. The text box I have is allowed to grow. Most of the time it will be 1 line but it can grow to two lines (about 10% of the time). The built in help regarding "New Page After __...

It seems that what I am taking as a record is being treated as a section by Crystal. Another checkbox beside the visible record one is "New page after End of section". When I check this only one of my "records" appears on each page. So, I really need to display a fixed number of sections per...