Ok, I cannot write code on my own.
I need a form to open with certain records excluded and sorted in a certain
order.
I know you can do this on the properties tab, BUT that is way too easy to

Hi All,
First of all, thanks so much for all the help with the questions.
I think what I am about to ask is impossible, but just wanted to hear some
suggestions (if any).

I have a single form that contains several fields from tblStudents.  I set
the required property to true on several key fields.  I am attempting to use
custom error messages in the BeforeUpdate properties without any success.  If
I set the..

I have the following VB code that is giving me an error message:
Run-time error '424'
Object Required
It doesn't llike my Set frm statement, as if the object doesn't exist.  But

Repost:  I'm not sure I explained myself well the first time, so I'm
reposting this in hopes that someone can help.  I had some good feedback for
my original question, but the solutions weren't quite what I was looking for.
I have a form, frmEmployees, that lists all of my ...

I want to delete records in a subform, the recordsource for the form
is:
SELECT * FROM (TEST INNER JOIN SAMPLE ON
TEST.SAMPLE=SAMPLE.ID_NUMERIC) INNER JOIN RESULT ON

I am testing a MS access app on Access2007 SP1. There a form which a sub
forms. The relationship like this:
MainForm include a SubForm, the SubForm has another SubForm1. So the
relation is:

In A2K - on a form.  Wanting to create a simple (I hope) control to indicate
whether the work on a record is done or not.  
If the user has completed work on the record, I would like the user to click
a control (thinking a toggle button works best here) and the record would

I am using a form with combo boxes in Access 2003 which runs a query with 4
to 6 parameters, and I need to display the results of the query in a subform.
When I add a subform in Design View and run the form, I am immediately
prompted for the parameters before the form is ...

Hi Groupies:
The standard Not In List code that I use is something like:
Dim db As DAO.Database
Dim rs As DAO.Recordset

I use dlookup to find a specific data which is very useful.
I just wonder that are there any way to retrieve 2 or more fields in
the same table.
I use 2 or more dlookup which seems not efficient.

Note: Re-posted this here from the "forms" section as this section seems more
appropriate.
Hi,
I have a database with a multi line memo field and I am creating carriage

I have a form (Mainform) with a subform. This form tracks assignments. Once
an assignment is completed by one the many people it is assigned to, I check
a complete box in the subform by the person's name. Once all of the assigned
people in the subform completes the assignment I ...

hi to all
This question isn't about code that doesn't work, but about code that does
(but I'm not sure why??)
In my form's header, I have an unbound combobox (cboSelectCityState) that is

Is there a way to standardize the memo field once updated to remove all "alt
enter" spaces?  Kind of in the same way it would standardize case problems
like:
me.memo = strConv(me.memo), vbproperCase)