S
Savvoulidis Iordanis
Hello there.
My problem (this time) is that the following code ( just as i write it
below), does not return the same records as if it was a query
dim rs as dao.database
Set rs = CurrentDb.OpenRecordset("select * from print_positions where
report_name = ""rpt_1""")
MsgBox rs.RecordCount ' returns only the 1st record
I tried that directly as a query:
select * from print_positions where report_name = "rpt_1"
and I got all the rows i wanted OK.
Why ?
PS. I use Access 2000 with all the latest office/dao updates, and the
program is linked to the data file
My problem (this time) is that the following code ( just as i write it
below), does not return the same records as if it was a query
dim rs as dao.database
Set rs = CurrentDb.OpenRecordset("select * from print_positions where
report_name = ""rpt_1""")
MsgBox rs.RecordCount ' returns only the 1st record
I tried that directly as a query:
select * from print_positions where report_name = "rpt_1"
and I got all the rows i wanted OK.
Why ?
PS. I use Access 2000 with all the latest office/dao updates, and the
program is linked to the data file