Again... creatiing table for each group

  • Thread starter Thread starter Akira
  • Start date Start date
A

Akira

I have a process where I query a database for errors
which I group by user and send the list to them
there can be different users showing up each week
I know I can run a seperate query for each user; but I'm
to lazy to cut and paste into outlook.

And want to know how I can group the errors by user and
make a table for each user so that I can send each table
to the user
 
Create a form with a text box control for the user name
(ex. tboxuser). Create a Button on the form with the
Click Event to VB code saying docmd.sendobject... and the
name of query to send. Check your help for the
docmd.sendobject settings.

In the Query Critiera under your user field say
=tboxuser. If you set it up properly, the form will only
send the query information for the selected user. You can
also set-up a pull-down combobox to pick the user on your
form. If I understand your question this should work.

Kevin
 
I know I can run a seperate query for each user; but I'm
to lazy to cut and paste into outlook.
Click to expand...

You do not need to cut and paste into Outlook.
And want to know how I can group the errors by user and
make a table for each user so that I can send each table
to the user
Click to expand...

It is EXACTLY as easy to export a Query as it is to export a Table,
and it is done in exactly the same way.

You can use VBA code to loop through the users running a query
repeatedly for each one (you'ld need to do this for your wasteful
MakeTable queries too, so it's no more work than you already need to
do).
 
Back
Top