I have 2 tables linked together by ClientID.  The main table is the Client
table and the second table is the Invoice table.
I have created a form that will produce an invoice and the main part of it
has the client ID, name, address, etc.  Then I created a subform, based on a

I used a tab control with style set to none.
When I try to move the container, if it has a control in it, it will only
resize, not move. How do I get the controls to move with the container and
have the tab control retain the same as when I set it.

I have 3 tables:
tblPerson (PersonID, TeamID & other fields)
tblGames (GameID, Person ID, TeamID & other fields)
tblTeams (TeamID & other fields)

I'm using Access 2002, and I would like to close the current MDE and start
another MDE. I've looked at the CloseCurrentDatabase and OpenCurrentDatabase
commands, but I suspect they only work with MDB files, not MDEs. What would
be a good way to do this? The Shell command, maybe? ...

I'm trying to progammatically select an item in a query bound listbox
without actually knowing the ListIndex value. I do however know the value of
the bound column. I thought all you had to do was:
lstInventors.Requery

Is there a way to make a container for objects in a form. Currently I can
group textboxes and other objects but I can't use a frame as a container for
those objects. Does anyone know how to make a container that can also be
referenced.

I am trying to create combo boxes on a subform where the values in the second
box are dependant on the value selected in the first box.  
Main form = TblITInventory
Subform = fsubSoftwareInventory

I saw several posts on this topic, but messing with the code in all the
examples given didn't work:
I have a form that opens showing data based on textboxes (dates) on the
PREVIOUS form set as the parameters for the recordsource query (2nd form's

I have a combo box, and I would like to find and select a item in the combo
box list, based on it's bound column value. How can I do this in access
2000.
Thanks,

When I write something like:
="Opmerking:  " & [Opmerking])
for an field on a report, I can not change the layout of the leading text
alone. When I chose underlining all text that comes after is underlined.

I have a relatively simple form which uses unbound text boxes to display and
edit information.  When the form opens, an ADO Recordset is created.  On the
form are record navigation buttons to move forward and backward by
performing MoveNext and MovePrevious respectively.  The text ...

How do you compare two tables to identify records that
are in one but not the other?
For example, how would I compare tblEmployee with
tblAssets to identify any employees who do not have

i am sulaiman from malaysia.
i need some help regarding Ms Access option button.
let say i have a database structure like below :
id -----------> data type

From within Access, I want to automate a process to scan a document, assign
a unique file name, save the image in a folder, and create a link to the
document so that it can be opened and viewed from within the database
application.  Can someone point me in the right direction?  ...

I have two tables.
one is called opcincp.  It houses each record info i.e. spec_no, cust_code,
etc.
The second, Permspec contains all the info for that spec.  (spec_no,