I'm using Visual Basic 6.0 Enterprsise Edition
I have Two queries TankerExpQuery and TankerExpTotalQuery in Access 2000 database both queries both are built from the Invoice table and are joined with invdate
the fiels in TankerExpTotalQuery are Grouped By InvDate
When i used rst.Fields(0).Name
It gives me a field name but if i use
it gives me a error message
Rum-time error '3021'
Either BOF or EOF is true, or the current record has been deleted;
the operation requested by the application requires a current record;
When i run this query in Access 2000 it works fine.
If I check MsgBox rst.EOF and MsgBox rst.BOF both messages shows me true
If someone has any idea about this error i would really appreciate it
thanks in advance.