Eleventeen

It doesent sound like your problem lies with multiple datasets. If your getting an error of "Value cannot be null. Parameter name: s" then you need to check the data your sending to the report. It sounds like you set the parameter to require a value. Thats why your getting the error.

I have done a few reports with parameters so I can help you. Post some code on how you are sending the parameter. Or if you can, the project files and I could have a look at what its doing.

The best way to do that would be to set your column width to 0 by doing that it has the same effect as hiding it.

Secondly you need to specify what fields you are deleting from the delete query. You need to have "DELETE fieldname FROM....." to delete the field data. Or from what i can see you want to delete the whole record so it should be "DELETE * FROM ....." Hope that helps

Look into using a datareader. dim cmd as new OleDbCommand("sql code", connectionstring) dim dr as oleDbDataReader dr = cmd.ExecuteReader if dr.HasRows = true then 'do function for when there is rows Else 'do function for when there isnt rows end if

The reson why I have to do this is the user needs to be able to copy an existing record and change a few minor details at a later time. It will rarely happen but they need that functionality. I dont like it either. So I got the data into a dataset and i have it where it changed the field that has to be changed. But where I am having trouble now is the update. Since I am updating the same table and the dataset is set for the old record, will it automatically insert the new record? Thanks

Hello, I have a table with over 100 fields. What I need to do right now is have a function that will copy an existing record into the same table. Only one field will change which is the primary key. Is there a way to copy to a record with out selecting all the contents into a dataset and then reinserting the values. Thanks for any input.

Set your Access reference and create your access.application object. There is a method called DoCmd. Im not too familiar with syntax but if you need a quick example i can give you one when I get home. Let me know

You need to download and include the Crystal Reports Merge Modules for .NET. Read this to clerify. http://support.crystaldecisions.com/communityCS/TechnicalPapers/crnet_deployment.pdf.asp

I have a datagrid with 7 columns. Each of those columns has a format of "$###,###,###". Loading data into the grid works perfectly. If you overwrite the text in a cell with a new number everything works fine. But if you edit an existing number in the cell ie. change $400 to $500 by replacing the 4 it doesent accept the change and it would go back to the original value of $400 I have stepped through and put breakpoints to see in the code where its changing and it appears that the datagrid is changing it cause the value in the breakpoint is the original value again. If anyone has had this problem or know what is happening your help is much appreciated.

I kind of had the same problem you did. I had data bein cut off on the right and bottom sides. Even though it was all fine on the CRV. I finally fixed it by reducing the page margins of the report. Your case it sounds like you need to increase them. I think the page margins may be your problem. Let me know.

Im not too sure if this will do the trick but what you could do is in the crystal reports designer you can set the page margins by right clicking on the report and find Page Setup I believe. To get it to the exact measurements may require some trial and error. Thats what I had to do for mine. Hope that helps

How do you change the background of the current cell that the user is in. What I need is when the user is in edit mode of a cell the background colour of the text box to be yellow and when the user leaves that cell go back to the original colour. I had this working once before and for some reason the code for is gone. Any help is much appreciated Thanks

Does anyone know why there is an error everytime with a Listbox calling form.dispose() ?? I have tried this in different projects and they produce the same error : Cannot access a disposed object named "ListBox" I stepped through code and there appears to be nothing calling it at all.

I have two forms with a lot of controls on them. For the most part they are identicle but there are many differences that I needed to have both as seperate forms. I have already written the code for the first form and not the second. Since they are the same controls with the same functionality I wanted to use the same code. When I send the Form reference to the class with the code it works when i declare the form as : frmFormA as frmMyForm and then pass that form reference to it. But when I want to use a general declaration like : frmForm as Form to use with both forms it gives me an error saying that the objects do not exist. Any thoughts or suggestions is greatly appreciated.