?
Solved

ms access 2010 macro error

Posted on 2011-09-09
10
Medium Priority
?
209 Views
Last Modified: 2012-05-12
I have attached a screen shot of an error we encounter when running a macro. I have never seen this before. Can anyone give a clue as to what is going on here and perhaps what we should do about this?

RGA-Audits-Error1.docx
0
Comment
Question by:tesla764
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
10 Comments
 
LVL 34

Accepted Solution

by:
Norie earned 1200 total points
ID: 36513141
That error means that a name is wrong somewhere in the query, 'Qry_Cross tab' i think, you are trying to execute.

It's probably a field name and if the query is based on another query it could actually be there.

If there is a crosstab query invovlced somewhere it could be there.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 800 total points
ID: 36513154
Does the query exist?
Has it been renamed?
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 800 total points
ID: 36513170
<what we should do about this?>
Possibly consider using code and not macros:

    DoCmd.OpenQuery "YourQueryName", acViewNormal, acEdit
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:tesla764
ID: 36513183
The query exists. We recently upgraded from Access 97 to Access 2010.
0
 
LVL 34

Assisted Solution

by:Norie
Norie earned 1200 total points
ID: 36513242
What type of query is it a crosstab query, a make table query, a select query?

Is it based on any other query?
0
 

Author Comment

by:tesla764
ID: 36513329
A select Query.
0
 

Author Comment

by:tesla764
ID: 36513355
Here is the actual code...

SELECT [TBL_RGA AUDIT Crosstab].sod_nbr, [TBL_RGA AUDIT Crosstab].sod_part, [TBL_RGA AUDIT Crosstab].R, [TBL_RGA AUDIT Crosstab].S INTO [TBL_Cross tab audit]
FROM [TBL_RGA AUDIT Crosstab];

The name of the query is...
QRY_Cross tab make table
0
 
LVL 34

Assisted Solution

by:Norie
Norie earned 1200 total points
ID: 36514234
Looks like it's based on another query, [TBL_RGA AUDIT Crosstab].

Check that query exists and if it does that the fields it return are the same as those in the query you posted.
0
 

Author Comment

by:tesla764
ID: 36523216
I will check that. Thanks.
0
 

Author Closing Comment

by:tesla764
ID: 36529717
Once again you guys are the best. We got the problem fixed. Thanks for all your guidance and help.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question