I tried to create a validation rule in a form.  I obviously did it wrong.  
Now when I click on ANY FIELD AT ALL, I get an error msg that Access could
not parse the expression I entered.  It will not let me get back to
properties to correct or delete it.  I can't go to database ...

When moving the cursor with the key arrows it jumps forth and back (in a non
logical way) between the available options in the Option Group .
Here is an example and the steps the cursor moves when pressing the right
arrow key:

Just finished a DB and every things working great here using access 2003
made my MDE file and sent it the user but when they open up a form the
MYfilter form using a command button it will not show up on the screen  and
then he can not do anything else because its in dialog mode ...

  I'm trying to include a picture (thumbnail) into a form i have which
is dependent on the name of certain field.  This directory has about
30,000 jpg thumbnail sized pictures.  I want to programmatically include
the picture on the form based on a name field.  Can anyone assist ...

What is the best way to handle the following:
I have a query that needs to be sent via email.  The emailed FORM transmits
via email as desired with the exception of:
    1.  I need to total some of the fields.

could someone please help? 'd like to know what is the key combination to
use to simply enter text on a new line within a text box on a form please.

I am working on a mailing label and have a simple problem.
=Trim([StreetAddress] & " " & [CityID] & ", " & [State] & " " &
[ZipCode])
thats the address line.  Well instead of displaying the CityID (whihc

I have a form for making bookings for a community centre. On Friday and
Saturday nights, the client may book the centre for an additional 2hrs.
So in my form, I have a control called 'Extension' which is a Yes/No
control. I want it to be enabled or displayed only when the control ...

I have 3 combo boxes on a form.  The users make changes to those combo boxes
sometimes.
What I like to do is I would like to write a code to run my macro on form
closes if the users make changes to any or all of those combo boxes.  Below

I am trying to add a statement to this existing one.  It is attached to
the onclick event of a button.
Private Sub Command7_Click()
DoCmd.OpenReport "rptClubRegistry", acViewPreview, , "[ClubID] = " &

I added a command button with the wizard to open a form when the button it
clicked.  It opens fine but I would like it to be maximized.  Where do I set
that??
Thanks,

I have a form where, in the detail section I display and allow the user to
enter/edit time records.  I want to have a total at the bottom that updates
as they enter the data.  How do I force the writing of data to the datafile
so that I can run a 'dsum' function in the ...

When a user opens a form and has a record open, the default action for
Access is to update the record when the form closes. I want to change
that default behavior to abort or cancel rather than update. I need that
behavior to be the default even if the user closes the window.

Got a new one here. Okay so I create a search form with a subform, instead of
creating one form, to make viewing easier. Only problem is when I run the
createQBF utility it only lists the form as the parent not the subform as
well under the Tag property. Now that I manually created ...

I have a form that includes a subtotal pulled from a subform.  My problem is
that I need the subtotal to only include the current record and also only
include values for a specific text value. We are a sales rep firm and a
particular job may have purchase orders issued to us and ...