How do I get a form that opens in datasheet view not to maximize on open?  
Can I get it to open a particular size?

I developed a form for me to input information to track a number of assigned
tasks.  It shows who they are assigned to along with an estimated completion
date and the has a check off to stop showing the information in the form when
the task has been completed. The form takes the ...

I have three forms, i need my combo box to show all the three forms name, and
when i select the name it should open the form...

In a multi-select listbox, how can I detect if the user is clicking on an
already selected row? I need to take some action if the row is being selected
but not if it is being unselected.
Thanks.

I have a form with a drop-down box that allows users to select a
question number and then see the other data fields associated with the
question. This is working. However, I want to *selectively* allow
users to edit only date fields that are further than 30 days out. I

I am having trouble with a simple filter, hope someone can help.  I
have a form based on a query.  I am trying to filter the form's output
by the text of a textbox.  The event is a command button.  Here is my
attempts at the code, none of which worked

I have the following :
Private Sub Command160_Click()
Dim blnMissingData As Boolean
If IsNull (Me.Staff_Name) And (Me.Location) And (Me.Gender) Then

DB/Form format: Access2002 running on Access2003.(yes I could convert it to
2003 if necessary)
I have a main form with control buttons on the left, subform on the right,
and the header will have the record selector to select the contact  I want

I've made some forms and all my data is entered and edited within
those forms. I've also made a switchboard from which all my forms can
be accessed. I've also added commandbuttons like Edit record, Quit
Access, etc. So there's no need for manual data adding or editing

OK,
I have done this before and know it is killing me that I cannot get it Right.
I want to do a DSUM on a particular Column.
Alive, Double

This has been a mystery to me for some time now...  What I am doing is
assigning a query to a Com.commandText object by saying:
com.CommandText = "INSERT INTO table (field, field1, field2)" & _
"VALUES ("Value", "Value1", "Value2");

I have the following problem:
I would like to make a personalized msgbox (in my own mother language, that
differs from the access version i have installed), when a parent record (in a
one to many relationship without cascade delete) tries to be deleted, i.e.:

I have a table with a field [date] (yes I know this is bad practice, but I
inherited the db and haven't yet been able to amend this field name), and
other fields (coresponding to employees) called [sarah k], [pat g], [ver b]
and others. I have a form based on this table, and in ...

I want to put a button on the switchboard so that users can open a blank form
immediately.  I have figured out that all I need to do is add
DoCmd.GoToRecord , ,  acNewRec to the form opening event.  
Now if the record source includes a multivalue field, how do the users deal

I have a form with a footer that is not visibile when the form is opened.  
The only time the footer should be visible is when the user clicks a button
to add on the form to make the footer visible where a textbox is also hidden.
My problem is this: when the footer becomes visible, ...