I am using Access 2002 and I have a form that has a command button when
press a subform will appear as a datasheet view.  My question is how do I
close that datasheet view?   Any tips or suggestion will be appreciated.
Thank you in advance.

Hello and thank you
I had code from one fellow to help with my problem.  I needed to be able to
Count each new record (form) over a month period and restart from 1 each
month.

intStore = DCount("[Assignee]", "[tblAssignment]", "[Assignee] =" & "'" &
Me![txtAlias] & "'" And [Status] = No)
I used the above codes to count the Assignee from tblAssignement where
txtAlias in my form matches the value AND that the [Status] in my

I need some suggestions on a simple form.
Field One: Box number - no duplicates - starts at one - I may want to add a
box number or pull up an old box numbers If I put in a old box number, I
want that record to fill the fields. If I put in a new number, I want the

I've got an Access 2000 form with some simple VBA code on it to hide
(visible=false) some fields based on data content.  Works great when editing
the form.   I've embedded that Form into a Report, so I can get a nice
print-out with more layout control, but when I print the report ...

I want to filter my subform (bound to table) when it loads. I've tried the
codes below but it returns "You cancelled the previous operation"
Private Sub Form_Load()
Me.FilterOn = True

I developed a split database application and, after everything was working
great, moved to a SQL Server backend.  All is well except the DoCmd that I
used in the event procedure to advance to the last record no longer works.  
When the form loaded, the last record would be ...

I'm trying to set the RowSource property of a combobox for a value list. I
want to concatenate variables
into the statement. The combobox will have two columns, the second of which
will be hidden to the user.

I have an Access form where we track tasks that we do.  I want to be able to
enter details of a particular task when that task is selected from a drop
down list.
For example, if "new contract" is selected from the drop down list, I want

I'm having a problem that has been driving me crazy for days. I've checked
other's postings and have tried many of the suggestions to no avail.
I'm using Access 2000. In one database, I am using a form called EnterNewOrds.
It has an unbound combo box that does a record look up in ...

I have a one to many relationship established [with referential integrity
and cascade updates] between my regions table [one] and my contacts table
[many]
From one users' PC, when you are in the datasheet view of the regions form,

If I take 4.00 and divide it by 1.0825 I get 3.6951501
when I multiply this by .0825 I get .03048498, except in Access I get
.3300000   How can this be?  How can I correct this?
Thanks

I have continuous form subform "sfrmProductComponents on a mainform
"Products" to enter/view Product details.  The subform is based on a query
joining several tables.  I have a combo box which selects
ComponentsCategories and  displays a dialog form via the afterUpdate event to

I have a form to enter shipping information for products. When an item is
shipped, inventory must be adjusted. I've set up a command button to
automatically open the inventory form and would like it to automatically
populate like fields from the still open shipping form. How can ...

Could anyone suggest a website that has one or two examples of how to use
the percent position property?  It looks as it if ought to be simmple, but
I'm not getting it right.
Thanks