P
Pavel Fursov
Hi!
I have installed Access XP and I have some questions to MVP.
There is a differences when form have constructor-filled RecordSource
property and programmatically.
There is no special alignment for numeric and date fields (as a simple
text).
Why this happens and how to get it back?
If I set Recordset property to ADO recordset (SQL-server) and makes
filter/sort operation on a form then I've lost Recordset property. Somebody
check it please. I’ve been reading MSDN article Q281998 ACC2002: How to Bind
Microsoft Access Forms to ADO Recordsets
But somewhere in my code:
Private Sub Form_Unload(Cancel As Integer)
'Close the ADO connection we opened
Dim cn As ADODB.Connection
Set cn = Me.Recordset.ActiveConnection ‘->ERROR MESSAGE HERE
cn.Close
Set cn = Nothing
End Sub
(I’m sorry for bad English)
Thanks,
Pavel Fursov.
I have installed Access XP and I have some questions to MVP.
There is a differences when form have constructor-filled RecordSource
property and programmatically.
There is no special alignment for numeric and date fields (as a simple
text).
Why this happens and how to get it back?
If I set Recordset property to ADO recordset (SQL-server) and makes
filter/sort operation on a form then I've lost Recordset property. Somebody
check it please. I’ve been reading MSDN article Q281998 ACC2002: How to Bind
Microsoft Access Forms to ADO Recordsets
But somewhere in my code:
Private Sub Form_Unload(Cancel As Integer)
'Close the ADO connection we opened
Dim cn As ADODB.Connection
Set cn = Me.Recordset.ActiveConnection ‘->ERROR MESSAGE HERE
cn.Close
Set cn = Nothing
End Sub
(I’m sorry for bad English)
Thanks,
Pavel Fursov.