A table :  Nameperson, Book nr, Bookdatein, Bookdateout, CD nr,
cddatein, cddateout, dvd nr, dvddatein, dvddateout.
I would like a query where a see the personsname en de last book with
the datein and out , the last cd with datein and out , and the same

I need to scan various network folders and capture all the filenames and
create dates.
=======================================================
1st effort used the typical drive scan

When you create buttons from the wizard you can go on report options
and select mail report. This sends a report in a chosen format to the
mail software as an attachment.
There are two issues here the first being is there a way to set it up

A friend is thrying to send me an Access database attached to an email. I am
using Outlook but when the email arrives the attachemnt is missing. Any
suggestions, please? When changed to Excel it arrives OK.
Thanks, Robert

This must be simple but I can't figure it out. Table 1 1xM to table 2:
Table 1   IDfield
         1
         2

I've been given the task of building a database for a manufacturer's
representative.  He basically imports product and resells it.  He
currently has this spreadsheet that's fairly complex. (Either that or
I'm just plain stupid, because it took me 2 days to figure out how it

I'm wondering it there is a way to notify users of the need to use a
different version of Access (2003).  I have an Access 2003 mde file that
can't be opened by Access 2000-2002 users.  I would like to pop up a message
(instead of the Access error message that it does not recognize ...

I have used nearly every version of ACT for more than 15-years.
Currently have 5,000 records in one database and the program seems
unable to smoothly handle that many. Am starting a new business that
will have perhaps 20,000 records and considering ACCESS (although I

I?ve just recently started working with Access at my new job.  I?ve been
able to figure out quite a bit on my own, but I?m stuck with a problem I
can?t seem to find answer to on the Access help or website ? nor the
?Access Bible? I?ve been using as a reference guide.

I am lost with Access 2007... and I thought that it would be easier!
Don't get wrong.   I am focused with Access 97.  Although I worked in
2000/XP/2003, Access 97 was never far.
After 10 years, I am ready to rely on something newer.  More of that

Well we just finished a monster database for a group at work.
On one section, they wanted us to give them a filtered listing of
people based on 2 other criteria. So we used filters and contiguous
list to generate the listing and it was N I C E. Just the people they

Today I fetched the standard Access-2003 template "orders management db"
from
http://office.microsoft.com/en-au/templates/TC010185481033.aspx?pid=CT101426031033
In de openingform one sees a column "extended price"

I've got the following code on the "OnClick" event for a command
button on a form.
______________________________________
Private Sub EmailNotify_Click()

I have a form in a multi-user database that flashes when the form is
opened.  This is a failr involved form that contains header
information along with a continous subform.  Below are a few details
of the issue that I think might be relavent.

I a table with two columns:
ID       Note
---       ------
1        Andy was paid on 4/5/04.  He was working on the xxx project.