Search results for query: *

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

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

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

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

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

I have a report that has over the maximum limit of rows that can be exported to Excel. Is there a way to create a page break after say row 60k, add another worksheet, and fill the rest of the rows on the second worksheet?

I'm new to Crystal reports. I need to alllow the user to export to excel from the report view. How do I go about adding this feature? Is this something done on the report side or is it a setting on the viewer?

I have a call to a class function, method (whichever name is used, I get mixed up). The call is as follows: Set poCatalogGeoCode = goCatalog.CatalogGeoCode(CStr(Val(lvwCatalogGeocode.SelectedItem.key))) But the definition of CatalogGeocode is as follows: Public Property Get CatalogGeoCode()...

I need to create an listbox with 3 columns. Two of which need to be embedded drop-down listboxes. Where can I fond some info on how this is done?

How can I validate that a txtbox only contains letters?

How can I set a unique ToolTipText for each item in a listbox. I currently have the follwoing code but it sets the toolTipText for all to the last value to run in the loop: Do While Not frmCatalogRequirements.prsFilingFrqSelected.EOF lstAvailableFF.AddItem...

I need to load a 2-D array in one form and access it from another form but I get an error when compiling stating something about it being illeagle to set global array in the declarations section. Got the same thing when I tried to declare it in the global.bas file. Is there any way around this...

I'm getting an Invalid Property Array index errorwhenI try to set the value of a listbox in the click procedure below: (the Sub LoadFilingMethodProfiles works fine but the error is thrown in the lstRtnMthProfile_Click event) Private MethodRulesChecked(4) As Boolean Private Sub...

In the code below I want to display the checkbox as checked or unchecked depending on a value in the recordset. I haven't been able to find how to do this. I've tried "lstRtnMthProfile.Selected (1)" to check them but that throws an error. Do While Not rsMethodProfiles.EOF...

Say I have the following recordset: ProfileName RuleDesc ProductName (These are field names) Soda Open Coke Beer Restricted Corona How could I reference the RuleDesc field for the record with soda as the profileName?

I have the following .sql script creating 2 tables but I'm getting an error stating: "There are no primary or candidate keys in the referenced table 'dbo.FilingMethodProfilesRules' that match the referencing column list in the foreign key 'FK__FilingMet__RuleI__2106348D'." I have the primary...