Solved

Getting an error in access 2010 when creating a macro

Posted on 2011-02-23
8
205 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
Back Up Your Microsoft Windows Server®

Back up 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: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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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, 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 …

729 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