I have a combo-box on a form with 3 columns, ID (primary key), surname,
forename and have column widths of 0;2cm;2cm... hiding the primary key for
easy reference by the user.
I want to be able to filter this field by Surname (text that is found in

I have a record database linked to a name only.
Within the records I want to add issues (which is linked via subform) this
works fine
but my question is this - does anyone know how to make it so the autonumber

I am trying to make one report serve multiple functions.   I had to add an
additional grouping level to satisfy a request from one end user.   I hide
this grouping based on a value in a combo box.   This works except it keeps
sorting by this group level, even though it is not ...

I'm trying to use Mr Lebans' MouseHook to turn the wheel on and off.  I've
entered the code (Dim blRet as Boolean; blRet = MouseWheelOFF) in the form
load property, and the code to turn it on in the form close property.
But it's not working.

I have searched the discussion board for the answer to my question but
unfortunately have not been able to apply any of the variations to my DB.
I have a field called LengthDF which is a number field and users enter the
duration in seconds of a Digital File into this field. (My ...

I have a strange problem with a form.  It's a complex form that has sub-forms
and an unbound combo-box that displays the record of the person that you type
in the look-up box.
Every now and then, after making a change to a record using this form, when

I am trying to create a financial report that compares planned spending
against actual spending.  Actually, I have the report basically done--using
the main report as the planned and the subreport as the actual.  The planned
budget item appears first, followed by a transaction ...

I have a form with an RTF control.  It can contain one or more images along
with text. The result is stored in a memo field in a table.  As a record, the
field occupies about 200K.  If I save the contents as an RTF file, the size
reduces to about 100K.  If I save the file a jpg, ...

I have a document set-up in word that requires information input onto a line,
eg. Name: ______________________.  How do I format the line so when someone
opens the form in word, they can just type the answer onto the line?

Using MS 2003, I have a form with a subform. Based on checking a field on the
master form, I would like the subform to become inaccessible (ie. grayed
out), but I don't want the subform to become invisible. Is there a way to
make the entire subform inaccessible, but visible ...

I have a main form "GeneralInfo" and it's subform "EmployerInfo".  In the
subform, I have a button that opens up the Comments form.  The wizard works
ok and narrows down the results to the unique ID, it just doesn't let you do
more than one link.  My problem lies here:

I have a small problem with user enter the wrong date or time. Here is my
problem on an input form: The user sometimes enters the wrong time or date
Example
(Text Boxes on the form)

I have a form called 'Prospects'. To change a prospect to a customer
you need to enter the customer ID. I then have three command buttons
that need to be run. The first saves the record, the second updates the
record (using an append query) and the third then deletes the record.

I want to open a form and restrict which records are displayed on it...
here's what I've got:
   DoCmd.OpenForm "frmConfigValue", , , "Key = 'TargetArchive'"
Problem is that all the records from the table are being displayed on the

I have a form bound to a table...
As changes are made to a field on the form, I want to inspect the change and
perform some action...
The problem that I am running into is that when I inspect the value using