thank you I'll give it a go xx

Kris MCP

Hi folks I've searched high and low can anyone inform me if sql server express 2008 is compatible with visual studio 2005 professional? Thanking you x

Kris MCP

Hi one thing I've found really useful is to not use words such as Date, Time, etc the VB uses, can muck up your code big time, as I've found out. Apart from that use variables that you will understand when looking at code 6mths down the line. I agree with alot that I use things like strBookings if a string for example. Good luck x :)

Kris MCP

Thanks alot for that! Good idea. Kris :-D

Kris MCP

www.ktechprogramming.co.uk

Hi Mike Thanks alot for getting back to me. I've managed to work it by moving through the BindingSource once the linklabel's Click event is raised. Whilst we're advertising I'd love some comments on my website, from an expert of cause. Thanks again for your help :-D www.ktechprogramming.co.uk Kris

Kris MCP

Hi Mike Sorry for the delay had one of those days! Thanks for replying but I'm now totally confused. :confused: I've read your article and also read up on Instances withing VS 2005. However, there seems to be numerous types, ie, constructor, Property, Method etc. Please can you offer a little more advise. Yes, I am newly qualified hence being lost. Thanks alot Kris :-D

Kris MCP

Hi Folks Please excuse me if this is an incredible ingnorant question. :confused: I've got 2 linklabels, Next and Previous. I'm using these to move through the images saved in my dataset. However, looking up Linklabels in help you should be able to do something like LinkLabel1.Link.LinkData in order to set the Data Source. However I'm not getting this option after Link. All I'm getting is Link.Equals or Link.ReferenceEquals? Can anyone help please? Thanks alot :-D

Kris MCP

Hi Guffa Thanks alot for your help. All sorted. :-D

Kris MCP

Hi Guff Thanks alot for your help. Still have a problem that it's not moving through each row of the table. I know it's something really stupid I'm missing but getting annoyed with my self. Code is now Dim CurrentDate As Date Dim ReminderDate As Date Dim InvoiceDate As Date Dim msgbxReminder As MsgBoxResult CurrentDate = Date.Now.Date For Each dr As DataRow In Me.DachelDataSet.Invoices.Rows If dr("Cleared") Is System.Convert.DBNull Then InvoiceDate = Me.DachelDataSet.Invoices.Rows(Me.InvoicesBindingSource.Position).Item("InvoiceDate") ReminderDate = DateAdd(DateInterval.Month, 1, InvoiceDate) If ReminderDate <= CurrentDate Then msgbxReminder = MsgBox("The Invoice for" & " " & CurrentClient & " " & "which is Invoice Number " & " " & CurrentInvoiceID & " " & "is 1 month overdue.") End If End If Next Thanks Alot:confused:

Kris MCP

Hi Luc Sorry getting tired but got to get the contract done. You say use greater equals? Do you mean >=? No InvoiceDate is definately not the same, although it can be. Thanks for your help. :confused:

Kris MCP

Hi Luc, Thanks for that, I can see what you're saying. By having the reminder date outside the ForEach loop, it's not being read on each loop. I've changed the code to For Each dr As DataRow In Me.DachelDataSet.Invoices.Rows ReminderDate = DateAdd(DateInterval.Month, 1, InvoiceDate) If dr("Cleared") Is System.Convert.DBNull And ReminderDate = DateAdd(DateInterval.Month, 1, InvoiceDate) Then If CurrentDate <> ReminderDate Then Else msgbxReminder = MsgBox("The Invoice for" & " " & CurrentClient & " " & "which is Invoice Number " & " " & CurrentInvoiceID & " " & "is 1 month overdue.") End If End If Next End Sub However, still getting stuck on 2nd row of table. Have I misunderstood something? :~ Thanks alot

Kris MCP

