Replies

Eureka I ran the setup in safe mode and it worked like a charm on the new machine and then restarted the machine and works like a charm.
I can’t thank you enough. Brillant

Unfortunately no luck . Doesn’t crash just nothing happens.
Works under VMware with xp loaded. just can’t get it to install under windows 10,
and I guess no way of migrating the program over from the current windows 10 machine.
Thanks for all your suggestions
JK

Good thought which is the way I managed to get it to work on an install on windows 8
On windows 10 New machine, The setup.exe when clicked this app can’t run on this pc check with manufacturer. If I try another setup.exe outside of the autrun then it circles and the circling just disappears.
I know that I have it running on my thinkpad t440 with windows 8 that was upgraded to version 10 so runs fine under 10.
It is medical manager that basically is not in existence any more.
No way of copying the registry items over with some program that will go find everything???? ie some migration program.
I copied the basic registry over to the new machine but evidentally did not find all of the entries
any workaround or trick
Thanks
JK

phenomenal thank you

not certain what I am doing wrong see attached Thanks jk

Since that number, 19721024, isn’t in a date format that Excel recognizes, you have to convert it to one.

If the format is: yyyymmdd, then this will work for you (the actual numbers in column B are 26596 and 42374, respectively (if you care). Then, they are formatted using a date format.

44198-Clip0007

Not certain what I am doing incorrectly see print screen attached. Many thanks

many thanks, beyond phenomal JR

Many thanks, just perfect
phenomenal all works and I changed the 1800 dob pts to 1900 just legacy patients in the database
Thanks again
JK

Hi just got the file to upload so you can see it… Thx
ALSO FAILS WITH DOB IN THE YEAR 1899 HAS TO BE 1900 AND LATER FOR THE MACRO VERSION

Hi I am probably messing it up but I just don’t see it..

always says false in cell for the formula version , whether dob cell has real value or 0
I did not check the macro version as I have to plug it into the database sheet and change reference values….

Dear Zeddy and Kweaver both of your solutions are phenomenal. Thankyou. I ran both and because some cells within the 5000 Date of birth records have 0 for a number because the date of birth had not been recorded both solutions error out. Is there a way to build in error handling for records that have 0 or are blank in their cells. I would manually enter but it seems that there are approx. 100 records throughout the spreadsheet….
Thank
Jrk

much much better thanks

thank you for explaining all this much appreciated

many thanks, I will try this