Search results for query: *

Hi, I would like to know what the best way would be to prevent certain users/user groups from accessing databases in SQL Server. I was thinking of deleting the odbcad32.exe file in order to prevent access, but am unsure as to whether there is a method with more granularity? Any help on this...

Hi, I am tryiing to create a report that calculates a weighting based on the following formula: Order Produced Quantity / Overall Machine Qty I then want to take this and multiply it by a yield percentage. I have been able to do this but cannot total up either column. From reading other...

Hi, We have a SQL server db backend for our ERP system. I have written a Crystal Report to extract data from one particular table called itemspecbomw which contains amongst other things Bill of Materials costings. When I run the report I know that some rows are missing as when I look at values...

Hi, I have a stored procedure that updates a single record. Instead of me having to pass in a parameter with the database name, I want to use the stored proc to rename any database with the following syntax: sqlserver-*The name of the database* Currently I hard-code the first part of the...

Hi, Is there a way of popping up a message box that can be customised to display a warning message to users when IE is loaded up? Can the same thing be done for Outlook? I am aware that a message box can be displayed when logging on to the domain but I want to do this when an application is...

Hi, I would like to know whether there is a way of bulk deleting maintenance plan history from SQL Server 2000. Can I use a delete SQL statement in order to do this without having any adverse effects elsewhere? Many thanks, Tony Kennedy. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is...

Hi, The following error message appears every time a user presses the save icon in Word. [Project]_ Save Doc ERROR: 52 Bad File Name or Number The only way the user can save is by using the X button to close the file and then save. This is the second time this has happened. I cured it before...

Hi, I have query like this: select isx_transaction,isx_item,isx_itemspec,sum(isx_materialcost) from itemspecbomw group by isx_item,isx_itemspec,isx_transaction order by isx_item,isx_itemspec,isx_transaction which returns: Tr. Num Code Spec Cost 44300 FCH0001 1 1.87042 45258 FCH0001 1...

Hi, I am writing a report that is using a dBase database. In the report I have 15 sections. These are comprised of a text object and three dBase fields. I have set the condition to suppress and it works fine if I don't have the text object in the section. However once I add the text object...

Hi, I am experiencing a strange problem trying to connect one particular P.C. to SQL Server. I can connect okay via Query Analyser,but when I try and establish a connection with Enterprise Manager it gives me a message saying that the SQL Server cannot be found. I have tried installing the MDAC...

Hi, Just a quick query on whether I can save reports in CR 9 as CR 7 reports? I need to know this as our current software will only accept CR 7 format reports. Thanks in advance, Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is half the work. Every start is difficult . -Two Gaelic...

Hi, A really strange problem this. The folder shows that there is one item in the outbox but there is none there. Does anyone know of this problem or any suggestion as to how to fix it. Many thanks in advance, Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is half the work. Every...

Hi, I am sure this is a burning issue with many admins. Is there a way of applying patches without having to re-boot the servers. With all the recent viruses and holes beinf found in Windows, it is really difficult to squezze in the almost daily updates from MS. Cheers and thanks, Tony. Tony...

Hi, I have written a number of reports in Crystal 7.0 where the page header was deleted to save paper as it was never envisaged that it wouold be used again. However, a new business demand requires it to be there. Is there a way of restoring the page header back to these reports? [ponder] Many...

Hi, A really strange problem this. The Outbox is saying there is one item left to send, however when you look in the folder there is nothing in there. I have tried re-booting etc. but to no avail. Is there a way of resetting the folder to empty? Machine is running Win 98 with no other faults...

Hi, I am looking for a simple formula that will strip out HTML code from a field of datatype memo. This includes removing characters like   etc. Does anyone know of an easy way around this? Many thanks in advance for yuor help. Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is...

Hi, Is there a way that the table row names used as headers in the grids tab when a query is run can be cut and pasted into Excel. At the moment all I can do is copy the actual data but not the data headings. Many thanks, Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is half the...

Hi, A machine here has Win 98 with a Genius Netscroll PS2 mouse. When the system boots up, the mouse works fine after a random period of time, the mouse movements become jerky. I have tried a change of mouse driver to the standard PS/2, but it then cannnot detect the mouse. Many thanks, Tony...

Hi, As part of a software installation routine, I need to change the security permissions of a particular key in the registry of a Windows 98 machine. I have installed Microsoft Remote Registry on the 98 machine. Then I log on to my own Win 2k machine and run regedt32. Using this I can see the...

Hi, We have reports which have standard totals. I need to be able to bulk copy these into another section of the same report. At the moment I have to paste each one individually. Is there a way of doing it in one go? Funny thing is that you can do a bulk move but not a bulk copy by using the...