I am trying to export a pivot chart to an image for inclusion in a
powerpoint report yet am having some issues.  The code I am using is:
   Sub ExportPivotChart()
       Dim frm As form

I need to use double data entry with an MS Access database.  I have
read many arguments and reasons against this on this group but I have
to do this.  I have seen various tips on how this can be done including
the use of queries but this hasn't worked satisfactorily.  I have two

I am computing an XML file with all necessary tags, to be used in
dedicated XML software. I am computing it as a text file but don't know
how to do to save it to the disk UTF-encoded. strConv() with constant =
64 does not work, because the default code page of the system is UTF-16

My database was developed and is currently running in Access 2000.
I am contemplating upgrading to the latest version of Access (2003?)
running on new computers.
Will there be any major problems running a 2000 db in 2003?

In an MDB report I was able to obtain an Orders total in a Group Footer
by setting a control's ControlSource to: =Sum([Qty]*[Price])
In the Detail section of the report are controls bound to:
(1) Description

I wonder if you can help me.
I have setup an address-book database in Access XP. I have the first name &
surname as separate fields.  As I wanted to sort my database by surname and
then by first name I had surname before  first name when I created the

I might not have phrased the question correctly in the Subject of this
post.  Please read the entire explanation.
I have a form with a command button (Add New Person).  This button opens
up another form (frmPeople) with a NewRecord (blank fields).  The

I don't think my mind in good shape on this today, really need your
expert on this
I got two simple tables without key
Table A has 2 fields, Date and volume, e.g. 1/May/05 and the actual

I have a number of buttons on a form which run mailmerges.  Next to
each button is a text box/control that the user enters a date into when
the letter was created/merged.  When the user presses the button it
calls a function called LetterMerge to carry out a mail merge.

I guess my question can go in two directions. I create applications
that run multiple queries against a database. Generally speaking in the
past I have used a Data Control (calling it dat1) making it invisible
and have used this whenever i needed it.

I am currently using the OnDirty event of a Form to detect whether any
fields have been modified.  I set a boolean variable.  Then, if the
Close button is clicked before the Save button, I can put up a message
on the screen that will tell the user that "Data has been changed, do

This is my first post, so I hope I include all the right information.
I have a Table which has a list of numbers stored in a string, which are not
in numerical order
For example "10 2 35 21 42 3 6" etc

I would like to be able to programatically check for group membership
in an access database.  For example, I would like to be able to check
is someone is in the admin group before the program does Y.
something like:

I am learning Access and programming.  I wanted to have the user select
the departments for an ad from the list of all departments.  Found code
(that I could understand) on this site, and it works.  But I have 2
quesitons:

Round(1-Round([CYTaxValue]/[PY1TaxValue],2),2)
The above works fine unless CYTaxValue=0 and PY1TaxValue=0.  Then I get
an #Error message.  Is there a way to eliminate the error message and
reflect the result as 0?