Search results for query: *

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

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.

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

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.

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.

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.

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

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.

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

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

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.

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

Hi I am using input boxes as passwords to prevent the use of macros by certain button happy members of staff. I would like for everything that is typed into the input box to be ***** but the actual text to be stored. Is this possible? If not how could I acheive the same end? Thanks for any help...

Hi I was wonder does anyone know how to either hide or protect the vb code embedded on an excel spread sheet. THanks Ian No man is an island but 6 tied together make quite a good raft.

Hi I am working on an app for work and I have done quite a bit of investigation into ADO in VC++ 6 and have got a record set with data in. However I can not seem to find the information to get this data out of the record set. It is an ADORecordset with methods such as Rs1->MoveNext()...

Hi I am looking for a way to see all the triggers currently on every table in one database. Is there some bdcc I can use or clever select statement on one of the system tables. Thanks Ian No man is an island but 6 tied together make quite a good raft.

Hi I am very new to this topic and need the very basics is there a site or snippet of code that could get me rolling. THanks for any help Ian No man is an island but 6 tied together make quite a good raft.

Hi I am using crystal 9 and have brought in one of our pallet reference numbers which is a long string of numbers and we need this in it excact form but crystal 9 keeps converting it to scientific notation any one know a way to stop it or convert it back Thanks No man is an island but 6 tied...

You need these for version 9 if you want to use XML stuff but NO ONE I mean NO ONE knows where to get them from I cant download them they merant web page is a steaming pile of *Censored* and I have project piling up. Any help you be brilliant thanks Ian

Hi I have written a really complex report dealing with a lot of averages. One important part was that if a value is null it is not included in the average. However when I export this crystal to excel is changes the value to take the nulls into account????? Very odd??? I have tried changing the...