Can someone explain to me the following:
I have a Listbox on a form. I set the GotFocus property to [Event Procedure]
and then define a function. Do the same for LostFocus:
Private Sub cboSchoolNameSelect_LostFocus()

I'm trying to cancel all/any changes or additions made on the form when the
form is closed (ie, the user close on the form without clicking on the
'Cancel' button on the form), by clicking on the top right 'X' of the form.  
This form is basicaly a data entry form.

What is the code to select more than one item from a combobox ina form?
Any help, reallly appreciated
Thank you,
Lincy

I have a report where at the footer I have:  =Count([WIMS_SUB_VEND])
Is there away to have the report start with the highest number of
[WIMS_SUB_VEND] first like
item 1    has 108 items

Are there any limits to the amount of VBA code that can be put into an Access
2003 database?

Hey everyone!
Does anyone know of a way to physically time how long it takes for someone
to complete a form?  For example, as soon as they start entering text in the
first field, a timer (in the background - they don't have to see it) will

I have a main form [orders] and a nested form [items] - depending on the
order type, a different [items] form will appear - this can vary from order
to order, but within an order, the [items] form will always be the same.  
Also, there may be multiple item records within one order ...

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make edits to
that data.

I want to use VBA to control the values in the "Save In," "File Name," and
"Save as Type" text boxes when the Save As Dialog box pops up.  I don't know
how to refer to those text boxes to set their values.  I also want to use VBA
to "click" the Save button.  I am using Access 2002-3 ...

I brought some work home this weekend and created a couple of new forms.  
Everything worked well (both home and work are using A2k3, SP3).  I brought
my db back into the office this morning, and started having problems almost
immediately.  Access didn't like one of the forms I ...

Only a test for
http://microsoft-news.for-um.de/
thanks for your understanding
admin microsoft-news.for-um.de

I've recently noticed a huge increase in the number of SPAM messages being
posted to the Access newsgroups.  Doesn't anyone from Microsoft monitor and
police the groups?

I have a date parameter in my query

I looks back 15 days. I search by vendors and sometimes some vendors
do not have any records in the last 15 days. How can I get a

I have a ComboBox on a Subform that Auto-Fills 3 text boxes.  If you select
from the list the first time you can type several letters and click on the
vendor you want.  If you decide you want to change the vendor you can click
on the arrow and the selection list appears you can ...

This is not working for some reason.
Private Sub cboCountry_AfterUpdate()
  On Error Resume Next
  Select Case cboIssueCategory.Value