Recent content by tansc81

Hi, I'm sorry for not being able to response early.. ccoz i'm busy with other project.. so sorry...

Can someone tell me wat does this meant? wat is the array(emtpy, empty, relation use for? Set rstSrc = conn.OpenSchema(adSchemaColumns, Array(Empty, Empty, relation)) If i want to extract the schema for a particluar column of a relation, how do i do it?

how can i merge row together? I tried to use the .MergeCells = flexMergeRestrictRows in design mode, but i still cant make it work...Why is this so? i've also added these in the code grdFD.MergeCol(1) = True grd2ndLevel.MergeRow(1) = True grd1stLevel.MergeRow(2) = True

hi MichaelRed, u got ur point too... Thanks very much!

In my opinion i believe it best to use the smallest data type.. it's ok for small Database.. but how abt big database? there will be too much unused space...

Hi, i've found the solution to my question, thanks to those who had help me! Public Function suggestType(ByVal relation As String, ByVal column As String) As String Dim recType As New ADODB.Recordset Dim sqlString, suggestString, s As String Dim counter(0 To 17), i, recCount...

sorry i have another question I have a SStab with 3 tabs.. on the 2nd tab there is a MSflexGrid, which i can select by rows only. With i try to go to other tab and come back to the 2nd tab, the selected row in the MSflexGrid is not hightlighted, even thought grd1stLevel.RowSel have some value...

Thanks a lot!! argh.... such a small bug!!

Beacause i'm trying to find the best suitable type for the data in the database and not just chuncking everything in string n numeric

hm... but i've come across application tat allow user to calculate the functional dependency. I suspect it similar to data mining 1Rule (1R) algorithm. Have anyone hear of it b4? Can someone pls explain... i've read on this algorithm but still have some doubt abt it

I've already had these 2 statement in my code but it jsut didnt want to hightlight the first cloumn. The focus rect is on it but it' not hightlight!!

hey thanks for ur reply.. it works very well... but jsut another question. why i cant hightlight the whoel row? the first cloumn of the row is not hightlighted?

would like to calculate the frequency of the type of value from a recordset. i want to check if the values of a columns from a table is if correct type. For example a column in a table might be defined as of type string, but in reality the data in that columns are all integer.. so i will return...

How can i select only 1 row of the data in the Ms FlexGrid. the user is only allow to select 1 row at a time.. he cant drag the whole area

Anyone have any idea how can i computing the functional Dependency of a Access Table???? For example in the table of employee table.. most fields should be dependent on the primary key... For example, in my table there are fields like, personId, Name, Surname, age, date of birth,Area code...