Search results for query: *

Hi I have a table with 3 fields ContactID Email Email2 I would like to get an SP to return the following ContactID Email 23 me@me.com;you@you.com but if they dont have a second email then just return ContactID Email 47 xx@xx.com I'm really not sure how to achieve this so...

Hi Im just putting together a Sales display and have 4 forms lets call them form1 form2 form3 and main in the main form I have a panel with a timer after 30 seconds it display the next form etc is there any way of getting the forms to fade in and out of the panel? or even to move a form from...

HI I have an app that sends out bulk emails from my Database. So it loops round sending the email and it either succedded or failed. Now I want to record this info in a database lets say table name EmailCampaignResults FieldNames ContactID CampaignID and Succedded(Bit/True 0r False) now i can...

Hi Im trying to check the format of a mobil phone number and if its incorrect change it to the correct format. so lets say I have 07723 567432 I need to change it to 447723567432 I have no idea on regular expressions or if this is the way to go. Could some one point me in the right...

Hi I have an asp.net page that send a HTML email to my database. This all works great but i only get to know how many I have sent and how many where succesfull when it has gone throuh the database say 200 contacts. Is there a way to get the page to refresh every time an email is sent so i can...

Hi I have a form with a tabcontrol which has a panel in each tab when I open the main form I add a form to the panel which works ok. but when i go to my next record on the main form I cant get the tabcontol form to reload/refresh the data. I have tried this Dim frm2 As New fContactNotes...

Hi I have the below UDF that im trying to use another UDF in it. which is also below. CREATE FUNCTION "fnAverageSymbols" ( @Symbol1 varchar(1), @Symbol2 varchar(1), @Symbol3 varchar(1) ) RETURNS varchar(1) AS BEGIN Declare @AverageSymbol int, @fnAverageSymbol varcha(1) Set @AverageSymbol...

Hi I am having a crystal login problem from my asp.net app. I had it workking fine but now i have upgraded to SQLExpress 2005 and having a proble with the isnstance name. Before upgrading I used: SetDatabaseLogon("loginID","Password",(local),"CatalogName") But now I need to use...

Hi I am having a crystal login problem from my asp.net app. I had it workking fine but now i have upgraded to SQLExpress 2005 and having a proble with the isnstance name. Before upgrading I used: SetDatabaseLogon("loginID","Password",(local),"CatalogName") But now I need to use...

HI I need a function to find the correct date to do a Dlookup. My look up need to start on a Wednesday with the time > 8:45:00 the look up part I can do. I'm having trouble working out a way of getting the Correct Start date. So if the date is a Monday then i need to set my lookup to the...

HI I have a table with the following fields Surname DivisionID FormID What I need to be able to do is create a query/sp that gives me the following FormID D1 D2 D3 D4 6 smith Jones blogs green 6 orange dog cat smart Do i make any sense? Any ideas would be great...

Hello Im sorry if this goes on a bit but will explain as best I can. I have a report which is grouped by Month and Week when i use can grow in the detail section it works but when i then show a week footer so i can put a line on it the can grow doesnt work any more. also i need the folowing...

HI I have 3 columns Title Forename Surname In my SP I have Title + ' ' + Forename + ' ' + Surname This works great if there is a value in each field but if say i only Title and Surname it does not diplay anything. How can i get around this? Cheers

Hi In Access 2007 I have rich text Text boxes which I would like the Mini tool bar to appear when I highlight the text but I have to have Allow Built-in Toolbars ticked for this to work but the it also shows the Ribbon across the top which I dont want loaded at all. Is there a way to have the...

Hi Im sure this is easy but cant get my head around it. I have one table which i woul like to update from its self ie. StudentID SymbolsID EnglishTaker MathsTaker etc I want to update the Takers from SymbolsID2 To SymbolsID3 where the StudentID is the same. Do i Make any sense? Cheers

HI There HOw do I combine these 3 select statements? I can do two but having trouble with 3 seems to be the last bit of code. ALTER PROCEDURE dbo.spSymbolsByForm (@TermID int) AS Select A.*, B.* From ( SELECT studentID, EnglishA AS EnglishA1, EnglishE AS EnglishE1, EnglishComment AS...

Hi I have the following function in an access project. But it wont update does any one now why please. Dim cmd As New adodb.Command Dim param1 As adodb.Parameter Dim param2 As adodb.Parameter Dim cnn As adodb.Connection Dim RS As adodb.Recordset Set cnn =...

HI I am Coverting from an access mdb to sql 2005 and I have the below select staement which i seem unable to convert. SELECT tTimeTable.BoxID, [Subject] & Chr(13) & Chr(10) & Concatenate("SELECT tStaff.StaffInitials FROM tTimeTable INNER JOIN tStaff ON tTimeTable.StaffID = tStaff.StaffID WHERE...

Hi I have a function thats works out someones age in years and months ie 10.9 now i need to able to do the following. 13.3 minus 10.11 which I want to = 2.4 but returns 3.19 How Can I get it to reurn what I need? Cheers

HI I have two groupby stored procedures which I would like to combine into one. The result I would like is ActivitieDate, Salesperson, Interest, AmountOfLeads, AmountOfUnuseable. Below are the two SP that work ALTER PROCEDURE dbo.spWebLeadsByDateUnuseable (@FromDate smalldatetime, @ToDate...