Search results for query: *

Hi, What is the maximum amount of fields I can create in a cursor use the CREATE CURSOR command? I need about 400 fields if that is possible. Thanks, Razzle

Thanks Mike! That worked.

Hi, Is there any way to advance the cursor to the next line in a datagrid after the user has left the last field from the current line they are entering in? Currently the cursor just goes to the first field in the same line that they are in. It just adds an extra step for the user...

Hi, How can you mask a column in a DataGridView to handle dates? Can it be done the MaskEditTextbox control can do it? Thanks, Razzle

Thanks for the response, I was able to fix it with this... txtnotes.Text = txtnotes.Text.Replace(vbCr, Environment.NewLine) However, I was curious as to why the text is being returned from MS Word this way. Razzle

Hi, I have a VB windows form using VS2005 that calls the MS Word object to spell check a multiline textbox on my form. The spell check works fine, however after the text is returned back to the textbox it combines all the paragraphs together and displays a carriage return character...

Madawc, no it is not essential that I use a subreport. As a matter of fact, after reading your post I created a new report with 2 detail bands and made them each 1 full sheet in size and then in the format section put a page eject after each detail band and that works. That was all I needed to...

Ido, I have tried using a sub report. But what happens is that it prints all the pages of the sub report and then it prints all the pages of the main report (or in reverse order depending on if you want the sub report to print first or last). Can you insert a subreport in a way that it will...

Hi, How would I create a CR that is 2 pages for each record. For example, I have a medical form that is 2 pages long per individual. At the moment I have created 2 seperate reports, 1 for each page. And I then print them seperately. But it would be better if I could create 1 report that...

Hi, I have never had trouble passing values to Crystal Reports in the past, however for some reason none of my code that passes parameter values to Crystal Reports is working anymore. The only difference in my applications is that I recently converted them to VS2005 from VS2003. But I do...

Thanks LB, that is what I'm looking for.

LB, I would rather not create a field in the detail band and then create a sum from that because once you delete the field from the detail band you cannot ever change the expression without recreating another field in the detail band. Can it be done with a formula field instead? How would you...

Hi, I need to create a report that has just 1 field in the summary band of the report (or report footer) that is a sum based on an expression like IIF(MyTable.MyField = True, 1, 0). There is no detail band,group band or and other fields. Just a summary field at the end of the report...

Thanks Rick, that worked! Jbenson, I cannot sort the records from a SQL select statement for this application. Once I pull the records from SQL server, the dataset table is changed from adding/updating/deleting records before its the passed to Crystal Reports. Razzle

Hi, Is there any way to sort a dataset table in code so that your Crystal Report will recognize the sort order. I realize that you can group the data in CR but this will not work for this report. I need it sorted in code before it is passed to CR. Or if this cannot be done can you sort...

Hi, Can we expect to see a VFP 10 or 64bit version of VFP? Just curious on all of your thoughts. Thanks, Razzle

Disregard this post. I have the solution. The code file has the unique key and needed to be the parent column in the relation.

Hi, How do you create a many-to-one or one-to-many relationship in a dataset. I have this code ' Get the DataColumn objects from two DataTable objects in a DataSet. Dim parentCol As DataColumn Dim childCol As DataColumn ' Code to get the DataSet columns...

Hi, Is there any type of command window that you can enter code like this.. Math.Round(3.45, 1) and then have it show the result like... Returns 3.4. Just wondering. Because this would allow me to test my code before I apply it to my application. Other wise I have to code it in my...

Make sure you do not have a cdoex.dll file in use. I have run into problems like this when the cdoex.dll file is registered. The cdoex.dll supersedes the cdosys.dll file for some reason. So anyone having problems getting the cdosys.dll to register it could be because you have the cdoex.dll...