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

    Case in views

    Dont worry P.E.B.C.A.C. Problem Excists Between Chair And Computer No man is an island but 6 tied together make quite a good raft.
  2. IanStrange

    Case in views

    Hi Is there is version or similar thing to the case statment that can be used in a view. We want to show the value from one table if there is one and if there isn't then we want a different value from a different figure to be show. Thanks for any help Ian No man is an island but 6 tied together...
  3. IanStrange

    He he my boss has deleted his tool bars in formula editor

    In the end we uninstalled crystal on his machine, wiped all registry entries and then re-installed and it was all back to normal. He had done something similar moved the 3 docking windows tried to re dock them. Failed accidently resized them so now all he had is this tiny square box he can move...
  4. IanStrange

    DB timeout

    Erm no I still get the same message in the same amount of time. It seems like this message is coming from the sql server that I am trying to access. I was hoping for more of a way to handle the error. rather than changing the timeout counter. Our company is a very heavy db usage and so this...
  5. IanStrange

    DB timeout

    Hi I have written quite a chunky sql query to retreive into my spread sheet however I keep getting timeout errors 3 times out of 5. I was wondering if there is some way to control this error. THanks Ian No man is an island but 6 tied together make quite a good raft.
  6. IanStrange

    DB Timeout

    Hi I have a spread sheet that accesses our db and have recently written quite a chunky query and need all the values pulled in. I quite often get a time out message and realise this is needed but is there any way I can take this eventulity into account. i.e. is there some kind of on error for db...
  7. IanStrange

    He he my boss has deleted his tool bars in formula editor

    We are using Crystal 8.0 and there is noting in hisformula editor only the cursor no right click options. No man is an island but 6 tied together make quite a good raft.
  8. IanStrange

    He he my boss has deleted his tool bars in formula editor

    Hi Can any one help I cant seem to get them back. No man is an island but 6 tied together make quite a good raft.
  9. IanStrange

    Returning NULL's as 0

    Marvelous thanks No man is an island but 6 tied together make quite a good raft.
  10. IanStrange

    Returning NULL's as 0

    Hi Kind of a noob question. I have created a few views to speed my crystals up but I want the NULL's in some of the columns to show as zero's. I think it is quite a simple statement but I am not sure of the syntax. Thanks for any help. No man is an island but 6 tied together make quite a good raft.
  11. IanStrange

    auditing a hosts activities

    Hi In my previous post I wanted to limit a host activities. I am assuming by the lack of respons that it is not possible. Is it possible to audit that hosts activities instead. Thanks Ian Strange No man is an island but 6 tied together make quite a good raft.
  12. IanStrange

    Limiting the actions of a user on a certain host.

    Hi As said above is there any way of limiting what actions a user can do if logged in on a certain host. example:- A computer named 1 is allowed to do anything it likes no matter what user is using it. However a computer named 2 no matter what user is logged in is not allowed to insert or...
  13. IanStrange

    Crashing on export

    Hi I have written quite a large report but every time I try to export it it crashs. Any ideas. No man is an island but 6 tied together make quite a good raft.
  14. IanStrange

    Sub queries or cursors

    Hi Where I work uses sql server however we have some legacy systems on Oracle and I am not that familiar with the writting of queries. I have to make and example up as my boss does not wish for me to give away any system info. ok table 1 (car usage) salesmanid, year, carid table 2 (type of...
  15. IanStrange

    Deleting a sheet without the "are you sure" massage

    That is perfect except for the : befor the = Thanks you No man is an island but 6 tied together make quite a good raft.
  16. IanStrange

    Deleting a sheet without the "are you sure" massage

    Hi I am writting quite a big spread sheet and at one point it creates a new sheet does some stuff then deletes the sheet. But the problem I have is the users of this she are very dim and can not cope with clicking the yes button. So I was wondering if there is a way to delete the sheet without...
  17. IanStrange

    Send an email with the click of a button in excel

    Perfect thank you very much!!! No man is an island but 6 tied together make quite a good raft.
  18. IanStrange

    Send an email with the click of a button in excel

    Hi I am trying to get a macro that sends an e-mail when the user pushs a button in excel. Thanks for any help Ian No man is an island but 6 tied together make quite a good raft.
  19. IanStrange

    Writting a crystal report devilery app

    Hi Guys I am quite a good programmer but I have not touched this kind of thing befor. Can anyone tell me where I can look to get info. I have looked on MSDN and as usual the information is vague in the extreme. I did a search on the subject here but it is only question by people who have already...
  20. IanStrange

    *ing input box

    Ahhh cool got it. Thanks for the help Ian No man is an island but 6 tied together make quite a good raft.

Part and Inventory Search

Back
Top