Solved

Getting an error in access 2010 when creating a macro

Posted on 2011-02-23
8
200 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Accepted Solution

by:
mickeymo09 earned 0 total points
Comment Utility
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
Comment Utility
OK.

You can accept your own post as the solution.

;-)

0
 

Author Comment

by:mickeymo09
Comment Utility
ok thank you
0
 

Author Closing Comment

by:mickeymo09
Comment Utility
tested a setting that is default - and once i changed the setting i no longer received the refresh error
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

763 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

9 Experts available now in Live!

Get 1:1 Help Now