I am trying to copy a chart from excel 2007 to power point 2007.  I have a
few "pictures" that are overlayed ontop of the chart that are copied from
another part of the workbook.  In 2003 I could select the chart, hit copy and
then move to PPT and do a paste special then select ...

is there any way to record the date and time in a record so that it
will not change? i.e. i want to record the date and time that an order
is placed. many thanks, michael

I have created a query with two tables.
One table is the invoice table and the other is the a table that contains a
field that has total cost. They are related by the order number.
Now the first field in the query is Department

I never used the access runtime edition. So I have a simple question. Is it
possible to edit (change, add, delete rows) the databases content with the
runtime version?
Thanks for your feedback in advance.

I have a few databases on a shared folder on a system A.  They are set to
operate in Shared mode.  But i have any of them open in system A, i am
unable to open it from another system B on the network.
However if i first open the database from the system B, then i am also able

is there any way to get access to close all the open windows using
VBA, without having to define all the open windows. many thanks michael

If I have a Data Access Page generated (save as) by a report (in Access)
ex: name & phone number
the page displays a long list that needs to be scrolled. Is there a way to
display the list in multiple columns allowing more information to display?

I have written several Access database-however I am self taught and very
dependant on the discussion groups.  I would like to become more self reliant

employer is willing to fund the classes.

Here's my situation, which I can't wrap my head around.  I have a flat file
of non-normalized data.  I want to dump the file into an Access db and run
reports on it but I understand that for performance reasons the data need to
be normalized.

I am trying to use a list box in a subform that is populated with some data
from the subform.  The subform is linked to the main form by PersonID, I have
this code in the Row Source:
SELECT tblPerson.PersonID, tblEvent.Date, tblEvent.Time, tblEvent.InputID,

I'm running a macro which contains several sub-macros.  I have to manaully
click "yes" for every qusetion it asks for each step.  Is there a way to have
it automatically answer yes to each step so the macro will run all the way
through by itself?

If I have a table something like this:
startdate | stime | endate | etime  | tool
3/3/07     | 8:47  |  3/4/07  | 00:30 |  A
3/4/07     | 3:57  | 3/4/07   |4:30    | B

I Try to connect with sql Database and I am getting the
Message." Two many indexes on that table.Delete some of them and
try again."
I am using access 2003.

I used to know the answer to this, but it's been too long since I've
worked with recordsets. So anyway...
I'm trying to create a recordset that isolates a specific record (in
this case, an image file name) using a DAO recordset.  The select

I need to kick off a macro when my database is opened.  What is the easiest
way?  Can I do it through the Startup option on the Tools menu?  Or do I need
an event in my VBA code?  Thanks!