I want to accomplish two things when my form opens:
1. To display a new record
2. To open the form at a specific size
This is my code:

I have a simple form based Access front end which is used to select some
existing info stored in tables, and also to gather user input. The info is
then sent to recipients via Outlook. I need to find a way of taking multiple
selections (also possibly single selections) from a ...

I know COUNT works across the whole database on a named field, but can it be
programmed to count the yes's from a number of different fields on the same
form?
I.E. to count how many of, say, 12 boxes are ticked.

I am trying to use a date function with arguements to assign a specific day
to a form.  For example,  using the =date() function on the form would put in
todays date.  I need to know what arguements I would have to put in to
advance the date to a certian day... say like next ...

In a form I have a command button for a change one record in a subform:
"Me.subform_name.Requery"  -> is ok
After that, I use
"DoCmd.GoToRecord , "subform_name", acFirst"

Hello.  My question pertains to the screen resolution.  I am wondering if it
is possible for Access 2003 (eventually to 2007) to change the screen
resolution when it opens and closes.  What I would like to do is have the
application open up and change the users screen resolution ...

Ok... for the love of cheese... somebody share with me how to call up the
Page Setup dialog box from a button on a form.  I have tried this:  
DoCmd.RunCommand acCmdPageSetup.  This does not work... as it only works from
a menu bar.  I am using Access 2003.  Is there another way ...

I have a UNION Query that is giving me a Format problem.
Here is the Query.
With Forms!frmCheckPreview!ListOrders
.RowSource = "SELECT

I have two DB's ... one has item, customer type tables used for
pricing and keeping track of which items a specific customer buys etc.
The "MaterialMaster" table contains a field named MSDS.
The second table is purely a list of items or groups of items for

I have a form which is being used to enter criteria of a report.  While this
form is open I would like to have an "Advanced>>" command that would
drop/expand the bottom of the form with additional search options.
My attempt: I inserted a sub form with the additional search options ...

How do I turn a Yes/No field into a string?
I have successfully turned numbers and dates into strings that can get
concatenated with the rest of the code, but I cannot find Yes/No
examples. The part where I wrote [[[SOMETHING]]] is where I need to

I am trying to use an update SQL statement to clear the values of several
text fields and change a Boolean field Attended to False
I get error 3075 when I run the SQL statement:
strSQL4 = "UPDATE tblParentAppointments SET tblParentAppointments.PupilID  =

I have created a custom toolbar and associated it to a specific form.  I can
get the toolbar to open when the form is opened, but can't seem to find a way
to turn it off when I close the form.  Any help would be great.

I have a form (frmDiscs) which can be opened from several other forms.
In this particular case, it is called from a button on
frmVocalArrangements.  On closing frmDiscs and after updating its
subform (frmDiscsSubform), I want to return to frmVocalArrangments at

When entering data in forms, after pressing <enter> key, one can choose preferred cursor behaviour:
a) doesn't move (stays in the same textbox)
b) moves to the next field (same record)
c) moves to the next record.