I have a select query that groups records together, specifically
baseball players and their home runs and at-bats. I want to create a
query that displays [HR's], [AB's], and [HR's per AB's] and that sorts
ASCENDING on the [HR's per AB's] field.

With A2003, I'm having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located.  Here's the
scenario:
1) Computer #1 - A2003

I keep getting this error:
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.
There is no other user. I've tried moving the table to another database, by

I am not sure if what I want to do is possible, and if it is I have not
been able to figure out how to do it.  This is what I would like:
1. I have a data entry form with a field called Insurance.  That field
uses a combo box which takes its information from query on the

We are evaluating the prospect of integrating and/or using Crystal
Reports with some of our current products. Some of these are still in
Access 97 and are running well. Since we cannot include the report
wizard in a runtime environment, we are looking at ad hoc report

Hello
I am looking for the MOST efficient way to pull data from an Oracle
backend. By most efficient I mean will have the least impact on the
LAN. I am trying to pull specific data by date and put it into a local

When you enter an option group you can move to each option with the
arrow keys and select with the space bar.
Option groups don't have keydown events so has
anyone come up with a way to allow keyboard entry for

I have many forms but all the information is related to one another.  I
wanted to know if there was a way that if someone updates a account
that it will show the last date modified on all the forms.  I have been
trying to do it by a click but it is not seeming possible.  If anyone

I have a form with 4 combo boxes. They are used for selecting
SchoolName (lists 28 names), LocationName (lists 4 geographic
locations), EquipmentName (lists 14 equipment types) and
ObservationNumber (lists count number 1-3). All of the the combo boxes

I am looking for the most efficient way to programmatically batch
import excel files into MS Access.  The excel files are not lined up in
a row and currently I am going to each file so I can sort them into an
order for importing into Access.  If anyone could help me with this, it

I'm trying to create a form that will display the results of a query
that the user will decide on the fields searched.  I need a form that
shows several fields, possibly in a list box or series of combo boxes
that the user can select the fields to search in.  Then I need to use

Quick question that I'm sure is just me missing something obvious.
I have ONE form that continuously displays as a table and I can't
figure out why.  There is a drop down box in the upper right corner
saying "Form displays as a table" but I can't change it to anything

I am studying an IT course and thought I was just beginning to master
the basics of normalization. However I came across an example in my
text book that wasnt what I would have arrived at.
It was the structure for a transactional database which allowed several

I have finally completed an application and am preparing to install it
on a network of 10 users.
The application will be split FE/BE.  The application has its own
login, which controls the

I am editting a database created in access 2003 by another programmer.
This person has left the company for which the database was created and
no documentation.  So that I could work on this database at home, I
have converted this db to 2000 which is the version I have i have on my