And are the set of libraries the same as a regular mdb app? I'm having a hard time locating a MSFlexgrid on a form in .adp. Anyone know any great websites that have tutorials.
Is this another bogus tool that Microsoft tried to push but no one uses?
Printable View
And are the set of libraries the same as a regular mdb app? I'm having a hard time locating a MSFlexgrid on a form in .adp. Anyone know any great websites that have tutorials.
Is this another bogus tool that Microsoft tried to push but no one uses?
I am using MSFLEXGRID on a project with a ADO connection. Though it is not well documented by Microsoft it does seem to work well. However, I do not understand your question. What are you trying to do?
Pretty much figured it out...auto syntax check wasn't working for a MSFlexgrid "msfg90DayQueue" sitting on my form (couldn't see the properties and methods), so I had to code this way:
Public Sub Retrieve90Days()
Dim cmd As ADODB.Connection
Dim rs As ADODB.Recordset
Dim ctrl As MSFlexGridLib.MSFlexGrid 'Create a Grid instance
Set cmd = New ADODB.Connection
With cmd
.ConnectionString = sConn
.Open
End With
Set rs = New ADODB.Recordset
With rs
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.ActiveConnection = cmd
.Open ("EXEC Check_90Days_TransDBOnly")
Set .ActiveConnection = Nothing
Debug.Print .RecordCount
End With
Set ctrl = Me.msfg90DayQueue.Object 'Set a reference to the form grid.
Call PopulateGrid(ctrl, rs) 'Pass the control and recordset to the Subroutine
Set rs = Nothing
Set cmd = Nothing
End Sub