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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hyuan

  1. hyuan

    editmask

    We are seeing difference in the implementation of editmask on different machines. On one machine the data in the edit mask is left aligned, and on another machine there is a significant amount of white space on the left before the data. This causes problems in that the control is not long...
  2. hyuan

    Subreport Page Orientation

    Is there any way to change the page orientation on a subreport? My main report has to be Portrait, and ideally I would like the subreport to display as Landscape. I am using CR8. Thanks
  3. hyuan

    Suggestion on printing large section of text

    I have a report with 3 pages of text attachments at the end of the report. Right now I'm using a series of labels to display the text (each label can hold a max of 255 characters). In order to make the labels look contineous, the labels has to overlap one another. Is there a better way to...
  4. hyuan

    isnum/isalpha

    Is there any way to verify a varchar field to be all numeric? I was thinking along the lines of a function similar to isnum or isalpha in C/Java, but have had no luck thus far in locating one in SQL or Sybase functions. Or perhaps verifying a numeric field may be done another way. Thanks in...
  5. hyuan

    formatting datetime field in formula

    How can I format a datetime field in a formula so the format changes from 2000/12/31 12:00am to December 31, 2000 ? When I applied the Date() function,the result was 2000/12/31. Is there another function that will convert it to December 31, 2000? Thanks.
  6. hyuan

    underlining in formula

    Is there any way to underline a portion of text in a formula? e.g. if (data.transaction_validated = 1) then "This " + {data.transactions_type} + " is approved. " + ... else "This " + {data.transaction_type} + " requires approval. " + ... where...
  7. hyuan

    Visual Linker with multiple paths leading to same table

    I am having problems linking two fields from one table both to another table. I get the message "The link you added caused a link configuration with multiple paths leading to the same table. You may want to consider reversing the links." The two tables I'm trying to link are...

Part and Inventory Search

Back
Top