Recent content by nells1

Hi All I have been developing my VB.Net application for some time now and it has finally gone into live testing (hurrah!!). However.. When the users go to preview one of my crystal reports (created using the inbuilt crystal reports designer, and viewed using the CrystalReportViewer on a form)...

Hey JohnD Having a few problems thinking of a way to get the control to you. Shall I just post the VB code here?? I should warn you, this is my first ever control, so its proably nowhere near perfect, but it seems to do the trick for me [thumbsup2] Nells

Hey JohnD Yeah thats what I ended up with too.. I eventually wrote my own control that does it (as well as the auto complete fuctionality) so I didn't have to repeat the code for each combo box. Seems to work ok.. if you want a copy let me know. Thanks for getting back to me [thumbsup] Nells

Hey JohnD Finally!! I've found a post that mentions the problem I'm having. I guess its because people bind to the SelectedValue property more than the Text property. Did you find a solution to this by any chance? Its driving me slowly insane [bugeyed] Cheers Nells

Hi Tim Did a wee search on the web for you and found this article: http://weblogs.asp.net/duncanma/archive/2004/05/13/130976.aspx That suggests one solution, there are probably a few more.. Unfortunatly I'm also quite new to VB.Net so I can't actually give you an answer, but I've found that...

Yes you're right, that may be my only option. Is that how you get your many to many joins to work? I would have thought there would be a better way to handle it since these types of joins are very common. Creating a view will work for me and will do for my current project. I'll keep...

Hi RiverGuy Thanks for your reply. I have my two DataRelations set up as follows... MyDataset.Relations.Add("Job_JobContact", _ MyDataset.Tables("Jobs").Columns("JobID"), _ MyDataset.Tables("JobContacts").Columns("JobID")) MyDataset.Relations.Add("Contact_JobContact", _...

Hello I have a system as follows (please excuse the poor diagram): Sites 1-----------m Contacts 1 1 | | | | m m Jobs 1------------m JobContacts Where JobContacts is a Join Table. Now my problem is that on my...

Hi My VB.NET application fills it's dataset out of a SQL Server database. I know that the Default Values from the database do not copy across to the dataset so I have started looking for other ways to do this. I have found that the default values are stored in the SQL Server System Tables...

Problem solved!! The size changes were the result of the AutoScaleBaseSize setting and the fact that my test machine had a setting of 120dpi and my development machine was set at 96dpi.. You learn something new every day.

Hi All First time VB.NET developer here - and it shows <blush> I've taken a lot of care to set my anchor and dock properties so that the controls on my forms are Centered and Sized correctly. My Login form fits 800X600 and any resolution after that. It is just a box with the username and...

Thanks for your time on this Christiaan.. I'm pleased to see you weren't horrified by the set up of the project :o) And thank you for the Luck as well I'm sure I'm going to need every bit of it :o) I think I'll just run the query back on the server and if it starts to jam up I'll look for...

Hi RiverGuy and Christiaan Thanks for the insight, its seems there is no easy answer. Yes I am trying to do something that Sql Server should be doing. This is because I'm making this application for a small company that can't afford the full blown Sql Server, so is using MSDE instead.. I...

Hi All I am creating a search builder for my VB.Net database application. The search builder currently produces a SQL statement using Inner Joins like: SELECT Customers.* FROM Customers INNER JOIN Jobs ON Customers.CustomerID = Jobs.CustomerID WHERE Customers.CustomerName Like...

Problem solved! Its a little bit of a mystery to me what was going on here.. but I created a new report where the datasource read directly off the database, played with the links I'd set up so it showed me the correct information, played with the links back in my original report.. and it works...