If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Help wanted!!

Dear Buddies,

Hello, after a long time I entered this forum again.

I have a peculiar question: that is

I have a database with a table called NAME(apart from name field , there are SEx age ,Qlf,Address), there are several names in that Table some are duplicate name(I need these ) with different address,anyway I want MsFlexGrid1 to show the Duplicates I search for.
StrSql1="Select * From table where name like '" & Me.cmbpid.text & "'"
But this Flexgrid shows 1 record only.
I want to see all 4 records saved in there.

Re: Help wanted!!

Dear Friends,
I have succeeded in rectifying the issue ,which I posted before.
The next problem is:
I can not keep the highlighter on to a specific record in MSFlexGrid1, it always jumps to the first Record.
I need the Selected(Highlighted) record for doing changes or you can say make transactions & update that particular Record.
This is now Highlighting the Specific Record, but I can not use that record for editing or doing any transactions. If the Record is single & unique (No other similar Items present) then That record gets modified etc,but if Multiple items with same name are in the Database, then only the first one gets modified, How to lock the Record which I click by mouse in MSflexGrid1?