G
Guest
Dear list,
I have been given the task to migrate a VBA heavy A2k application on W2k to
Vista and Access 2007. I would like to keep the mdb format and the mdw file,
as the application uses 3 main databases and generates various user database
files. When I run the database, I get lots of errors. Some I can place
(FileSearch has gone), but with others I am a bit lost.
I get a lot of Invalid reference to property Form/Object. I now think that
can be traced back to the fact that there is no current record. Could that be
the case?
Even so, if I use the same query as has been given to the RecordSource of
the form/subform, I do get data.
I never get past the exit sub in the next snippet.
Me.RecordSource = strSelect
Dim rs As Recordset
Set rs = Me.RecordsetClone
If rs.EOF Then
Exit Sub 'nothing to display (No record)
End If
strSelect is valid when it is used as the SQL source for a query.
Please help.
Jan
I have been given the task to migrate a VBA heavy A2k application on W2k to
Vista and Access 2007. I would like to keep the mdb format and the mdw file,
as the application uses 3 main databases and generates various user database
files. When I run the database, I get lots of errors. Some I can place
(FileSearch has gone), but with others I am a bit lost.
I get a lot of Invalid reference to property Form/Object. I now think that
can be traced back to the fact that there is no current record. Could that be
the case?
Even so, if I use the same query as has been given to the RecordSource of
the form/subform, I do get data.
I never get past the exit sub in the next snippet.
Me.RecordSource = strSelect
Dim rs As Recordset
Set rs = Me.RecordsetClone
If rs.EOF Then
Exit Sub 'nothing to display (No record)
End If
strSelect is valid when it is used as the SQL source for a query.
Please help.
Jan