I have an Access 2000 app (front/back end) running on a terminal server.
When one person is running the app, the speed is decent. As soon as one
other person runs this app, look out because it slows to a crawl!!  The
terminal server runs other multi-user Access apps with no ...

StaffPickComBx is not visible until an Add button is clicked.  Visible is set
to True and the combobox drops down, waiting for a selection.  I would like
to allow the user to change his mind without selecting anything, causing the
combobox to disappear.  The most intuitive ...

I've tried this in Forms Before Update, in each Control both before/after
update, still doesn't work as it should. I am at a loss as to what is wrong
with this code. Here's a portion of it. In Access 2003
Here's what I am trying to do.  This is an activity entry form, if the user

Apologies in advance for a long posting ...
Running Access 20002 (XP), SP3 on a Windows XP Pro (SP2 and later updates)
machine:
I've got a small subroutine which reads all sheets in an Excel file and

I have a continuous form with a control called TotalFTE that sums the FTE
field from the records that are displayed in the form.  This all seems to be
working properly.
My problem is that I want to check when the value of TotalFTE is 0 and

I have a simple form bound to a table.  I've created buttons for
previous record and next record.  Each of these buttons first does a
recordset.Update, then goes to the previous or next record.
When do I do the recordset.Edit to make sure it gets done?  Is there an

Perhaps I'm going about this the wrong way but here's what I'm trying to do:
I have a form called OrderAcceptance.  The user will designate the ordered
product(s) in the OADetails subform.  The Products field is a combo box
displaying either "Parts Order" (which could be anything ...

I'm trying this code:
DoCmd.OutputTo acOutputTable, "Table_A", acFormatXLS,
"C:\ExportedTable.xls", False
But I get this error:

I have a TranType combo box with 2 columns.  Column 1 is the TranID, and
column 2 is the TranName.  If a user selects "Revenue" in the combo box
(which is TranID 1), then it enables the Rate and Members controls.  This
code isn't working.  Can anyone debug?

How do I get a calcaulation field in a form into a field in a record ie: a
field holding a date and putting it into a field in a record that is named
date? Or takeing a field "lastname" and a field "firstname" join them
together and save then into a record call joined?

Can anyone help me on how to do the following:
I have a report grouped by Hospital name (total report 20 Pages).
Let say Page 1 for HopitalX, page 2 and 3 for HopspitalY Page 4 for HospitalZ
and pages 5 to 20 for

I have a Form (frmCustomers) that contains a subform (sfrmRevenue).  When
frmCustomers is opened, I want the curser to jump to a new record in
sfrmRevenue.  I believe my code is correct, maybe I'm just not using the
correct event.

I've got some fairly involved validation code run by my form's Before Update
event that tells the user if they've not typed  some essential data and asks
if they want to now fill it in (by way of the MsgBox function).
The annoying thing is that if they decide to delete the record ...

Ok, I have an application that has a close button. Sometimes when this
buttion is clicked, it exits the entire Access app. Other times it simply
returns the user to the database window!
I am using the "docmd.close" command and tried issuing a "quit" as well -

I have a form with a simple backend to it. There are two tables with a 1 -
many relation based on a single field.
I want the form to be able to show each staff member (the one side) and
their holidays (the many side). I also want it so a new staff member can be