With a query I would like to pull out those records where field1 OR field2
have the value -1. How can I achieve this?
Thanks,
john

my company has an issue and I have to solve it. I have to create a
multiple users application, its basically a form that stores data on
just one database table.
To make it faster i wanted to use MS Access because they need it really

I get the following message when I try to open my database:
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 have not changed anything on my computer or

I have a lengthy form containing several fields of data.  Each record
that is entered is given a record identification number.  Sometimes the
user gets midway into the form and has to stop to display another
record.  The current unfinished record is saved and retrieved later

Greetings!  I am designing an Access '97 database for my company and
have run into an issue as to how best to record the various features
for the items we sell.
For example a refrigerator can have the following options:

On my order form i have delivery date field. I now have a button that
creats an email to tell the customer the delivery date.
in the VB code i have used me.deliverydate. This puts the correct date
on the email but its in the following format  8/9/2006 but i would like

Another basic question from newbie. I have a 10 million record database
of patient contact with their physician. The original file contained
all thier clinical information and personal characteristics. Each
patient record was repeated for each visit. I only want a table of

I have a student database where I would like to be able to print just
one mailing label, for the student whose record I am currently
accessing on the form.  I want to be able to click on the command
button and have the label print out on my labelwriter.

I am creating a contact database and I would like the user to create
his own groups of contacts based on criterias, thefore I would like to
let him pick the fields and criteria for a particular group.  I don't
wanna a form full of fields that ask the user for arguments.  Instead a

I'd like to set a combination of fields as primary key is that
posibbille in access?
let's say field1and field2 can have duplicates but there should be no 2
where field1 and field2 have same values in both records

How can I make sure the button I drag into a tabpage will become a part of
that page in stead of showing up on all tabpages?
thanks,
john

In this single-user app I have a form with members. In the related table I
have a field 'Select' with which the user can select a record. I have two
buttons on the form (All and None) that select either all records or none.
Those buttons both work with an edit query. It works ...

One of my users had a corrupt front end that wouldn't open.
My app is launched using a launching application (logon app). The logon app
has a button for downloading a "fresh" copy of the front end from the server
to the user's PC. I thought that this was a good idea since Access ...

I have this code from a db of a previous version of access to archive
a database, but I'm using A2K and it doesn't seem to work.  Can
someone help me?
Code:

Hi, I have a small personal database.  Yesterday it wouldn't let me
open it and gave me the following error message:
The Microsoft Jet Database engine stopped the process because you and
another user are attempting to change the same data at the same time.