Hi. I would like the subform and also the form to automatically adjust height
based on amount of records in the subform (instead of having the vertical
scroll bar appear). The subform is directly below the form information.  Is
there an easy way to do this. Thank you.

Trying to import a form from a backup that was deleted by mistake.  When
importing the form after picking the name of the form from the list I get
this error:
"Microsoft Office Access can't save design changes or save to a new database

I have copied and changed the code successfully for two other forms they have
been working fine and I am now ready to create two more similar forms (thus,
copy and change the two tables and fields again).  However, this time when I
change the VB code to the new fields and tables ...

 I have seen many topics relating to this subject, but i'm still quite
confused.
 I have a database structure that has Releases
   Each release has main tasks

I am using Access 2000 and i have a database in which i would like to
search for all items that have the description in lowercase.

I'm creating a contact management database from the sample in Access 2000.  I
added a table for CallType with three current records (Phone, E-mail, Visit).
Then I added an unbound Combo Box to the Calls Form.  My new field shows to
the right in the Form and you can drop it down ...

i have a table that lists job details called 'jobs'
fields: job no, description, department, date
Each job number can visit more than one department.
I need to print a report that uses the 'job no' as the grouping. the page

I have created a subform with tab controls from various tables.  Two of the
tables are called Property and Tenant.  In the Property Table I have the
primary key as the Property Ref and in the Tenant Table the primary key is
the Tenant Ref. This all works fine until I want to add ...

If I have a form 'FormA', say, then I can access a control 'ControlA', on
that form, as FormA.ControlA and I can find the name of the form as
FormA.Name.  If, however, FormA.Name is provided to me by a piece of code I
cannot immediately see how to use this form name string, to ...

I have a query populating a continuous form.  I have one control (containing
a text month year like 'Dec 05').  Filter by Selection works on every other
control - text or numbers, but when a value is selected in this field, no
records are returned.

ok...
iv got 3 columns in my combo box  but it only seems to store only  the
value from the 1st column
in the combo box in my table....!!! how do i get it to store all 2

Hey... am getting really annoyed now cause it aint woking grrr
Q: To gett the No. Pupils value from the combo box to be able to
do a calculation in another box in my form.. i have to refer to the
combo box's Column property. If the No. Pupils value is in  the 3rd

Got the following to turn into a input mast
130800z Jan 06
Which means in layman's turns, the first two digits are the date for
today,

Guys,
Is there a way to calculate the amount of weekdays only between two given
dates?. The Datediff (In days) gives me all the days I want to exclude the
weekends.

right to gett the No. Pupils value from the combo box to be able to
do a calculation in another box in my form.. i have to refer to the
combo box's Column property. If the No. Pupils value is in  the 3rd
column, you'd use: