Hello,
Im using redemption in a database created in ms access.
At the moment emails are generated depending on various actions within
a database. To give an example:
Public Const Email_StencilOrderer = "CA" 'Joe Bloggs
Then later on when an action is taken I will call this like so:
Call Email.SendMessage(GetEmail(Email_StencilOrderer), "Please order
stencil number " & stencilNumber & ".", "xxxx," & vbCrLf & vbCrLf &
"Please order stencil number " & stencilNumber & " (" & customer & " -
" & product & ")! The data is found in \xxxx\" & stencilNumber & " and
you can find other information (how the board is panelised, etc) using
the xxxxxxx' icon on your desktop." & vbCrLf & vbCrLf & "Ta!", False)
The problem is that people could well be changing jobs quite soon and I
wanted an easier way of updating the list of people who do various
tasks.
I'm thinking (sadly) that im going to have to create a table and have
everything in there which is going to mean a lot of re-coding.
I've never heard of a form updating code, but thought I'd ask anyway..
Ta,
Chris.