How can I trigger a e-mail when new data is entered in a table without
a form?
Thanks

I have a question regarding normalization of a database.  I am trying
to model the inspection and repair of items.  Also need to track when
they go in service, out of service and several other actions relating
to the item.  My first shot has the following structure:

I have 3 colums: 'Task' , 'Case ID'  and ' Time'
And i would like to have an overwiew of the last task (the taks with de
latest time) of every Case ID.
Example

I'm trying to create a adodb recordset in an Access Module for updating
but when I try to open it it returns EOF.  However, I can cut and past
the sql into QueryBuilder it returns the record. At a complete loss on
this one.

I have 2 tables: LOCATION and ELEVATION
In location, I would like to find the record with the max value for
field: DATE1
In elevation, I would like to find the record with the max value for

I've got a report that's not sorting correctly.  I build a SQL
statement and assign it to the recordsource in the Open event, sorting
the data the way the user chooses.  The user can choose up to 3 sorts
using a form that opens before the report opens.

I've got an app whose purpose in life is to do technical analysis of bond fund
returns.
Each return has a "Date", but the "Date" is really just a month/year.
i.e. The return for January of 2005 or the return for April of 1996.

I have a situation where i have a number, such as "6", in an alphabetic defined field. I
need to convert that "alpha" number to a numeric so that I can use it to refer to an ID in
a table. Can someone please give me the right way to make that conversion, please?
Thank you very much.

We have an Access database Sch_S.mdb in the shared driver S across the
network. I have a copy of that database in my local driver C, named as
Sch_C.mdb. As per users' request I added some check boxes in the main
form of the database, and added some relevant subroutines in that form.

Suppose I have this simple SQL string...
SELECT tblDrivers.DriverID, tblDrivers.DName
FROM tblDrivers
WHERE (((tblDrivers.DName) Like "N*"))

Most of my Access database implementations have been fairly small in
terms of data volume and number of concurrent users.  So far I haven't
had performance issues to worry about. <knock on wood>
But I am curious about what techniques those of you who have done higher

   I have a normal application split into a frontend and backend.  The
tables are in the backend.  All tables open correctly from the backend.
When  in the OBJECTS window (F11) in the front end, one table will not open
in datasheet view.  I get the error message 3075 "Syntax ...

I need to find the first date of ship_date from table B for in my query of
table A.  The common field is model.
Table A
Fields: Model, dev_date, tool_off_date

I've looked at all the age calulation solutions - but I'm a little
stumped on how to set this one up. Here is what I need to do.
I need to find all the kids in my DB that are currently 11 or 12 years
of age

I would like to redirect a form to output it's recordset to Excel
rather than the Access report.  I have the code to send SQL or a
recordset to Excel, but how do I extract the datasource from the
report?  This would be at runtime, either when the form is called from