Search:

How the input is given?
from Database? User interface??

in your query first part Distinct you have not selected field standard_phr_id .

I didn't know that! Thanks

Instead


String dbQuery = "SELECT alumni_Name FROM AlumniMembers WHERE alumni_Name
LIKE '*" + name + "*'";


use

I Agree DataMiser, the same code can be modified as below:


Private Sub SetBackColor(FlexGrid As MSHFlexGrid, RowNo As Integer, BkColor As ColorConstants)
With FlexGrid
If RowNo >=...

check the following link

http://msdn.microsoft.com/en-us/library/7tas5c80.aspx

Post the query you have written for finding the rank, there will always room for fine tuning!!

As mentioned by DataMiser, you can change the background color of a cell and the row. If you want to change all the cells of a particular row, you have to loop through all the columns.

Below code...

In your code you should have one connection each to the databases. Either you can use the method given by Wof or you can open two different recordset for each database and use
RS.Find method to...

Same question in http://www.codeguru.com/forum/showthread.php?t=494065

I doubt about from Higher version to lower version compatibility!

RichTextBox1.selText="<---Replacing Text ------>"

Are you Using Any thirdparty OCX or DLL in your application?

As in your question Refer to 'D:\New Folder\VB\HR\MDI.log Open this file with notepad, you can check which control is giving problem....

Are you Using Any thirdparty OCX or DLL in your application?

As in your question Refer to 'D:\New Folder\VB\HR\MDI.log Open this file with notepad, you can check which control is giving problem....

If your problem is solved, mark this thread as [Resolved]

Yes, Datamiser I understood it wronly.

The following Code may be useful, I have added one more invisible richtextbox to the same form.
Logic is when user clicks button, first richtextbox lost...

To Read the File


Richtextbox.LoadFile(FileName,FileType)
' File Type = 1(rtfText) = Text file
' File Type =2(rtfRTF) = RTF File



To Save the File

Which database you are using? What is the source of resultset?

First of all you should try to write some code, based on your requirement and if you get struck in between , there are many gurus in this forum to guide.



Private Sub...

Using a variable is better option instead of textbox. Why do you want something like that?

in any case if you dont want to display the value in textbox ,eventhough textbox is visible then

try...

you could have checked in FAQ before starting thread, the following link is provided
http://www.codeguru.com/vb/gen/vb_gr...cle.php/c6743/ :)

If you got what you were looking for,mark this thread as resolved.

Private Sub Command1_Click()
If text1.Text = "" Then
MsgBox ("You have no content on your 1st Transformation Matrix")
Exit Sub '<-- Required here

Else
'Exit Sub <--- Not required, here you...

In that case you can use loop to save data row by row.



For RowNo = 1 to MSFlexGrid1.rows-1
'... Saving code (note: Use RowNo variable instead of currow1,currow2 ...

Next RowNo

in addition to vb5prgrmr's explanation. You can also use MID$ Function to replace a specific location character with Another.




Dim TmpStr as string
tmpstr = "BAT"
MID$(TmpStr,2,1)="U" '...