Recent content by megmoo75

Does anyone know if there is a setting in Outlook 2003 to prompt the user to indicate if the message should be saved before sending each message? I have only been able to either save all sent messages or not save any (by default). I know you can save an individual message by going to Options...

No, I'm attempting to move them in the OnFormat event, but I need to know how much to move each item and that depends on information I need from the OnPrint event.

Hello - I have a two-column report consisting of 11 different subreports. What I would like to do is dynamically adjust the start point for each subreport (the top value) such that an equal amount of whitespace is added between each subreport while keeping it on a single page. My subreports...

Does anyone know how to format an Excel cell so that when it's empty it just displays a dash? The cell will still be included in various math functions, so it can't have it as a value - it needs to be a formatting option. I've seen this before, but I can't figure out how to do it. Any help...

Worked perfectly - thanks!

Does anyone know if there's an Excel function for searching for a particular character starting on the right side of the string, rather than the left. I basically just want the SEARCH function to start at the end of a string and search backwards. Thanks in advance.

Hello - Does anyone know if it is possible to have one tab with landscape orientation and one tab with portrait orientation in a single Visio file? When I change the page orientation, it changes it not just for the current tab, but for the whole Visio file. I'm using Visio Professional 2002...

I have a report that has several memo fields listed, each of which has the CanGrow property set to Yes. It works great with one exeception: if a memo field is at the bottom of a page, it lists the first line on page 1, then the rest of the field on page 2. I want to force the memo field to...

Does anyone know if there is a function in Excel to count the instances of one string within another string? For example, if I have this value in my cell: 1.7.2.2 I want to be able to count the number of "." that occur in the cell. So the value for the example above would be 3. Thanks in...

OK, I figured it out and thought I'd post the answer in case others search for an answer to this problem. There may be a much easier way, but this is what I did to fix it. I created an invisible text box called txtZero on my report and set the value of it to 0 (zero). Then, the control...

Hello - I think this is probably quite easy, but I just can't seem to get it to work. I need to sum the values of four items in each row as shown below: Task Total Person1 Person2 Person3 Person4 task1 5 4 1 task2 10 3 4...

I had a typo in my previous post - there shouldn't be a semi-colon after the URL. It should be: <a href = &quot;http://www.site.org/index.htm&quot; target = &quot;_top&quot;> <img src=&quot;images/home.gif&quot; border=&quot;0&quot; name=&quot;links&quot; border=&quot;0&quot;></a>

Thanks for the replies. The _top works perfect. So, for future readers of this post, I had: <a onclick=&quot;openPage('http://www.site.org/index.htm','content')&quot; > <img name=&quot;img1&quot; border=&quot;0&quot; src=&quot;images/why.gif&quot; border=&quot;0&quot;></a><br> and changed it...

I am editing some code that someone else developed and don't know a whole lot about frames. The page I'm editing is using frames and along the left side frame there is a group of navigation buttons. Normally one would want those buttons/frame to stay displayed as users click on the buttons to...

I have a DTS package the uses a stored procedure to populate an Excel file (that is created when the DTS runs). The DTS package then uses an ActiveX vbScript to open up a Word Template and mail merge the Excel file with the Word Template to create and save a Word document with the merged data...