Never had to use/create one so am looking for guidance!
Currently we send out communications to new customers upon placing their first order with us (a thanks for using us type thing!)
This is a manual process at present and can be complex tracking back through our invoicing system, hoping to integrate into the existing access system we have recently started using.
form frmRubbishLetter contains subfrmRubbishLetter (datasheet of those who need a letter sent to them based on query qryRubbishLetterToSend).
Upon clicking 'export list' I need this to be sent to Excel (this I can do) and then:
To update 1 value in table tblenquiries for each record in datasheet (unique identifier is e_id):
e_date_due = +3 working days to value from txtDate on mainform
To update 2 values in table tblpeople for each record in datasheet (unique identifier is p_id):
p_send_letter = false
p_letter_sent = value from txtDate on mainform
To insert new record in table tblspeak using data from the query and fixed text data (3 values from qry, 2 fixed text, 1 date and 1 time)
Can anyone help get me started, I have looked at countless pages on how to update/insert values using recordsets however cannot make sense of how I can apply this to my database!
Thanks in advance!
EDIT: worked out how to reference recordsets within recordsets and have got it working!
Currently we send out communications to new customers upon placing their first order with us (a thanks for using us type thing!)
This is a manual process at present and can be complex tracking back through our invoicing system, hoping to integrate into the existing access system we have recently started using.
form frmRubbishLetter contains subfrmRubbishLetter (datasheet of those who need a letter sent to them based on query qryRubbishLetterToSend).
Upon clicking 'export list' I need this to be sent to Excel (this I can do) and then:
To update 1 value in table tblenquiries for each record in datasheet (unique identifier is e_id):
e_date_due = +3 working days to value from txtDate on mainform
To update 2 values in table tblpeople for each record in datasheet (unique identifier is p_id):
p_send_letter = false
p_letter_sent = value from txtDate on mainform
To insert new record in table tblspeak using data from the query and fixed text data (3 values from qry, 2 fixed text, 1 date and 1 time)
Can anyone help get me started, I have looked at countless pages on how to update/insert values using recordsets however cannot make sense of how I can apply this to my database!
Thanks in advance!
EDIT: worked out how to reference recordsets within recordsets and have got it working!
Last edited:
