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.

Also, if you are using this as some sort of payroll clock, you will also probably need to account for lunch. To do this, you will need dropdowns in A1:D1. Put the following titles in A1:E1: A B C D E 1 Time In Time Out Lunch In Lunch Out...