Solved

ms access 2010 macro error

Posted on 2011-09-09
10
204 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
  • 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
 

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now