I'm having trouble using this clause. If I don't have it in the beginning 

of my page everything works "fine", I mean, I get the default error 

message when I deliberately cause an error. But the minute I add it to my 

page and I have a line that should output the errornumber and a message 

that I've written, the browser just keeps on loading the page when I 

submit the queries. The error message I get by default is "Either EOF or 

BOF is true...etc", so this means I don't have any records in one of my 

recordsets. But despite this I would like to output all the other 

recordsets that I've gotten. But since this error occurs first, I can't 

get the result I wanted. How can I resolve this?

Write an IF/THEN condition that tests for the BOF or EOF.  If it is 

true

then on error move next, else do nothing.  THis should work.



Roger



-----Original Message-----

From: Olga M=F6ller [mailto:olga_moller@h...]

Sent: Thursday, September 27, 2001 1:33 AM

To: Access ASP

Subject: [access_asp] on error resume next





I'm having trouble using this clause. If I don't have it in the 

beginning

of my page everything works "fine", I mean, I get the default error

message when I deliberately cause an error. But the minute I add it to 

my

page and I have a line that should output the errornumber and a message 



that I've written, the browser just keeps on loading the page when I

submit the queries. The error message I get by default is "Either EOF 

or

BOF is true...etc", so this means I don't have any records in one of my 



recordsets. But despite this I would like to output all the other

recordsets that I've gotten. But since this error occurs first, I can't 



get the result I wanted. How can I resolve this?




$subst('Email.Unsub')