I am getting a compile error - user defined type not defined.  The VB code
lists
Private Sub cmdReport Click()
Dim qdf as DAO.QueryDef

Can some one assist me? I would like to temporarely display the calender and
select the date in a form and capture the desired date.
I am a novice at this
Charles

I'm doing a project in Access 2000 using forms and MS Forms 2.0 combo
boxes.  I'm not using the native Access combo box because it lacks an
Add Item method and is therefor very difficult to populate.
I want to do something when the user makes a selection in the combo box

I want that in My Access Form in one of my Text box only Numeric values
should enter when user try to enter text in it,......nothing should happen

i've created my form and have a query that runs within a subform.
This is working fine except that the same query runs in a separate
window also.
How do I prevent the separate window from opening but only run within

I am trying to create a UserQueryForm which allows a user to:
•    Select values from several fields of criteria;
•    Select multiple values within each field;
•    Create a report based on the selected criteria.

I have my form set up that 3/4 of the controls autofill (have an ubound
control with default values = "field names" of what I want to autofill. Then
On Current of the form Call up the autofill) based on the previous record
when the user hits the new record button. I would like to ...

I found a function, that I have since lost, that can be called from the
On Mouse Move event of a label causing the cursor to change to a hand.
Can someone please point me to this function. Searched all day
with no results.

In Access2003 when a string does not fit in the ListBox control, I can
left-click on visible part of the string and in about 1 sec a tooltip
balloon will popup and show me entire string.
When is Access 2000 left-click does NOT show that tooltip. Maybe this

I have a form for orders and a subform for order details. After invoicing a
checkbox turns to "Yes" which means the order has invoiced.  I have done a
code to lock records non editable. It works on the main form perfectly but on
the subform not. The code is following:

I use forms to produce a letter containing some standard info and the
client's name and address in a box for a envelope window. The user just
enters a specific message in a text box (control is a memo field). It works
fine for one page but they need can't write more than will fit ...

I am running this event from a control on a sub-form that refers to another
sub-form.  (I have a main form, subform and subform)
The innermost subform is in Datasheet view.  This code does what I want, but
it open the sub-form in a separate window.  I'd like to modify it so that ...

Im looking for assistance.  
This database is used for evaluations. so a manager completes a form that
has 25 questions.  They do 4 evaluations a month on each employee.  I have 3
tables the Evaluation information (Table 1), The Answer Information (Table 2)

I have a question about filtering using the standard toolbar functions. How
can I maintain or restore my orderBy settings when a user chooses Apply
Filter, Remove Filter (or Apply Filter/Sort, Remove Filter/Sort)?
thanks.