N
nevje
ok, i have a working order entry form/ set of tables
what i want to achieve is this:-
1. user enters that days new orders
2. user then clicks on a process all new orders button
3. access to collate new orders into email to the supplier - there is
only 1 supplier for this so only 1 email address.
access at this point needs to do a few things, for each new seperate
order (ie, order number 1, order number 2) i want access to create an
email to the supplier and then mark the order as processed.
my first thought is run a query that selects all orders that have not
yet been processed
then create a report for each new order based on this query and have the
report attached to an email - it needs to be a seperate email for every
seperate order number. (we are using outlook 2000 in corporate mode)
then have an update query run that updates all new orders as processed.
is this generally the right set of things i need to do? - currently i
dont know how to start this part - but need to know that access can do
what i am after?
any tips?
what i want to achieve is this:-
1. user enters that days new orders
2. user then clicks on a process all new orders button
3. access to collate new orders into email to the supplier - there is
only 1 supplier for this so only 1 email address.
access at this point needs to do a few things, for each new seperate
order (ie, order number 1, order number 2) i want access to create an
email to the supplier and then mark the order as processed.
my first thought is run a query that selects all orders that have not
yet been processed
then create a report for each new order based on this query and have the
report attached to an email - it needs to be a seperate email for every
seperate order number. (we are using outlook 2000 in corporate mode)
then have an update query run that updates all new orders as processed.
is this generally the right set of things i need to do? - currently i
dont know how to start this part - but need to know that access can do
what i am after?
any tips?