[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

ms access 2010 macro error

Posted on 2011-09-09
10
Medium Priority
?
215 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 35

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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

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

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 35

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

656 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