Query Form

[danny123]

RunTime Error 7874

Hi there,

I have a query form which user use to search for records according to their conditions they selected from the dropdowns.
Now when there is result for the conditions specified it works fine but when there is no record it pops up message saying no record and as one hit okk it gives below error:
"Run Time error 7874
eta database cant find the object 'xxx-0725'"
this is some table gets created everytime we search something.
and if there is no result this is not created somehow and it gives error.

Please Advice
Danny

 

[danny123]

i got it working.
There can be 2 reasons:

1. If this error is allready handled then try to check
Tool--> Options --> General --> and Under Error trapping check on :Trap on Unhandled errors"

2. Second is may be the error is not handled at all(that was mine case)i just added the exception and it worked fine.

Thanks
Danny

 

[The_Doc_Man]

Access doesn't create a table unless you take an action that directly or implicitly creates a table. A form with search capabilities as you describe rather obviously has at least some VBA behind it, and that is where I would look for the culprit.

A "naked" search form probably would not do this without it having been instructed to do so. Forms that fail a search don't normally create even a RECORD, much less a table.

You say a table is created. What name is it given?

You need to give us a few more details before there is any hope of figuring out what is going on.

 

[danny123]

Thanks for response but i have allready resolved the issue and i have posted the solution also just one min before you posted.

Thanks
Danny