Re: Ignore empty fields in Criteria append

You are quite correct. There is a lot about Access 2007 which is going to
disappoint people who are upgrading, there are already a lot of questions in
these newsgroups along the lines of "it worked in Access 2003 but doesn't
work in Access 2007".

If I were you I would have both Access 2003 *and* Access 2007 installed on
your home computer, but I realise that this is not a practical solution for
everyone.

"rej2008" <rej2008@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7AF2C667-427D-4414-A626-62347390E8AF@xxxxxxxxxxxxxxxx
Yes, I agree. Unfortunately I am dealing with two different computers. One
at
work running A2003 and the other one at home running A2007. I think I will
just have to create a Query and format the output the way I want it and
then
create an export script in A2007. Hopefully the script works in A2003 as
well.

Yes, I did see the wizard where it asked for saving the script.

Thank you. It is disappointing that there isn't one method that works on
both versions of the Access. At some point, people will have to upgrade
their
Access to a newer version and this could mean a lot of issues for people
who
have a lot of scripts that potentially may not work in A2007. After all
these
years in Software business, one would think that Microsoft will have a
better
solution that leave their customers without too many options than to
recreate
everything.

"bcap" wrote:

To be honest if you've got something that works for you in one version of
Access but not in the next version, my first advice would be, go back to
the
previous version! Sounds like a classic case of "if it ain't broke,
don't
fix it".

If you go through the export process in Access 2007, the final thing the
wizard does is to *ask* you whether you want to save the steps.

"rej2008" <rej2008@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C830B80E-F753-4EA2-B296-F085787F3E85@xxxxxxxxxxxxxxxx
Thank you kindly for your detailed reply. I am not too familiar with
VBA
yet.
I had a simple macro that would save the report results in to an Excel
file,
which workd fine in A2003, but not anymore in A2007. The command was:
DoCmd.OutputTo acOutputReport, "rptNewEmailList", acFormatXLS,
Filename, -1

Apparently that feature is not supported in A2007 anymore.

I am sure I should be able to do almost any of the analysis of data
within
Access itself. But when it comes to sharing data, it becomes a problem,
especially with people who have no experience or no access to Access!

I just need to generate some reports or Queries and save the results to
an
Excel *** so that I can send it out to few people for further use.

Yes, I noticed the export feature in A2007. But I didn't know how to
save
those steps so that I can repeat those same steps in the future, and
that
was
essentially my question.






.