By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,899 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,899 IT Pros & Developers. It's quick & easy.

Error # 3091 in VBA, No current record found

P: 1
I noticed that when SQL statement does not return a record then null string causes the Err # 3091. First we have to handle this error and then suggest accordingly.like ....

function()
on error goto xErr
sql statement......
.............
.......
xErr:
if err.number=3091 then
resume next
your code when sql statement...... fails to return.
end if
end function

Thnx
Dec 4 '14 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.