98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Strange error ( need help )
Strange error ( need help )
Resolved · Urgent Priority · Version 2003
Danny has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Outlook Introduction course
Word Intermediate course
Project Intro Intermediate course
PowerPoint Introduction course
Word Advanced course
Outlook Advanced course
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Copy a Previous Record's Values to a New RecordIf you often enter the same value in one field of a table, there are two methods to save re-typing the data. |