Search results for query: *

The following fixed the problem Selection.Find.ClearFormatting With Selection.Find Do While (.Execute(findtext:="Total number of claims under audit", Forward:=True) = True) = True Selection.HomeKey Unit:=wdLine Selection.EndKey Unit:=wdLine, Extend:=wdExtend...

I have a text file from a legacy system that I am trying to clean up. I have opened the file in word and created a macro to make changes to some of the text, this works without any problems . I then created a macro to find the specific text I was searching for, and a second to delete 2 lines. I...

If anyone is interested in the osborne, here is a link. http://oldcomputers.net/osborne.html Alan Senility at its finest

In answer to jmd0252. How about the osborne Alan Senility at its finest

I guess I can be considered old. I worked in a computer store and we sold the IBM when it first appeared and just for the record Lotus 1-2-3 was not the spreadsheet that came out with it. It was an earlier product called visi-calc. Lotus was the next generation. Alan Senility at its finest

I'm in Royal Palm Beach, FL. and have just recently found this forum. Thanks for all of the chuckles. Alan Senility at its finest

That worked great. Thank you so much. If I understood some of what I have read, then the rest can be done using DateAdd. I really appreciate your help Alan Senility at its finest

I have 3 fields that when combined are a date, this data is exported form an old AS400 program and can not be changed. The fields combined are for a new contract date. The fields are "T01CONDTM" (Contract date Month), "T01CONDTD" (Contract date day), and "T01CONDTM" (Contract date Month), and...

Thank You Leslie, This is the type of thing I was looking for. Alan Senility at its finest

I have a situatin where we are trying to use information from a data base. One of the fields we have is a quarterly fee. I am trying to automate the printing of contracts. In the database the fee would be "345". But on the contact it need to be printed as "Three Hundred Forty Five Dollars...

You can check for 0 for unchecked and -1 for checked. Alan Senility at its finest

You should be able to get it from within the mail merge helper. Open the word document. Turn on the mail merge toolbar. Find the mail merge helper button. Under number 2 the data source it will name the database and query being used. Hope this helps. Alan Senility at its finest

I just wanted to thank everyone here for all the help you have given me, and wish everyone HAPPY HOLIDAYS!. Alan Senility at its finest

What regional setting are you using, I want to experiment? Alan Senility at its finest

Can you give a little clarification. In the example you are saying number. What you are showing is 2 numbers separatied by a comma. Is the field in you table a number or text? In you desired outcome you show a number with 3 decimal places. Is the comma in the first a typo, and should be a...

You can also nest the IIF's Status: IIf([X]="a",True,(If([X]="b",True,(IIf([X]="c",True,False))))) Alan Senility at its finest

Thanks PH, That was the answer, I was trying to put the code right on the line, not in an event. A well deserved star. Alan Senility at its finest

I have a form with a combobox that uses a lookup to get a company name from a linked table to a different database. The lookup is 5 columns wide, with the first column being the one that is bound. What I would like to happen is that after a company is picked that on the afterupdate that...

Thank you very much. That did it. Alan Senility at its finest

We coach hearings for our clients. I have a simple database with entrys for each hearing. I have a query that starts with the contract month for our clients, and then brings back the hearings for each client within a time frame. What I really need is the total of hearings for each client, not...