Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Strange error ( need help )

Resolved · Urgent Priority · Version 2003

Reply Mon 13 Dec 2010, 16:15Delegate 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?

For upcoming training course dates see: Pricing & availability

Reply Wed 15 Dec 2010, 07:14Trainer 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.

Access articles

· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Discover The Easy Way To Create And Modify A Table In Access 2010
· So You Still Haven't Learned How To Use Access Yet?
· Express Yourself With Microsoft Access
· Repetitive Tasks? Let Access Do The Hard Work For You

Please browse our web site to find out more about
access.training and other Microsoft training courses.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips