Please someone help
I have a transaction table "Accreditation" that I need to update from a
from. The form
should be able to display information from different tables.

I have a split database (A2K).  The back end was originaly on drive J.
IT changed some network stuff and eliminated the J drive.  The back end
is now on the F drive.  When the front end is opened, it looks for the
back end on the J drive and displays a message saying the filepath of

Are there any ways to speed up a Cumulative sum in a query or perhaps
another faster way to have a cumulative sum column (call a vba
function?).
For example, I want to sum up all values under 'Amount', and also have

I have a report in access and most of the fields are set up as YES/NO
fields.
I need to display those fields if and only if the value of the field is
YES.

One form in my Access 2000 mdb causes a crash whenever I close it.  The
crash is of the type where I get a "Please tell Microsoft about this
problem".
Easy, you think!  Well, here are the things I've tried already, all to

I have 3 seperate date fields.
InitialDate
InspDate
ReportDate

I have a tab control containing 3 tabs.
The control is about 3/4 of the way down the form page.
The problem is when i scroll down the form to the control and select one of
the tabs to view info in the control, the form page jumps straight up to the

We've a project for which we are using MS Access as the back end and VB
as front end. there are three terminals fromn whichusers access the
system. The table has 17 rows. When the number of records reach 12000
the system hangs.

We are now starting a limited public beta of a new security program
for Windows named "NaturalLogin".
The program can use one or more hardware devices (such as standard USB
storage keys) and/or custom questions to enable a multi-factor (2 or

Anyone know why when I set my tabs index in my tab control (I have 3
tabs on the control) the numbering gets messed up when I save the form
changes?
I thought each tab on the control had an independent tab index, I guess

I've written a module to create an ODBC link to a large number of
Oracle tables in an Access database.  It works fine when the table
appears in only one schema in the database.  However, when a table
appears in more than one schema, I get an error message, "There are

I am trying to create a Table structure to represent the relationship
between Agencies and their Sub-Agencies.
There are Agencies and Sub-Agencies.
Some Agencies have Sub-Agencies and some don't.

What is your position on advertising in this group?
Does permitting one poster to advertise, license us all to advertise?
Shall I advertise? Shall I create 5 pseudonyms (refreshed every couple
of weeks with different newsreaders and helos so that your kill file may

How can I replace a word in a field in all records?
Let's say that I have the record "address".
and the adress are:
37-08 east linwood st

Greetings.  I just discovered the 'Compact on Close' option in
Access-Tools-Options-General Tab.   It certainly sounds like a smart
idea to me.  But before I turn that option on I thought I'd check with
the experts to see if there are any reasons why I would not want to