Search results for query: *

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

Hi again Paulmarr The Report is based on a Dataset, though. The dataset has the valid relationships and everything is showing up correctly on the forms. Have I got things completely wrong and need to do something different? I wouldn't be suprised :o)

Yes it would seem so :o) Point definitely noted! I'm still having a wee problem but have put it under a new thread as it is no longer valid under this post. Would you mind taking a look at thread766-864557 just incase you have any ideas :o) Thank you very much nells

Hi My report is based on a few related tables in a dataset schema. The report shows the details of a "Job". However it also needs to link to two other tables "Customers" (to get the customer name) and "Status" (to get the status name). So I have set up these links in the Visual Linking...

Problem solved!! I was having a wee play around and it seems that the auto link was putting the link in the wrong direction?!?!?! When I re-linked it the other way BINGO. Thank you for your time, I've been trying to figure this out for ages <blush> nells

Sorry Paulmarr I forgot to mention that the error appears at runtime before the report is displayed in the viewer on my Windows form. The report is never displayed after the error. :)