TIA.
in msa2k, i have a form with almost about 50 text box date fields
(divided into planned and actual dates) being used for managing dates
in an ordering project; the mdb is conected to a sql server 2000

I am looking for a way to have an access form update for multiple
users.  I have a form where certain fields will be updated on
individual computers, and there may be 3 or 4 users that have the form
open at a time.  Is there a way to have all users forms simultaneously

I have Access 2003 created database that I have been running in Access
2007.  Lately a couple strange problems have cropped up:
1) I have a Form that opens via a button on another Form.  Now in
Acc2007 if produces a "Error number 3011: the Microsoft Office Access

I have an application with a number of tables, one of which I named,
Calls, which holds information relating to telephone calls.  Anyway,
making a copy of the database file, then making a number of
modifications to it, I deleted all of the records in the Calls table of

Re:  Access 2003
In my Access app I am needing to see if an .exe file is loaded locally
before running it.
The thing is it might be located somewhere ele other than the default

have a query that has a <>0 in a summed number field. The query runs
extremely slow (30+ seconds) when this parameter is in this field. If
I eliminate this parameter the query runs in milliseconds. This is a
query on a linked odbc sql server 2005 table. Any thoughts on the

I'm using the following SQL statement to find the next highest
autonumber value in a table where "CDUGActID is the autonumber field
in the "CDUGActuals" table:
SELECT CDUGActuals.CDUGActID, CDUGActuals.ActualTonnes, [CDUGActID]+1

I have a method in place in my application to force users out. It's a
simple tactic I got from these newsgroups where you create a table
with one record called logout, then check that field with a timer on a
form that doesn't close. If it's checked, it starts a forced logout

Has anyone had trouble running macros on the Access runtime version on
Vista? I tried enabling macros in the trust center, and thought for
sure this would solve the problem! But, alas, my hopes were in vain -
I still get the 2950 error when the Autoexec macro runs. I don't think

I have a parameter query that requires the user to enter a Start Date:
and End Date: and pull data between that date range. I am currently
using the following parameter;
Select *

Read the posts about the trust centre, has anyone else encountered
this?
I've set up a trusted location for my front end, and that works OK on
my development folder.

In Access 2007, is there a Windows Explorer control (similar, say, to
the calendar control) that can be put on a form, will browse to a
folder and return that folder's path to the field with which it's
associated?

Can someone please advise if (and if so then how) i can refer to a
combobox column by name and not index, i.e., instead of
forms!myform!ComBx.column(2)
i could refer

Access 2003
I have a form (bound to a query) and would like for the user to check
a CheckBox to filter records based on a value of one of the fields.
If the CheckBox is not checked, it should show all the records.  Here

I have a database in MS Access 2000.  I have a field that needs to be
filtered repeatedly.  Currently, after the field is filtered, the
filter must be manually removed prior to filtering on that field
again.  Is there a way to clear a filter that is in place by simply