Solved

Getting an error in access 2010 when creating a macro

Posted on 2011-02-23
8
204 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
[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
  • 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
Technology Partners: 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: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
 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

736 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