How can I append data in two related tables  simultaneously?
any help/suggestion would be appreciate

Help!  I am getting very frustrated and I hope someone can offer some
guidance.
I have the following 3 tables
#1 - tblGLInvoice (no PK)      #2 - tbl InvoiceTracking    #3-

I am working on a database to track inventories, sales, orders etc... but i
am facing a problem, my pricelist changes from times to times (different
prices for the same product - same reference). In fact the price change once
or twice a year so i need to enter these different ...

What are the limitations of exchanging database objects and text using access
2003?   Thank You Dan

i have 132 fishing club members in a form based on a query. i now want to
select certain members to fill a particular boat on a certain day? sounds
simple but this dummy has not suceeded in doing it please! help?

Ok, I'm seriously a new user, and I've seen several disparaging comments
about using lookup fields. They seem to be anathema to the power users. So,
what do you do instead of using a lookup field? And if I have a whole bunch
of forms and tables with lookup fields already, am I ...

My users want all the fields in the database to be all caps.  Is there a way
to change all the forms and reports to show in all caps despite how it was
typed in?
Thanks,

I now have an Order form with a combo box on the 2nd page. This combo box
selects multible items and is set to continuous forms. I would rather have a
list box to do this. I created a subform for the list box and gave it all the
same properties as the combo box and set the ...

Am experiencing a few problems with an old Access file, trying to use it in
v2003.
It uses a Linked Excel doc, I've updated the link, but it treated that as a
new file, (remembered to include header row).

How can I update a TOTAL field whose values is calculated by multiplication
of PRICE*UNITS in a table and in a grid form?
I'm new to Access.
Thanks

I want to know about the uses of the Mainframe Computer and aside from that I
want to kow where it is used

    I need to delete unused data from my database, so I can reduce the
MDB file size. How do I do it?
    This is my delete command:
delete from events where events.customerid in (select events.customerid

I have a database designed after the Northwind database. My question: If I
have a product that is no longer available, and I don't want it to show up as
a choice on my Orders form, how do I handle this so that existing records are
not affected? I am currently using a combo box on ...

I got excel sheet with client's data
For example:
Name      PO#        Order Qty       Price      Ordertime
David     12            1000         10000.00    1/2/2007

I have a form that I enter serial numbers in.  I was wondering if there is a
way to tell if a number has already been entered.  I would like something
that would tell me the number already exist or something like that, and have
the option to view that record. Can this be done?  ...