Search results for query: *

I have created my first CLR in SQL to use regular expressions designed to match certain codes. Trouble is that I am trying to match the text HE1 in a string and keep getting a match for HE12 which is what I want to avoid. I have tried dbo.RegMatch(N'HE1[^0-9]' but this doesnot match anything...

I will try and make this as simple to understand as possible. I want to create a calculated member that will allow me to use the result as part of a query. The calculate member must contain the sum of a particular measure (measures.amount). This member must have already had two dimension...

Can someone help me to construct an MDX expression. Its easier if I explain the final result. For admissions to hospital. Number of unique attendances as rows and months for a specific year as columns. The measures to show in the middle would be number of unique patients. So from the above...

Please can you help me with a function I am trying to create in TSQL. I want the results of different queries returned depending on the parameter I pass to the function. ALTER function [mercerd].[FN_Endoscopy_E01_QuarterlyCensus] (@lineid char(3)) returns table as return ( IF...

I am trying to work out a function that will allow us to round a given time to the nearest custom interval. I work in a hospital where we have consultant clinics. Take the example of a typical clinic where the session runs from 09:00 to 12:00 with each appointment lasting 30mins. So to fit...

I have just had my Microsoft Office Version upgraded to 2003. Since this upgrade the filter toolbar has become disabled and when I choose navigate nothing happens. I have tried to open another cube but this does not solve the problem. My colleague has the same version of office installed and...

Does anyone know why the powerplay web reports we have will prompt when run from impromptu but not from upfront? Very bizzarre Please help I appreciate it. Thanks alot David

This is very strange... When using the above mentioned program. We have encountered a major problem with dragging dimensions from the filter bar onto the grid. We are unable to drag the dimension onto the grid to replace a column or row dimension, although this works on some computers. Every...

I want to add a column to a table and make that the primary key. I am using the following alter table KH06AdmissionsTBL add column rowid int primary key what am i doing wrong it said no nulls allowed but if i replace int to autonumber it still wont work. Any DDL experts out there? Many...

I want to add a column to a table and make that the primary key. I am using the following alter table KH06AdmissionsTBL add column rowid int primary key what am i doing wrong it said no nulls allowed but if i replace int to autonumber it still wont work. Any DDL experts out there? Many...

I have a conditional format set on about 12 fields that contains percentages. I want the background colour to turn red if a value reaches 20% or above. The format I applied is for any value > 0.2 (which according to my maths understanding is 20 percent) It is not working. Anyone any idea why...

Just a little problem here. Consider the following on error goto errorhandler docmd.openquery "thequeryname" docmd.openquery "thequeryname1" docmd.openquery "thequeryname2" leave: exit sub errorhandler: msgbox "Error Occured" resume leave ok when the...

We have version 9 of Crystal Reports. Someone in the department is leaving and because of this he has changed the owner all of his stored procedures from his name to dbo. This has had a knock on effect in that all the crystal reports that were referencing his stored procedures with him as...

Is it possible to query a recordset when it is already open. I want to find the maximimum value in a field but would rather not close the recordset. Many thanks David

Can someone advise me on transactions in the following scenario. Linked tables to sql server The present code uses the syntax docmd.openquery ..... How do I set up transactions for the above. There is presently 30 lines of code each with a docmd.openquery command on it. Because lots of these...

We have SQL Server and an application written in Microsoft Access 95. My task was to get the data onto the SQL Server from the Access database, delete the data on the Access database and then link the data from the server into the Access Application. My theory was to attach the tables when the...

On a Tab control I want an event to fire when I click on the top (tab) bit of it. Is there a way of doing this. The rest of the control has a click event but not the tab part of it. Ideally when I go from one tab to the next I want an event I can write code into. Thanks David

I am using DAO 3.6 and am looping through a recordset. When I try to compile the code I get an error message saying "Argument not optional" when I debug it points to the rs.movenext code. I must say that it is Access 95 I am using. I cannot understand why I am getting this message...

You probably asking why is he still using Access 95? Well its certainly not by choice and it has cause me lots of heartache so far. I am simply trying to attach tables from our SQL Server using the password and username entered into a logon box. I can attach the tables fine but need a way of...

Just a little question please when i look for allowbypasskey in the help I get a message that says the following: Hidden Language Element You have requested Help for a language element that is hidden, and therefore unavailable for programmatic access. Do you know why this is?