Recent content by smgs

After I complete reports for my clients, I want them to execute them directly without seeing the CR 8.5 screens and icons. They should just be able to see a list of reports, enter any parameters and select printer, screen, file, export to excel in a stored format and then just run. Can this be done

If this is truly an accounting, order entry, inventory application, have you considered one of the off-the-shelf packages? I haven't looked at them for a while, but Macola and Business Works by Manzanita, to name a few may still exist. And there must be others. Much cheaper than custom...

Yes, leadingCaps is a UFL; it works fine except it is rigid, so Mary smith MD becomes Mary Smith Md, etc

I've had the same problem so I tried chr(10) - with CRW32 8.5.0.217 exporting to excel 8/0 and8.5 extended. It looks fine on the CR screen, but does not work on the import. The ascii equivalents of Alt/enter are: 28 Hex, 1C Octal. There is no decimal equivalent. How do I insert Hex or Octal...

I am using basic syntax into excel 97 sr2, exporting it as excel 8.0 extended

If I have 2 columns and one of them is null and I use them both in the same formula, for example, formula = col_1 + col_2, then I get a null result when col_ 2 is null even if col_1 is not null. When they are both not null, I get a result. I have tried to test for null as the beginning of...

Tried your solution in Basic: formula = leadingCaps ({FORM_PRF_ALL_V.PAYEE_ADDRESS1}) + chr(13) + leadingCaps ({FORM_PRF_ALL_V.PAYEE_ADDRESS2}) But excel does not recognize the break More help, please.

I have 2 columns, Payee1 and Payee2. I want to export them to excel and have them appear in 1 cell, under each other: Janice Smith Smithsonian Museum This would be the equivalent of entering them into a spreadsheet cell directly using Alt/Enter to break the lines. Can I insert the...