I have a form I want maximized.  I added DoCmd.Maximize to the form
Open event.
       I set the property sheet for no min max buttos, but a minimize button
still shows up next to the close button (which I have to have.

I have a combo box with 3 columns and want all 3 columns to be source for 3
different controls on the form.  
Also a subform needs 2 controls from the mainform.  I don't know VB well
enough to know what code I need to put to make it do this.

When I click on a command button with the following code, I get a Type
Mismatch Code.  Although the error message shows "Type Mismatch" it opens the
form and lets me save any changes, etc.  Can anyone think of a reason why it
would give me this error?  I have checked that all the ...

Have a Main Form Named Enquiry_Input, Where The Data Source Is a Query
Which The Query Is a Representation of the Enquiry Table, With An
Addition Project Title Field In The Query ,
The Project QNo Field is a Look Up From The First Column from My

I need a button on a form to switch from Form View to Datasheet View.  How
can I accomplish this?  User needs to be able to switch from Form View to
Datasheet View but will not have access to full menus.
Thanks.

I would like to create a "yes/no" field in a datasheet view that is based on
a linked table that I can not modify.  Is there a way to create a temporary
table that I can pull into the query that could contain this "yes/no" field
without having to actually add a field to the ...

Vista Ultimate / Office 2007 Pro
Great to have the split form funtionality in Access...but...I've have two
issues I hope someone can give advice on....please...
Firstly,

I have a form for my table called Activity and a subform where users can
select other activities to link one activity to another in a table called
Activity2PostActivity.  My row source for the combo box that I am using is:
SELECT Activity.ActivityID, Activity.ActivityName, ...

I am quite new to Access, know what I need to do, quite happy to try but have
got stuck.
I have a sub form that details any work passed to a contractor and whether
it is completed or not.  On my main form I have a completion date.  I want to

I've created two forms in the same database. In the first form I must use
Tab to move through the fields -- the second form allows the use of the
Enter Key. How can I get the first form to accept the Enter Key? Right now
if I push Enter by mistake in the first form it erases the ...

I have two forms, form1 the user gets a menu (copy, etc...) on right click of
the controls. Form2 no menu on right click. I checked the properties of both
forms and both are the same: for the forms, menu bar property is blank. For
the controls, shortcut menubar is blank. How do I ...

I would love a little guidance here.
I am trying to create a subform that when opened shows all the fields that
need to be filled in.  The two tables below are linkd to a QDAAssessment
table (by QDAID), so I need a new form for each assessment.

Is there a property that i can set on a text box that every time I open a
form the text box will be empty?

in my report the unitprice field is rounding up. in the form it is 833.33 but
in the report it is just 833.00? any suggestions?

Is there a way to make a form display customer info and a list of all
products available with price and an empty quantity field.
I have 3 tables, customer, products and order.
I am trying to create a check out form that will sub total prices and