Solved

ms access 2010 macro error

Posted on 2011-09-09
10
207 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 33

Accepted Solution

by:
Norie earned 300 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 200 total points
ID: 36513154
Does the query exist?
Has it been renamed?
0
 
LVL 74

Assisted Solution

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

    DoCmd.OpenQuery "YourQueryName", acViewNormal, acEdit
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

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

Assisted Solution

by:Norie
Norie earned 300 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 33

Assisted Solution

by:Norie
Norie earned 300 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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 …

749 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