IsQueryTable suddently don't work

[JensT]

Hi

I have used the isquerytable function mentioned elsewhere for a few of
my databases. And there has never been a problem - but suddently the
code stops at:

test = db.TableDefs(TName).Name

with the fault:runtime error 3265 - the element was not found in this
collection. - and it does that with all my databases using the function
- although they used to work perfectly.

Does anyone know what can be wrong?

TIA
Jens

[deluxeinformation]

JensT wrote:

Hi

I have used the isquerytable function mentioned elsewhere for a few of
my databases. And there has never been a problem - but suddently the
code stops at:

test = db.TableDefs(TName).Name

with the fault:runtime error 3265 - the element was not found in this
collection. - and it does that with all my databases using the function
- although they used to work perfectly.

Does anyone know what can be wrong?

TIA
Jens

I suspect that your code relies on triggering a handled error to work.
Either from the VBA window menu or in code you've turned on the 'Break
on all errors' option. From the VBA window, click Tools, Options, then
click the General tab on the Options dialog. Under 'Error Trapping'
select 'Break on Unhandled Errors'.

Bruce

[JensT]

de***************@gmail.com skrev:

JensT wrote:

Hi

I have used the isquerytable function mentioned elsewhere for a few of
my databases. And there has never been a problem - but suddently the
code stops at:

test = db.TableDefs(TName).Name

with the fault:runtime error 3265 - the element was not found in this
collection. - and it does that with all my databases using the function
- although they used to work perfectly.

Does anyone know what can be wrong?

TIA
Jens

I suspect that your code relies on triggering a handled error to work.
Either from the VBA window menu or in code you've turned on the 'Break
on all errors' option. From the VBA window, click Tools, Options, then
click the General tab on the Options dialog. Under 'Error Trapping'
select 'Break on Unhandled Errors'.

Bruce

This was exactly the problem - thanks a lot Bruce