Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

Getting an error in access 2010 when creating a macro

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
mickeymo09
Asked:
mickeymo09
  • 4
  • 3
1 Solution
 
Helen FeddemaCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
Also please post image files for us to view.

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

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
mickeymo09Author Commented:
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
 
mickeymo09Author Commented:
I figured out what the cause was - I was logged in as a user instead of the owner  that is default -
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK.

You can accept your own post as the solution.

;-)

0
 
mickeymo09Author Commented:
ok thank you
0
 
mickeymo09Author Commented:
tested a setting that is default - and once i changed the setting i no longer received the refresh error
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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