I have a group section footer in a Report in which I want to display
various "counts" (not sums).
For example:
some of the fields in the recordset from the query are:

I'm using access 2000. I have a table with a main key and another table
that maps to that key.
Tbl1              Tbl2
*ID Autonum--     *Mykey Autonum

I've got a Macro that runs a few Queries and then ends with a Report.  It
opens all the Queries and leaves them open and I'd really prefer that it not
do that.  Is there a way to just run the Queries and/or close them
immediately?

I have a fairly complex access frontend/backend app which I need to upsize
to SQL Server. At this stage I would prefer to use access as frontend. I
have the following questions;
1. Should I keep using the mdb as frontend or switch to an adp (access

  I have a database that uses an auto number field type that goes out of
sync periodically. My customer gets a "cannot add record, number already in
use" error message.  I dump the records into a new table starting at auto
number 1, and sequentially up to about 20,000.  ...

I wish to add some fields to an existing table in code.
I am using the following code from rkc.
CurrentDb.Execute ("ALTER TABLE MyTable ADD MyNewField Text 25")
This works , but I need to also set the Required, Allow Zero Length and

I'm trying to put together a  macro that queries my cell phone call expense
DB the selects records as of a specific Date that are not marked "Archive",
prints a report, then marks the records "Archive".
I've worked out the Queries and the report and even got them into the macro

G'day Guru's,
   A colleague at work has a Access 2002 DB which was up until last night,
working fine. However, now when he tries to open it, he gets an error
message "No current record". I have tried bypassing the start-up options,

Wanted to share a solution to something which I didn't find on the net:
EVERY form in my Microsoft Access 2002 database gave an error any time any
code was to be called: form OnOpen, button OnClick, etc.
Error was: <b>The expression On Open you entered as the event property

I have 800 rows in a table named tbl800CircleDataPoints.
There are two number fields named [X] and [Y] in the table.
Both are number (single) Type fields.
The data points in the [X] field range from -2 to +2, stepping by

Have a look at the procedure below. In particular, note lines 1 and
21...
Private Sub JudHrngReqBtn_Click()
On Error GoTo Err_JudHrngReqBtn_Click

Fat chance, huh? If its not in the public domain, it ought-a-be. As
much tax money spent by the USGS & other dept's, every US citizen
should be given a copy of s'ware near as powerful as MapInfo. Oh
well, enough griping, here's my question:

Title says it all: I have an Excel spreadsheet with a number of
worksheets. Can Access import them, and if so, what is the earliest
version that will do so, and what are the constraints?

We have a database that is in use 24/7, and does not get backed up by our
network backup software because it is always open. Does anyone have
experience with backup software specifically designed for Access which claims
to back up open Access databases? (One example is something ...

My db is stored in access and I have a field amount and its type is
currency.
When I read from the db and display it in a textbox, it shows me
15000000  instead of $150,000.00.