Search results for query: *

Hi, How can I catch an empty cell? the cell has a formula which reference to another cell. I tried isblank(A1), didn't work; I tried trim(A1) = "", didn't work; I tried len(A1) = 0 (returend 1), didn't work. Can anyone please help? what i try to accomplish is if A1 is empty, B1 shows "---"...

I have created a report. the main report will pass some values to a subreport. the subreport is showing all the details for each record. It worked fine. And i was working on it today. when i tried to refresh data and move page by page, when it reached to page 10, i received the error window...

Hi, I am using a macro to search one word and replace it using a different one. For example: Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "Exceeds Expectations" '20 .Replacement.Text =...

Hi, Questions 1: I am having 2 check box formfields in a Word template. when user entered different infor, there is one checkbox need to be hidden. How can do this? Question 2: By default the text form field's background color is gray, can i change it to other colors? Thanks for any help.

Hi, I have 2 word templates: temp1.dot and temp2.dot. then i wrote a macro in a word file which will either open temp1.dot or temp2.dot depending on the differetn input user entered. well, i have a hard time to run the templates. when double click on the template, it will open as a regular...

Hi, I am using Combox in my VB6 application. The style of the combobox is 0 - dropdown combo. the problem i have is every time when user typing the first letter, nothing happened. they have to type in twice of the first letter. For example, if they need to enter '1257'. they have to type in '1'...

I have created a report using Crystal Report 6. the detail section is calling from a subreport. the subreport is always printed out on the next page and leave the prior page with only group headers and blank page. how can i avoid this? I already checked the subreport option - keep object...