Access 2002 (XP) - Windows XP Pro
I have a client who wants to see a significant number of columns in a combo
box.  To this point I have been able to accomodate him.  Now he want to add
more columns and he is physically out of screen real estate (horizontally).

I have a form that uses the FormResize class from the Getz and Litwin
Access 2000 developers handbook.  I recently upgraded to Access 2003
and began using pivot table and pivot chart form views.  However, any
time I this feature in conjunction with FormResize, the app locks up

How can I create a data field that has a calendar to choose the date instead
of having to type in the date always.
Thanks very much.

I have a form (access 2K) which I open with two calendar controls to select
the starting and ending dates for a query which feeds a report. I've been
trying (unsuccessfully I might add) to have the calendar form close once
the dates are chosen and the report opens up. I've tried ...

I need to create some validation on a tab control that checks if all
"required fields & subforms" have been selected/received data.
Here's what I have:
- 2 tables

I apologise for the "multiposting" but when I posted I seemed to get crashed
out of the system so I wasn't sure it had posted. Now I know it worked I
won't feel the need to keep trying!
Basically I have a database for a coach tour operator company and the user

One of the PC's at my office does not display the activeX date/time control
function that is utilized in the form created for date entry.  Instead this
appears as a blank data entry field which is dead. The field works fine on
all of my other PC's.

On my form I have several rows of the same fields which are:
Name, Man Number, Date
Question is how can I get the Date fields to automatically fill in with
today's date only when the name field in that row get's filled in ?

I going to do a Microsoft Office Course  in the near future and have bought
some books to get a head start, but I can't resolve this problem with tables
and forms in Access. When I first started using Access it worked as I assume
it should with the Table & Form Wizard laying out the ...

1. How can I update the contents of a combo box without going into design
every time.
2. And when inputing data how is the required item chosen.

Hey all
I am having a problem with a subform.
I am creating a purchase order form based on my purchase order table.  I
added a subform so that a user can enter many part numbers, descriptions,

Hi --
Is there a setting that will force the print preview zoom level for
Access reports to 100%?  This seems to be automatic with Access 2000,
but when running Access 2002 the default seems to be "Fit".  Yes, the

 I have two tables that I want to merge on to on view screen.  The records
on one table will have a unique record to the common field while the other
will have the same field list many times.
 I would like to enter the common field and then display all of the

I am normalising a database, used for sending samples to the customers and
in a "SubForm" in datasheets view, I am not able to requery a field.
The form is so composed:
main form[frmDataEntry]

Is there any way to remove an item from a combo box once a user has selected
it?  What I am trying to do is create a form in which a user can choose the
shift to assign to an employee, once a shift is selected I want it to be
removed from the list so that only the shifts that are ...