strange error need

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Strange error ( need help )

Strange error ( need help )

resolvedResolved · Urgent Priority · Version 2003

Strange error ( need help )



hi guys, when one of our users tries to print a specific report he gets this error come up :The record source 'qry_MoreDetails' specified on this form or report does
not exist.
but malcolm who sits next to him and works on the same database does not have the issue at all..... any ideas?

RE: strange error ( need help )

Hi Danny, thanks for your query. Difficult to advise without having a look at the structure of your database, but this error has been known to start appearing when there are Lookups involved in the creation of a recordset. Best guess is that there is a broken link somewhere along the line. You need to reverse engineer how qry_MoreDetails is being created and if it is a Lookup delete it out and put it back in again, and if the Lookup is in a table itself definitely take it out and perform the Lookup on a form. Lookups in tables are of course technically possible but can cause odd problems like the one you are encountering.

Hope this helps,

Anthony

Tue 21 Dec 2010: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips


Server loaded in 0.11 secs.