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

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

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

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

My report prints on an underlayed form. The form has some graphics at the bottom which will be printed overtop of if there are too many records on the page. I thought the simple fix was to check the box "New page after __ visible records" and enter an appropriate amount. When I do this the...

I am trying to format a report to fill in an existing form. The report will need the equivalent of a page header acreoss the top, a page footer across the bottom, a page header down the right hand side and a details section on the left hand side. When I say page header down the right hand side...

How can I have Crystal check to see if a record exists in a table. We have two tables of information. One is intended for long term stock items, table A. The level of detail is quite high in this table. The other is intended for transitory stock items, Table B. This has less detail because the...

I am modifying an existing report using crystal. The report is used as a packing list for products we sell. In the course of manufacture we "attach" documents to the product in our data base. Some of the document numbers must be printed on the packing list below the part number. Currently for...

I currently have the following query which finds the user supplied text "[ENTER PROJECT ID:]" in the noted field. SELECT * FROM ESTIM WHERE ((ESTIM.USER_TEXT2 = [ENTER PROJECT ID:])) ORDER BY ESTIM.USER_TEXT2 ; Currently the records are returned only if the searched text is the leftmost text...

My problem seems similar to the XP laptop previously posted. When I join it to the Domain (server 2003) at work it moves at a crawl but is 98% idle. I can log on to networks at University, home and throughout the city and it works fine. What could cause this?

I have the following code in VBA Excel. The "GetUserName" statement returns the "Can't find project or library" error. This code runs well on several machines here. I only have a problem with the newest machine. I hope that all I need to do is find the appropriate library and reference it. if...

Is there a Vista Pro like there is an XP Pro. We are using XP Pro at work because we need to log into the domain at work (can't do this with XP Home). If we move to Microsft Vista will we ba able to access/join the domain?

Does anyone have code which will update an Excel file when an email is recieved. I would like the sender, subject and time to be saved in a log on excel. I have virtually no experience writing code for outlook. Any help is appreciated.

I am trying to move 3000 plus files from various subfolders into a common root folder. I found this code but it does not do exactly what I need. Sub movefiles() Dim fto As String Dim ffrom As String 'folder from ffrom = "\\original server folder" 'folder to fto = "\\Destination server...

On my userform and its controls there is a HelpContextID but I can not find how to specify a helpfile for these objects. How do I specify a help file and how do I create the file? I have opened an existing help file with wordpad and it is clear that a helpfile is not simply a text file. The...

I have a form with several textboxes. This form is used to streamline a process originally done directly in a worksheet. For the most part it is working well. The part I don't like is when working on a worksheet I could enter a formula directly into a cell to get a number. How can I enter a...

I have an add-in which when it loads will open a specific workbook and read information from it. This information is then used to name a control button. What is happening is that a custom menu has a sub menu with controls which include specific information thus: Custom menu --> Sub menu...