Hey guys.
I cannot remove the filters from 2 subforms with VBA:
me.subform1.form.filteron = false
me.subform1.form.requery

Is it possible to wrap lines in the column headings of a ms-access form in
Datasheet View? The text in the heading appears to be the Name property of
the textbox in the design grid. If this text is somewhat long, not all text
is displayed in Datasheet View (I do not want to drag ...

I have a Tab control on my Access form.  When the computer’s settings are on
Windows Classic there are no problems, but when I set the theme to Windows
XP, the caption is not always visible.  The captions all appear when I first
load the form, but disappear when a tab page is ...

Is there a way to program a code in a form to run a query - then count the
number of records in that query.
I know how to run a query by this method:
Dim Inst As QueryDef

I didn't get reply to my yesterday's question -
I have added a subform to a form, but for some reason after I change the
field size, it doesn't take effect when I run the form. I want to enlarge the
width of some fields and also change the size of combo box display.

I have set up a form with a number of combo boxes.  When I have selected all
the details, I click the Add new record button which saves this record and
gives me a new blank record, but I would like the new record to appear with
some of the data from the previous record.  i.e if ...

I have a form that stores data into a table. I have added a combo box that
list book chapters from another table. I want to add another combo box that
will present subchapters from a subchapter table but only the subchapters
that are related to the chapter selected in the first ...

How do you get the previous details that have been entered into the
forms to not appear next time you go trough the forms..!! basically
refresh & save the whole thing returning to start again buy just
hitting a finish button?? Iv got the finsh button that takes me back to

I'm looking for a way to relate a dialog box that will pop up with notes for
a specific job when that job number is entered.  Example:  Form that opens
with parameter box asking for job number.  After entering job number, I want
a box to open with specific notes pertaining to ...

I have a form which contains a record number field [std_op], and also a combo
box [status].
I have a command button for the end users to click to search for a
particular record which works fine, but I would like to only show the record

Right in my Tables i have set School Name as the Primary Key, each week
details from each school (55 in total) are retunred and then entered in
to the database. I have set up a combo box with all the school names.
Will there be a problem with having the School Name as the primary

I have a main form on which there are several buttons. Once a user clicks on
the button, either a new form or a query opens up with additional
information. How do I keep the size of the forms or query windows fixed? I
would like the windows to be a fixed size regarless of the ...

I need a help with creating a search form, which includes textbox and a
button. If user enters for example 4 words, I want the database to
search in a field of a table for these 4 words in random order. For
example: If user writes "512 Apac", search results will contain "Apacer

I have a command button which runs append queries on the current record of a
form/table. The append queries copy the current record to a backup set of
tables.  On completion of this backup I would like the current record to be
deleted from the active form/table using the same ...

Is it possible to either hide the design view button or password protect it?
I don't want anyone to be able to have access to the design view of the
database