I am putting together a purchase order system and would like to automate the sending of the record(s) to the supervisor for approval.
Any help would be greatly appreciated.
I am putting together a purchase order system and would like to automate the sending of the record(s) to the supervisor for approval.
Any help would be greatly appreciated.
What do you mean by 'automate'? Send records how? Some event must occur for something to happen: form open, button click, form close, database open, etc. Then code can compile content for body of email.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Click a button to send the record to user.
Really not giving enough information to provide any meaningful answer - why send an email? To one manager? different managers depending on something? How are they supposed to respond? what does the email contain? do multiple records apply to one order/approval or many?
Why not just have a boolean field called 'approved' and initially set to false. If the form is opened by a manager, it can be filtered to just show those records which are not approved - they can then tick to say it is approved
and if you want to send an email - google 'CDO' - here is an example https://access-excel.tips/send-email...ct-olmailitem/