Macro in Access 2000

  • Thread starter Thread starter b. tabor
  • Start date Start date
B

b. tabor

In setting up simple macro to query a table, I used
OpenQuery
RunCommand

The macro is a normal and runs as long as the Action
Argument for RunCommand is blank. but when I put
QueryTypeAppend in the Action Argument for RunCommand to
append to table, I get error message, Action isn't
available now. Says I may be using read-only file but I'm
not and file isn't in active view - don't know what that
means.
Thanks in advance if you know what I'm doing wrong.
 
you're opening a query with the OpenQuery action. is it a Select query? or
is it an Append query?
if it's a Select query, you can't use it to directly append records to a
table. if it's an Append query, the OpenQuery action will automatically
cause it to run (append the records) - you don't need to use an additional
RunCommand action in the macro.

hth
 
Back
Top