Anyone Using Access Projects

[rplcmint]

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?

[MIKEADKINS]

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?

[rplcmint]

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