Search:

I solved the problem by changing the SelectionChangeCommitted to SelectedIndexChanged and pre-loading the classes when the app starts. That way, it doesn't have to make a call to the database every...

I can't use the SelectedIndexChanged event. I need the 2nd combobox to load when the first is selected. The user can press a button while focus is on the first combobox to skip to a particular...

I have 3 comboboxes (ex. State, County, City). I have code in the Combobox_SelectionChangeCommitted function to load the child combobox when the Parent is selected. If there's only 1 item loaded...

The dll project that I need is in a solution with many other projects and I can't bring in just the one I need without getting the rest. Then there's issues with services and such that I don't...

Is there an easy way to display the Line Number of where an error occurred? I'm debugging an application, but I can't run the app in the environment. I build the dll and use the dll in another...

I'm loading my DataGridView with 10 rows. 5 of those rows fit on the screen without having to scroll. The verticla scrollbar will scroll enough to see the 6th row, but will not scroll to view the...

It worked! Thanks! :)

I load a Combobox with the following code:



Public colCustomers As List(Of Customers) = Nothing

Public Sub LoadCustomers(ByVal cbx As ComboBox)

If colCustomers Is Nothing...

Can the TrueValue and FalseValue for a checkbox column in a DataGridView be set in code rather than in the control properties? And without using code to add the column to the DGV? And then how to I...

I want to merge a header cell in my DataGridView and add a second header row, like you can do in Excel. Is there an easy way to do it?

Like this:


...

I have an application that has been working in a Production environment for a few years now. I need to make some tweaks to it and I'm at the testing phase and all of a sudden, I'm getting a...

I query the database using ADO and pass the recordset to Crystal Reports. I need to close the recordset before exiting the function, but when I do, the report is blank (as if it wasn't done...

I'm using CR 8.5 with RDC and ADO, and SQL Server 2005. The pictures are .jpg's and are stored in an Image type column in a Picture table. I'm using ADO within VB to pull back a list of pictures...

Are tehre any known issues with using RDO with SQL Server 2005?

My company is in the process of updated our SQL Server 7 database to SQL Server 2005. Most of our applications are several years...

I'm in the process of testing the new SQL Server 2005 database with applications that are currently running against SQL Server 7. I have the following code (using RDO, rs = Recordset, qy = Query):
...

I'm using Crystal Reports 8.5 using RDC. I have several reports in my program, some are Portrait orientation, others are Landscape. This program is distributed to about 20 different computers.
...

Just replace the x's with the correct values of the Error Codes (which you will have to look up somewhere). If you declare them in the same code module as your function, you can leave them Private...

Make sure you use Option Explicit at the top of all your code modules. This forces you to declare all variables and will error if you have a variable that hasn't been declared. If E.Hyde is correct...

1.35307692307692E-02 is the same as 0.0135307692307692

The E-02 is scientific notation. The number after the E tells how many places to move the decimal and which direction to move it in. In...

I didn't know about the built in function. I also don't use VBA. It might just be a VBA thing?

Just change the name of the function to OpenADORecordset or something else. It can be called whatever you want.

To reproduce the problem, open a new project, add a Command Button and a Checkbox. Copy and paste the checkbox and click Yes when it asks if you want to create a control array. Paste all the code...

Do a search for disconnected recordset. This will allow you to query the database, close the connection, and still be able to read the recordset. Here is function I use:




Dim rsData As...

Thanks vb_the_best, but that won't work for me. I have a class that gets passed a form. The class interates through each control on the form and creates a new class for each control that can be...

1. Create a class (called ServerClass or something like that) to store the data from the XML.


Option Explicit

Public ServerLocation As String
Public ServerInfo1 As String
Public...