Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: smgs
  • Order by date
  1. smgs

    can users run reports without seeing the standard screen

    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
  2. smgs

    What DB manager should I use to desing a DB applicaiton???

    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...
  3. smgs

    2 columns into 1 excel cell with line break

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

    Exporting to Excel: Line breaks disappear

    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...
  5. smgs

    2 columns into 1 excel cell with line break

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

    null fields in formulas

    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...
  7. smgs

    2 columns into 1 excel cell with line break

    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.
  8. smgs

    2 columns into 1 excel cell with line break

    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...

Part and Inventory Search

Back
Top