Search results for query: *

Thanks a lot Richard Phil

Richard How would I do that and would it work on a Novell Network? Cheers Phil

We have a user interface that does not give the user any feedback if for example there is an error with data entry. We can not program a message box to pop up directly form the interface so the idea is to use webpages to display the message. If a stored procedure could open IE and go to a...

Does anyone know whether it is possible to call a URL from a stored procedure? Thanks in advance. Phil

Hi Can you create a Trigger on a view? MS SQL Server 2000 lets you do it but I cant think of any reason you would. Someone please enlighten me.

Hi Can someone please tell me what causes Access Violations. We have got a Delphi based database application (purchased from an external company, so we can't decompile it) that is very annoying because it causes a lot of these errors. It seems to be only certain PC's but they are all running...

Hi Can someone please tell me what causes Access Violations in Windows XP. We have got a database application that is very annoying because it causes a lot of these errors. It seems to be only certain machines (maybe there is something wrong with the setup) All help and suggestions will be...

I have a request from a user but I do not know if it is possible, can someone help. I have two similar reports (one is a cut down version of the other) they can both be viewed seperately at the moment by clicking on a button on a form within our database software, this then displays the report...

I have just upgraded from XP Home Edition to XP Professional since then I have not been able to get the Remote Access Connection Manager service to run. I have tried starting it manually but I get a message saying "Access is Denied". I have full admin rights on the PC so I do not...

I used to have a Compaq Laptop that used to do exactly the same thing as you are describing, no amount of updating solved the problem, in the end I put it down to a heat problem because I noticed it would stay alive longer if it was on a desk (which will discipate heat better) rather than my...

Thanks smah This was exactly what I wanted :-)

In Win2k you get the a dialog box which has six buttons on it ("Lock Workstation" "Logout" "Shutdown" "Change Password" "Task List" "Cancel") I thought it was the same in WinXP Pro, ctrl-alt-del in WinXP Home edition just take you...

I have just upgraded from Windows XP home edition to Professional but when I do ctrl-alt-del I am still getting the old Home edition dialog box. Any suggestions as to it is doing this will be welcome. Ta

I worked out a solution that works perfectly every time. if you use the ToText function on the numbervalues you can trim of the decimal places without CR rounding up and making someone a year older than they are. The code is: numbervar var_totalmonths := DateDiff...

Thanks it works for people over 1yrs old fine but I keep getting a divide by zero error for anyone younger. Any suggestions

I have a formula field in my report which returns a persons age in months using DateDiff e.g. Local DateTimeVar d1 := {dob_view.date1}; Local DateTimeVar d2 := {AE_PAS_DELIVERING.Attendancedate}; DateDiff ("m", d1, d2) I need to show the age in Years and Months i.e. 3yrs 4months...

Dont!!! I got an official demo version from the Microsoft Website and after I installed it I had no end of problems with my PC locking up. After I uninstalled my PC returned to normal. I will always recommend the Norton Suite of software, it may be a bit more expensive but it is far more...

I have been trying to setup a page for printing but CR8.5 keeps losing the page size. The report needs to fit on a landscaped 126mm x 201mm piece of paper, but if I set this up using Printer Properties and then save the report the next time I go to open it the formatting has reverted back to the...

I found the answer by playing with Excel believe it or not! The formula is: right({table.field},x) with x being the number of characters you want to display.