• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

ms access 2010 macro error

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
tesla764
Asked:
tesla764
  • 5
  • 3
  • 2
5 Solutions
 
NorieCommented:
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
 
Jeffrey CoachmanCommented:
Does the query exist?
Has it been renamed?
0
 
Jeffrey CoachmanCommented:
<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.

 
tesla764Author Commented:
The query exists. We recently upgraded from Access 97 to Access 2010.
0
 
NorieCommented:
What type of query is it a crosstab query, a make table query, a select query?

Is it based on any other query?
0
 
tesla764Author Commented:
A select Query.
0
 
tesla764Author Commented:
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
 
NorieCommented:
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
 
tesla764Author Commented:
I will check that. Thanks.
0
 
tesla764Author Commented:
Once again you guys are the best. We got the problem fixed. Thanks for all your guidance and help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now