Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by elmi
-
ComboBox in side of a DataGrid
I don't think that DataGrid supports comboboxes inside it. I suppose you are using your table in Access Datasheet. You could make a special form consisting of another DataGrid that could be programmatically customized for displaying your combobox data by e.g. double clicking the specified column...- elmi
- Post #2
- Forum: Visual Basic (Classic)
-
RecordCount Property
Have you set the CursorLocation Property to 'adUseClient'? I think a client side cursor for the recordset supports RecordCount. Let me know about the result.- elmi
- Post #2
- Forum: Visual Basic (Classic)
-
Need To Generate AutoNumbers
The datatype should be integer. Because you want to get the Max value yourself. For the first record in your table you can handle the problem like this: .. rs.Open "Select Max(Count) From Table1" ,cn1 If isnull(rs(0)) then NewNumber = 1 Else NewNumber = rs(0)+1 End If- elmi
- Post #4
- Forum: Visual Basic (Classic)
