Search results for query: *

Skip and willif - I'm grateful for the suggestions and will take them under advisement. Thanks again guys! Tom Born once die twice; born twice die once.

Got it! It turns out I needed to add a line feed after the carriage return, and only add the tab if I hadn't arrived at the last column. Here's the ammended code: 'determine last invoice row on send sheet LastSendRow = Worksheets("Send").Range("A65536").End(xlUp).Row Open...

Hi willif - Access is an interesting notion, but the problems I see is that there is no clear indication of what the field names would be - each "record" does not have a header. The start of the invoice is flagged with "B3" and there is a series of values, and the end of the invoice is flagged...

Hi Skip - you are right! If I open Word and use it to do an edit replace of """ with ", that will certainly do the trick. The problem is that I need this to be a hands off process. I have a routine which correctly analyzes which invoices pass muster and separates them from those that don't...

Hi Skip - I should have been a bit more specific in my reply. The problem remains that if I leave the quotes in the sheet tab in my book which I then save as text, then when I open the text file, I discover that "B3" has become """B3""" in the text file itself, not in the sheet tab - it remains...

Thanks for the reply! I have tried the above to no avail, so I have decided to write directly to the file. I have investigated the forum and found several attempts at this, but can't quite get it to work. I need a carriage return at the end of each line, and I also need to strip out the last tab...

I have written a routine in VBA for Excel XP which imports a tab delimited text file into my workbook. The original file looks like this: "B3" "2421835" "2421835" "TP" 05/17/07 1175.00 "CEI" 05/06/07 "N9" "IT" "KUP" "N9" "BF" "YA" "N9" "PO" "CA23WHSEF" "N1" "SH" "CONOCO PHILLIPS" "N3" "KUPARUK...

Thanks for the reply! This sounds like a decent way to go, and I will try it on Monday. As for which way to sort it, I will have to hash that out with the collections manager. I agree that the DATE field is an absolutely bad idea, but I am stuck with it - it's an export from a legacy database...

Hi there - I need to be able to compare the percentage change for amounts over due (>60 Days, >90, >120). The table in which the data resides is Current Month Aging History. Here is the field list: CUSTNO NAME DATE OVER60 OVER90 OVER120 Here is the query I am currently using...

This does not appear to be the case. I have only 1 signature, and it only applies to outgoing email messages, replies and forwards. Tom Born once die twice; born twice die once.

Sorry about the repost, but I received no replies, probably because I wrote a follow on so it looked like someone had responded. Microsoft Outlook appends the following text to the bottom of meeting invitations: =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~= Click the following link...

Follow on to previous: apparently it is only doing this in meeting invitations. I am running Outlook 2007. Thanks in advance. Born once die twice; born twice die once.

I recently noticed that Outlook has been adding the following to the bottom of my outbound messages: =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~= Click the following link to get a map and driving directions in Live Search Maps: http://go.microsoft.com/fwlink/?LinkId=65850&WIP=12...

Thanks a million! As usual, you were right on the money. [medal] Born once die twice; born twice die once.

Hi there. I have a crosstab query for reporting survey results by department. Currently it returns the number of times individuals in a given department chose a certain category. This works fine. In my report which references this query, I need to know how many individuals as a total percentage...

I'm using PowerPoint 2007 in compatibility mode for PowerPoint 2000 & 97 to develop a tutorial for software training. Most of the end users will view the show using PowerPoint 97. Here's my dilema: Users can click a hyperlinked text box labeled <Previous (it's on the Master slide) to view the...

If you are using an outline format, it is possible that you have formatted the Heading 1, Heading 2 or Heading 3 style to revert to another style when you hit enter (in other words the [b]style for the following paragraph[b] setting is not what it should be.) Heading styles can sometimes...

Have a look at conditional formatting -it works in a similar way to the way it does in Excel. Tom Born once die twice; born twice die once.

Hmmmm - are you certain that all the fields are present on your form? Could a tester have inadvertantly renamed a form field? Tom Born once die twice; born twice die once.

...A1:D1. Put the following titles in A1:E1: A B C D E 1 Time In Time Out Lunch In Lunch Out Total Hours Put dropdowns in A2:D2 Enter this formula in E2: =(D2-A2)*24-(C2-B2)*24 Enjoy! Tom Born once die twice; born twice die once.