Append Query - How?

  • Thread starter Thread starter HeatherLou1974
  • Start date Start date
H

HeatherLou1974

A previous employee set up a tool that takes all of our Ops Plans and
combines them all into (what becomes) an Excel sheet called ALL.
She is unable to maintain this "tool" and now I need to add the 2009 Ops
Plans Append Queries, but I don't know how.
Can you please walk me through how to do this?
(I've consulted the Using Microsoft Office Access 2003 book and I am still
confused)
Thanks in advance!
Heather
 
I doubt that anyone here can answer your question as we don't have any idea
of how the database is set up. I could hazzard a few guesses but would
probably be wrong.

Your best be may be to hire someone in the local area to help you on this
project. Hopefully that person could show you how to repeat the process for
next year. Better yet have them write down the process just in case you leave
by 2010.
 
Heather, you've said
"I need to add the 2009 Ops Plans Append Queries' as if we could see your
database and knew somehow what YOU meant by the 2009 Ops Plans Append
Queries.
By a 'tool', do you mean that there is code within a form in your database
with a button that runs a series of Append Queries, perhaps via a macro? Or
maybe a Module with a Sub which exports the data. You can safely open up
Modules and code pages. Look especially for the word Excel.

Have you had a look on the Macro 'page' of your database to see if there is
anything like this?
(You can open Macros safely in Design View, just don't double-click on them)
Do you have any visible Append Queries on your Query page (they have a green
cross next to them)?
You will need to be much fuller in your description if you want help.

I guess, like most bosses, yours isn't willing to pay for outside help and
didn't have the foresight to ensure that his previous employee trained
another user while still he was still available.

Evi
 
Back
Top