I am building an interface form that I am using the DatePicker (ActiveX
Control) so that it will feed the selected date range into a query that I
have built.  How do I get the dates to feed into the query's field?  

So I added a field to my table to store the selection from the option
buttons. That works fine, is there a way to be able to choose more than one
option and store those results?

I am building a form in which I need to make calculations. I need to ask a
calculated field with two decimal places to create
(1) a new number which is rounded UP to the nearest whole number if it is
over a pre-set whole number (even by .01) and

I have an Access 2000 application that uses extensive VB code.  It works fine
on Access 2000 systems that use Win2K.  On newer machines - still running
Office 2000Pro - that have WinXP, the date picker crashes.  I think it's a
DLL missing.  Any ideas?

   I have the following code on the On Click event of a command button:
Dim stDocName As String
   If Not IsNull(Me.ID) Then
      stDocName = "rptTopTen"

I want to display a field as currency but I want the value to appear in red
if the value is negative and 'default color' if the value is not negative.  
Is there a way to do this?
Will

Is it possible to make a contextual menu on Access. (that shows on the mouse
right click)
If it is the case, would please tell me how, or redirect me to a website
that shows how to do it

I have simple continuous form.I was entering data and everything was OK
until I did the sort once by the
A|Z sort in the tool bar. Afterwards I can't make the form to behave in the
earlier manner.After each insert

Good morning all,
   I am having trouble with string vs numeric in a multiple DLookup and
using multiple lines. Here is the code I am trying to finess (I only changed
variable names to music topics, to help me represent my problem). I know the

I have a control ProviderID which is a Combobox on the subform "frmAPS_Sub".
Parent form is "frmInsAnn".
I have set the column properties for the combobox as:
Name:=ProviderID

I'm not good at programming vb so I'm not sure how to go about using
code to get the current record #, in addition to the total number of
records, to show on my form.  I've hidden the Record Navigation bar to
simplify my form (make it idiot-proof), and would still like to show

I have a database that tracks companies the ask for information as well as
who requested the information. The database has one table and is in Access
2002.
I'd like to have the data in selected fields automatically be copies to like

I have a form with autoNumber set in one of the ID Number fields.  When I
open the form to update the form, all of my fields are marked with #delete#.  
Please advise.
Thanks

Is it possible to edit data in an Access 2003 pivot table? If not directly,
are there any workarounds?
I was seeing if I could e.g. do something via a click event in a cell, but
it does not fire. It appears there are some events for the pivot table