Search results for query: *

Removing email notification

I have been asked to create a DBGrid which has a third column which has comboboxes for all but the last row. The last row is to have a testbox like cell where the user can enter freeform text. Is this possible? If so, how can it be done?

I have a DBGrid that has 5 rows and 5 columns. How can I retrieve (Get) the value that is held in the 5th row 5th column?

I forgot to add the CommitTrans statement in one of my classes in vb6. Now I get the error "cannot start more transactions on this server". How can I go in and end the transactions and get rid of this error? I assume that not using the CommitTrans statement is the reason for the error, if not...

Ok, I found the answer. I have my DBGrid in Bound Mode and it's bound to a recordset. The DBGrid makes the changes to the recordset without me needing to write any code. The reason I wasn't seeing any changes was that I never wrote those changes to th database and I was querying the original...

I have a DBGrid I make changes to the cell then refresh but the data doesn't update in the recordset. I'm new to DBGrids so please excuse my ignorance. I am also reading a book that just isn't all that good.

I have a 3 column TDBGrid with the last column being a combobox with only "Yes" and "No" values. Only one row in the grid can have the value yes at one time. I need to figure out how to change the value of the combo box that had the original "yes" value to "no" once the user selects "yes" on...

Can someone give me an answer to this question from my BA: I don’t understand. I can copy 10,000 records and paste them fairly quickly so why would it take that long to export? I know I’m simplifying the issue but could you go into more detail.

I totally understand that sending this to Excel isn't a good idea. But I have Business Analysts asking for it. The really bad part is that the majority of the records are useless with many null values except for some ID fields. I have recommended allowing some sort of dialog to prompt the user...

I am trying to export over 10,000 records to excel using the following code. It runs fine when I have a normal amount of records but when I run the sproc the way it is to run live (over 10,000 records) the program locks up. Is there a maximum number of records that a recordset can hold? Is there...

thanks

I have the following query which I need to sort by "NextAppDate" ASC and then by rtnCode ASC but I need the records with a null value in the NextAppDate field to be returned after the records with values in the NextAppDate field. How can I adjustthe following query to do this? SELECT...

how do I go about change to the other version before exporting?

Version 8.0.1.0

Version 8.0.1.0

I have a field inside a report that is formatted in the following way: [Add1] [Add2] [City][State][Zip] This is fine for the report. But when it is exported I need to format it like this:[Add1][Add2][City][State][Zip] with each field...

I found the answer. I had to go to File|Summary Info and enter in a title in the dialog box.

I am getting an error when I export to an excel file stating that the name of the file is invalid. The default name given always starts with "~". How can I set the name of the excel file during an export to excel without the "~" at the front of the excel filename?

Because they want it to...haha.

Have you tried clicking the field to be filtered then clicking on the "Select Expert" icon (or Report/Select Expert) then entering your filtering criteria?