Gurus, I want to be able to type in new data or alter data in a table
(datasheet) view.
When i do this in datasheet view, MS Access shows an icon (little pen
writing) on the extreme left hand side of the datasheet view confirming i can

Hello Access gurus,
I have a form that contains a subform. This subform has continuous records
and each record has a button attached.
The purpose of the button is to move the current record to a second table,

I am using windows mail for incoming and outgoing mails. But, when i use
"sent to mail as attachment" tabs from MS word or XL as , it is going to
outlook only. How to get it changed to Windows mail.

Right now, I've got 5 different tables (A-E) that each have a field
for a Date, Name, and Profit.
I want to find a way to calculate each record's profit as a percentage
of the maximum across all 5 tables, restricted by records of the same

I have this query.
SELECT BOOKS.Number
FROM BOOKS
WHERE (((BOOKS.Number)<=[Enter the number:]))

I have a query that selects records based on the data in two fields.  I need
to be able to add to that list the previous and next records of each of these
records based on the PK which is an autonumber field.  How do I accomplish
this?

This code fails at run time with the error shown following the code.
Dim strX as String
strX = [Forms]![Reports Dialog]![Combo62]
MsgBox strX

Please help me create a function to
1.  returns a value of 1 if the expression ("date") is the first date
from a specified set of records.
2.  returns a value of 2 if the "date" is the second date from a

I ant to assign a ranking to records based on two criteria. Each record
within my DB has a Year and a Quality Scoring. I want to add a field with the
relative rank (counting from 1 upwards) for each recod based on relative
Qualtiy Scoring within the Year.

I have been kindly helped with the following query on here and it works very
well.
SELECT BOOKS.Number, BOOKS.[Number 2], BOOKS.BookDate, BOOKS.Forename,
BOOKS.Surname, BOOKS.Unit, BOOKS.Returned, BOOKS.Archived

I'm trying to write a query that looks at a particular date field to
see if the record should be included in my counts. In most cases, this
field is blank, and is only filled in on certain cases.
I want my query to look at records where the value is not null and

What do I have to do to get information in an open window to scroll
smoothly. When I try to scroll through a page it is all jerky, even when
moving the scroll bar.
Apreciate any information as I can't seem to find a cure.

I have 30 sections in my office, i have a database with a form for
each section. How do i create a form that will let them choose their
section from a pull down and open their form based on their section
selection.

How to relate field as Long Integer in one table with another filed as Text
in another table?
Two tables are from different database and I cannot change field type by
modifying table.

After saving my queries or relationship diagram, next time I open it , it is
mixed up.