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 SkipVought 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: *

  1. johannesd

    Outlook Read Receipt

    I know how to request a read receipt on a message, but how do I know if a message sent to me, had a read receipt requested by it's sender (is there a way I can look at the properties of the message to find out?) Thanks!
  2. johannesd

    Excel Wrap text question

    Great, it works! Thanks. I can't believe I've struggled with something so simple, for so long (couldn't locate it in help either..!!). Thanks again.
  3. johannesd

    How to remove programs from Win 98 startup

    Thank you! I'll try it at home tonight in Win98.
  4. johannesd

    Excel Wrap text question

    If I have a long description type text in a Cell, with Wrap Text turned on, I would like to force a 'line break' within the cell. How do I do that? (at the moment, I type spaces until the intened second line text jumps to the second line, or resize the column until it does.. there must be a...
  5. johannesd

    How to remove programs from Win 98 startup

    After installing trial software, it inserted itself as part of my Startup in Win 98. Now, I have to manually close it from the Taskbar very time I restart my machine. Looking at /START MENU /STARTUP, I can't find an entry for the program. Should I look elsewhere to remove it (registry maybe..?)...
  6. johannesd

    transposing rows as columns

    You might be able to use something like the following.Take note that you would have to add LEFT JOINS for as many possible different ACCTS a CUST might have (The coding below assumes MAX of three). Also, the coding below assumes the CUST cannot have more than one of the same ACCT numbers. You...
  7. johannesd

    Dates Between

    You should be able to use something like the following... SELECT cast(substr(date,1,8)||'01' as DATE FORMAT 'YYYY-MM-DD') AS Begin_of_month_Date ,CAST(substr(ADD_MONTHS (CAST (substr(date,1,8)||'15' AS DATE FORMAT 'YYYY-MM-DD'), 1),1,8)||'01' AS date format 'yyyy-mm-dd') - 1 AS...
  8. johannesd

    MAX(SUM(...

    Can you try something like the following....? SELECT MAX(a.Max1) FROM (SELECT MAX(SUM(qnty))AS MAX1 FROM tpurcd UNION SELECT MAX(prod) AS MAX1 FROM tpurcd) a
  9. johannesd

    Executing Macro's with a WHERE Clause

    Thanks for all the help.
  10. johannesd

    Calling Stored Procedues from a Macro

    Terafic, I think you can run a stored procedure from a macro if it is the only statement in the macro. You should be able to run macro's from a stored procedure.
  11. johannesd

    Executing Macro's with a WHERE Clause

    I need to do something like the following : EXECUTE MACRO m1 WHERE EXISTS (SELECT 1 FROM t1); Since SQL does not support the statement above, I initially thought I should probably get away using ActivityCount, but the number of macro's involved etc.. makes this a little messy to code... I was...

Part and Inventory Search

Back
Top