I have linked tables from a different database.  I have the new tables as a
one-to-many relationship in the new database.  The subdatasheet will not
display.  The "insert subdatasheets" is disabled.  What can I do to fix the
problem?

I'd like to insert a derived field into this situation
tblShipments (Parent table)
Shipment_No
Shipment_Size

I have a form where I would like to integrate subforms. (OK, no problem)
I would like that, if I have i.e. subforms, 1,2 and 3, only that subform is
shown where as well data is in. Empty subforms I don’t want to see.
Is that possible and if yes, how?

My question is in regard to the title of the document in the title bar.  
Normally, the current file name is found in the title bar; however, in the
database I am using, the title bar shows the name of the document from the
original version.

I'm using Access 2002 and the "help" file is driving me insane!  Is there a
way of finding information about functions?  I.e. what are the accepted
variables, which are optional, which varibles change the result etc.  I've
been trying in vain for the last two hours to find out!

I'm fairly new to Access.
I have a query that I run every day that that produces a list of part #,
whse #, part description (if the part has 0 onhands).
The next day I will run the same query and some records will fall off the

Just like it says in the subject, how do I move or copy the calender to my
Zire31?

I have a combo on my form where the user can select from a list of
names. I also have a button which onpens a form where the user can add
or delete names. This is the code I'm using -
Private Sub CommandAddNewName_Click()

I do have the following
1)    a form called “customers”
2)    a subform in the “customers” form, called “billsopenvalue”(Datasheet)
3)    a field in the the form “billsopenvalue” is called “resting”

I have a table concerning Lab Tests which I present using a form. One
of the fields in this table is called Test Status where the user can
select the status via a combo box. Under this combo I have a label box
which shows a summary of the status for the entire table e.g. OK: 10,

dear friends, i have 2 questions:
if i have pictures stored in a table(its path) and i want the picture itself
to appeare in the form how can i do this. its always appear as icon
also if i want to sum the record fields and put the result in the last field

I have a Customer table and an Orders table.  I have another table with
PaymentSchedule table containing Instalment promises for each order.
Ideally i d create a form where I can either select an exisitng customer or
create a new customer.  Then select an order or create a new ...

Is there a way to open a form from a Ribbon using VB instead of Macro?

There was no respond to my original post in microsoft.public.access.forms
(May 5th 2007) about a fortnight so I try it here...
—————————————————————————————————
A while ago we had a discussion about A2002 (sub)form which changes

Much like a pawn show rental store.  Need to be able to customize to
personal needs.  Know access fairly well and would like to get a program
with source code that I can modify for my needs.
Any suggestions/help would be greatly appreciate.