Query showing "No current record"

[XB9R]

Hi all,

I have a db with a simple query: main table & detail table linked through 1 IDkey - display all records from main table and only the related records from detail table. Output is grouped: IDkey from main table and a Yes/No checkbox from the detail table. The detail table is empty (no records). Query displays only the headings - no records. This is exactly what I want. So far so good. Now I copy the db and hand it over to a friend. The db performed fine until yesterday: suddenly the query won't run any longer, but is displaying the error message "No current record". Thinking that this was a "machine problem" I copied the db on my PC. Now I have 2 identical db's: one will run the query (showing only the header row - no records) - the other one won't run the query (showing a "no current record" error). I can't find any difference between the 2 db's. Any ideas ?

Dave

 

[dhookom]

Sounds like corruption possibly of the query. I would re-create the query an move on.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya XB9R . . .

On face value (according to your post origination) ... I can't help but agree with [blue]dhookom[/blue]. So to put a little more filling in the pie ...
[ol][li]Same OS?[/li]
[li]Same Access Version?[/li]
[li]Are you running the query from the [blue]query pane[/blue] or is it [blue]SQL in VBA?[/blue][/li]
[li]Query or SQL ... is the [blue]SQL the same?[/blue][/li][/ol]
Just a few thoughts that crossed my mind.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[XB9R]

Thanks for your responses.

Some more background:
As I told 2 db's, db2 being a copy of db1. db2 transferred to different PC. db2 worked fine until a day ago. Copied db2 back to my PC. the "No current record" stays. So same OS (XP pro), same Access 2003,...

I traced the error down to SQL in a subform. Copied the SQL into a query, both in db1 and db2 using the SQL from the "good" db1. I still got the error in db2.

Start stripping the query down, field by field. That's how I figured out that the Yes/No check field from the detail table is causing the issue.

I created a new query, with the same result. Can't find any difference in the table definitions.

Next I copied db1 to db3, deleted all tables, queries,forms,... & imported them again from db2. db3 also says "No current record".

So to answer all your questions above:
- Re-creation of query doesn't fix the problem
- SQL is definitly the same as I used the SQL from db1 to re-create in db2
- Corruption: Think I covered that by (re-)creating db3

As db2 has been on a different PC(s):
Pretty sure they have also XP pro, don't know about Access version (at least 2003, possibly opened with 2007 and/or 2010)

Very much appreciate your inputs.

Dave