Solved

Getting an error in access 2010 when creating a macro

Posted on 2011-02-23
8
201 Views
Last Modified: 2012-08-14
I am getting the error when I create a macro in the form view.  If I do it the long way it will work, but I cannot use the newer easier command fields.  Access 2010 features are not being recognized.  Using 2007 accdb files and getting the error below
Access-error.pdf
0
Comment
Question by:mickeymo09
  • 4
  • 3
8 Comments
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34963163
Not sure what you mean -- macros don't have a form view.  In Access 2010, they have more features than in earlier versions, and macros created in Access 2010 are not usable if the database is opened in 2007.  Can you be more specific about your problem?  All the PDF shows is the error message.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34965303
Also please post image files for us to view.

Image files are viewable directly in the thread, ...PDF's (currently) are not.

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34965351
But the error is self explanatory.

Under certain conditions "Refresh" is not available.

So can you take a step back and explain what you are trying to do with this macro?
Along with this, post all of the macro actions up until the error line...

Perhaps all that is needed is to save the current Record
Action: RunCommand
Argument: SaveRecord

JeffCoachman
0
 

Author Comment

by:mickeymo09
ID: 34974235
ok i will post

but i create a new macro and try to run the macro - that is when i get the refresh error -
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Accepted Solution

by:
mickeymo09 earned 0 total points
ID: 34979676
I figured out what the cause was - I was logged in as a user instead of the owner  that is default -
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34982635
OK.

You can accept your own post as the solution.

;-)

0
 

Author Comment

by:mickeymo09
ID: 34982835
ok thank you
0
 

Author Closing Comment

by:mickeymo09
ID: 35015563
tested a setting that is default - and once i changed the setting i no longer received the refresh error
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

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…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

914 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

22 Experts available now in Live!

Get 1:1 Help Now