Search results for query: *

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

Hi If you use a database to login in with then when you check details you could have a new field Called InHouse and set this to true or false. then once they login set a session("InHouse") = True. On the page you need to keep away from others have some thing like If not (Session("InHouse"))...

Hi Wow so many replies. If some one has any time could they explain what threading is and the difference to a service. Is Gorkem saying this? I have a seperate Class file that does all the email sending and looping through the database and then returns the results to a session? // Class...

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 Put a lable on the form. In form load place the below code Label1.text = "Hello world!" Cheers

Hi Im not sure your select is going to work as you are looking for a firstname and a surname = to cboclient.Text Are you trying to populate a combo box from a database and combining the firstname and surname? If so this should work Dim myString as string myString = "Select firstname & " "...