Hi Hope you can help. I've got data saved in SQL DataTable in 1 column is the date an invoice was sent. 2nd column is a Bit(Boolean). This tells me whether the invoice has been paid. I want to work it so that on form load, a msgbox tells the User to send a reminder for a particular invoice. The code I'm using works fine for 1st 2 rows and then misses out all other rows. Any ideas please? :confused: Dim CurrentDate As Date Dim ReminderDate As Date Dim InvoiceDate As Date Dim msgbxReminder As MsgBoxResult CurrentDate = Date.Now.Date InvoiceDate = Me.DachelDataSet.Invoices.Rows(Me.InvoicesBindingSource.Position).Item("InvoiceDate") ReminderDate = DateAdd(DateInterval.Month, 1, InvoiceDate) For Each dr As DataRow In Me.DachelDataSet.Invoices.Rows If dr("Cleared") Is System.Convert.DBNull Then If CurrentDate = ReminderDate Then msgbxReminder = MsgBox("The Invoice for" & " " & CurrentClient & " " & "which is Invoice Number " & " " & CurrentInvoiceID & " " & "is 1 month overdue.") End If End If Next Thanks all ;)

Kris MCP

Thanks for that, I'll do that. Sorry for the late reply, been in meeting all day.

Kris MCP

Hi folks Hope you can give me a hint, I've spent 3 days trying to sort this out! Working in visual studio 2005 proff, with .net framework 3.5. Application has got various forms that are children of a parent. All are loading, adding, saving and deleting fine. Apart from one. I've tried an insert and made it a scaler. I've tried all sorts and just cannot get this to save. It will do MemberID (Primary key) ClientsMare, and clientsid(fk) but clientsname, maresname, percentage no go Here's the Public Sub for Saving. Public Sub SaveMember() Adding = False Deleting = False lblMemberID.Text = CurrentMemberID Me.SyndicateMembersBindingSource.EndEdit(); Me.SyndicateMembersTableAdapter.InsertMember(CurrentSyndicateID, MaresName, CurrentMareID, CurrentPercentage, CurrentClient) Me.SyndicateMembersTableAdapter.Update(Me.DachelDataSet.Tables("SyndicateMembers")) Welcome.btnSave.Enabled = False 'ONCE FINISHED NEED TO MAKE THIS FILL TO A FILLBYSYNDICATEID Me.SyndicateMembersTableAdapter.FillByMember(Me.DachelDataSet.SyndicateMembers, CurrentMemberID) Welcome.btnAdd.Enabled = True End Sub any ideas why I'm having this prob on just one form? Thanks:mad::confused:

Kris MCP

Hi There shouldn't be. I've been into the Windows Firewall and put all SQL to be allowed under exceptions. :confused:

Kris MCP

Hi Still no go I'm afraid. I went to IP Addresses and checked all enabled. I've kept it so I can enable Dynamic ports as a little unsure of this. :-\

Kris MCP

Hi Folks I wonder if anyone has any ideas that could help me. I've written an application in VS 2005. I use Inno Setup for Installation, which I have used previously with success. When I go to install the program on another machine I get the following error An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I've checked my Sql Area Configuration and can confirm that I allow remote connections although via using TCP/IP only and have also tried TCP/IP and named pipes. I've checked the SQL Browser and this is also running. I've checked my Connection strings and these are fine. Can someone help please? Thanks alot.:confused:

Kris MCP

Thanks Christian I'll give it a go. Kris MCP

Kris MCP

Hi I wonder if anyone could possibly help me before I tear my hair out. I written an application in vb.net 2008 express. I'm using InnoSetUp to install it. Withing the set up file I've got links to the .net framework 3.5 install and the SQL Server 2005 install. Installing on my Vista lap top, which I wrote it on, no probs. As soon as I install on my Pc, XP then I get an error stating that there is already a database of that name or this one is installed elsewhere. I've checked security permissions before install (on Vista) and ensured that users have full permission. However, once on XP machine, users only have Read Only access to my database. Any ideas how I can stop vista changing the permissions so that clients can alter data in database. Thank you very much Kris MCP :mad:

Hi I hate to tell you but installing .net 3.5 doesn't help. I'm having the same problem. I've written my program on a vista machine, using vb 2005 and Inno step to install. Like you I've copied over all relevant files etc for install. Works fine on Vista machines but, is using .net 3.5 automatically to compile even though I'm installin .net 2.0. Apparently, Vista automatically updated to .net 3.5 in an upgrade. What I'm trying to find out is how I can overrun 3.5 and tell the computer to use 2.0? Complicated, just so you know you're not on your own.:confused:

Kris MCP