Is there a faster/cheaper way to determine the number of records being
displayed in a continuous form?
I always did:
dim rs as dao.recordset

I have been trying to convert an excel spreadsheet to an access
database for a while now...and I'm at the point where I'm pulling out
my hair. I've looked high, and low, and I've pulled out all but 2
strands of hair on my head, and 1/2 my eyebrows are gone.

Here's the situation:
I'm trying to use an update query to copy data from one row to another.
Here is the situation:
I have 5 companies that are linked to each other.  I need to show all 5

I am doing database documentation and run the procedure below to list
the record count for each table in the database.  The results in the
immediate window only a partial listing of tables.  It appears the
ones missing are linked (ODBC) tables.

Overview:
  Each Preventative Maintenance (PM) check has to have a running log
of the days that it was completed.   For each date, I need to know how
many days it took since the last check.  I will need that information

Does anyone know the newest version of ms access

I have a field where the format is set to currency, However I want to
use a Calculator type Number Pad to Enter the Dollar Amounts in gthe
field.  I have this part figured out but I keep getting a Type Mismatch
Error.  Any suggestions?  Thanks.

I've got two tables in my DB, a Client table and an Event table.
There are many events for each client.  The form I designed is based
off of the Client table and the subform within it is sourced from the
Event table.

PLEASE HELP!

I have two tables(and the corresponding forms) with following fields
Table 1 (Form1)
Field1
Field2

How can I connect to a database backend that is password protected?

F1 is a key when we need to see help, but if I want to use this key for some
other purpose, for example to open a form, how to avoid getting the help
file?
Thank you very much

I have a db that I have split into FE/BE but which also uses a dozen
or so linked tables from a SQL Server db. I have linked the SQL tables
to the FE *rather than link them to the BE then link again to the FE),
so how do I create relationships between the tables in my BE db and

(Access 97)
I'm creating a query (QRY_SUMMARY) to join a query (QRY) to itself
(QRY_1).  I'm returning QRY.* and selected fields from QRY_1.  With each
field (field_name) I return from QRY_1 I'm appending "_1" to to the end

I have set up two date fields in a table:
1stpromisedDate and CurentPromisedDate
The first field is to record the 1st promised delivery date of a
supplier and the second is to record the current promised ate from a