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

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

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

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

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

Hi All I'm BRAND new to Crystal so I apologise for this question. :o) How to you go about showing parent information on your reports?? My report is based on a table in my dataset "Jobs". Jobs has a CustomerID that links it to "Customers" (also a table in my dataset). I want to show the...

Hi All I have a simple system. Tables: (Fields) Accounts (AccountNumber, AccountName) SalesFigures (ID, AccountNumber, Year, Month, Value) Months (MonthID, ShortName, LongName) Reports: SalesFiguresForAccounts The SalesFiguresForAccounts report is based on Accounts with a chart that has...

Hi All I'm positive this has to be a very simple thing to do. I'm very new to vb.net and I'm having a bit of fun with binding at the moment. Take the standard Customers/Contacts relationship. There is a form for each entity but on the contacts form I want to show the name of the customer. I...

Hi all I'm very new to vb.net and ADO.net. I am trying to connect to a mysql database.. i've managed that :D Now I'm working on the Update, Delete and Insert commands. I don't want to hard code the parameters for these commands as in all the examples i can find.. ie...

I have a rather large database with the majority of code behind the forms. Quite a few months ago, breakpoints stopped triggering in the form code. Since then I have imported all the forms into a new database and the breakpoints trigger. The 'Stop' keyword is ignored also. This is not a...