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

    Gradient Background Excel 03

    Create a shape box as large at you need for your background and set your gradient. With the shape box selected, hold your shift key and go to Edit and choose Copy Picture... I used the default settings of Screen and Picture. Paste the image into your favorite graphics program (like IrfanView)...
  2. mbarron

    User mail icon appears on many random user's workspace

    I've seen the same thing happen when a user sent out a reminder or an invitation for a repeating event that included a link back to the document. Mike
  3. mbarron

    Group emails by Date

    You could create a view - if you have the correct access of course- that can group dates. Create a View Go to Actions / View Option> Design... Right click on the first column and choose Insert New Column For the formula paste: @Text(@Year(@Date(@Created)))+ "-"+ @If...
  4. mbarron

    Excel Window

    With at least two of the sheets restored, go to Window/Arrange. Choose any of the options (Tiled, horizotal...) Resize the Windows however you want from there. Mike
  5. mbarron

    suppressing a field with like??

    For your conditional suprression formula you can use: if {article} like "*OMS" then true else if {article.field} like" *456*" then true else false Mike
  6. mbarron

    How to use HTML signatures.

    Here is a simple script I have attached to a button. Click the button, and it adds three blank lines then inserts the HTML file. You could create a button for each signature, then you don't have to worry about a default signature. @NewLine; @NewLine; @NewLine; @Command([FileImport]; "HTML...
  7. mbarron

    Error

    Do you have the comma (in red) afer the ,10)? picture(left({table.phone},10), "(xxx)xxx-xxxx") Mike
  8. mbarron

    Error

    I'm offering an alternative. What is the original data: {IV40700.PHONE1} or {IV40700.FAXNUMBR}? (several examples if the number of digits are different. What is the output once the ToPhoneNumber function is applied? Mike
  9. mbarron

    Error

    As dgillz points out the UDF, in this case the ToPhoneNumber functioon, is causing the problem. How does the ToPhoneNumber alter the phone/fax numbers? It may be possible to use Crystal's built in functions to achieve the same results. Mike
  10. mbarron

    Error

    I formula field within the report is driving the error then. Are you able to open the report within Crystal? Mike
  11. mbarron

    Error

    What is the formula that is generating the error? Without seeing the formula that the error is associated, it will be hard to help. Mike
  12. mbarron

    Subtract last value from first value?

    Try this one: =INDEX(Northwest!E2:E65523,COUNT(Northwest!E2:E6523))-Northwest!E2 Mike
  13. mbarron

    Setting mutliple variables within If-Then-Else command

    Your formula should work if you re-write as: Numbervar A; Numbervar B; Numbervar C; If {@Test}=1 then ( A:= A+1; B:= {@FormulaX} ; C:= A+B ) Mike
  14. mbarron

    Finding the last empty cell in a column - formula

    You can create a function to find the first blank cell. Function blank(myRange As Range) For Each myRange In myRange If myRange = "" Then blank = myRange.Row Exit Function Else blank = myRange.Row End If Next End Function Mike
  15. mbarron

    formatting

    This will do the trick. Cstr(int(year(currentdate)),0,"")+ "AYP Status" Mike
  16. mbarron

    Print the First record on page Footer

    Create 3 formula. Formula one - placed in the page header band and suppressed whileprintingrecords; numbervar reset :=0 Formula 2 - placed (and suppressed) in band containing Customer Field. whileprintingrecords; numbervar reset; stringvar name; if reset=0 then (reset:=1...
  17. mbarron

    Hebrew anyone?

    I did a Google on Tofilin and it returned a couple of websites for a Temp agency. I added an extra L for tofillin and it return a list of PDFs that combined "to fill in" I also got a "Did you mean: Tefillin" and it just may be what you are looking for. Mike
  18. mbarron

    Sneaky way to view Body of an email without triggering return receipt

    The agent doesn't strip the return receipt automatically - you need to run the agent from the Action menu with their email selected. If you ran it from the Action menu, and it didn't strip the RR - I'm at a loss. Use the same method you describe in your first post, but scroll down to the RR...
  19. mbarron

    Sneaky way to view Body of an email without triggering return receipt

    How I do it. I'm currently using R 6.0.3, but I set this up using R5. While in your in-box Go to Create/Agent... Give the agent a name. In the Run time area, I use "Action menu selection" and target being "All selected documents" Click on Add Action... button Action dropdown is "Modify Field"...
  20. mbarron

    Stuck in a loop, how to counteract it?

    I didn't receive a loop error, but couldn't fix your formula. I did however create a formula that should work for you. numbervar daysback:=20;//number of days back datevar dat:= ({table.date}); start date numbervar looper; for looper:= 0 to daysback do( if dayofweek(dat) in 2 to 6 then...

Part and Inventory Search

Back
Top