Recent content by saintedmunds

Works great thank you

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 I have the timer set to enabled so when the form opens its already started. And the on the main form timer in closes this foem when it opens the next one so i didnt think i would need to stop it? Cheers

Sorry here you go. Main Form with panel: Public Class fMain Dim myfrm As Form Private Sub fMain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load myfrm = My.Forms.fAvailable Me.cMainPanel.Controls.Clear() myfrm.TopLevel = False...

Hi This doesnt work when the form is in a panel. Cheers

Ok understand that How do i stop it when its in the right place? something like when x = 0?? Cheers

Hi Please could you tell me how I move a form? Cheers

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

Thank you for the quick reply. So would I load my data into a datatable in the loop and the use the sqlBulkCopy to updata the database? Cheers

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

Sorry for the delay I have gone down the route of a Thread and it seems to work quite well. If you would like to see what I came up with let me know and I will post it here. Thank you all.

Anyone?

This is what I have come up with Could it be made better? Private Sub cCheck_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cCheck.Click If CheckNumberFormat(cMobileNumber.Text) Then MsgBox("This is a mobile Number") ElseIf...

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 If your using IIS there is a timeout in there which default is 20 Cheers