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

Strange error ( need help )

ResolvedVersion 2003

Mon 13 Dec 2010, 16:15 Delegate Danny said...

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?

Wed 15 Dec 2010, 07:14 Trainer Anthony said...

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

98.7 % recommend us

More live stats...

Training information:

Access tip:

Create own ribbon tab - Access 2010

a. In Access click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Access hints and tips

Strange error ( need help )

Strange error ( need help )

RE: strange error ( need help )

Access articles

Access tip:

Create own ribbon tab - Access 2010