Hi guys.
i want a flag 2 go off within 5 days of doin a certain task (ie accepind a new clients' details & send some1 a mail aftawards, make an order via mail) Reason bein i wanna do a follow up and c if d requeted task has been attended to
Ma code:
Option Compare Database
Function Follow_up()
Dim Follow_up As String
Dim duration
Follow_up = "SELECT Customer_contact_details.* FROM Customer_contact_details WHERE Customer_contact_details.Date<Now()-5;"
MsgBox ("Please do a follow up on " & [Forms]![molo]![customercode] & ", " & [Forms]![molo]![Unique_ID] & ", " & [Forms]![molo]![CustomerName])
End Function
problem is i don't know where to put ma code coz i did it in a module and calles it in a macro as a function (runcode) but it's complainin dat it can't find d requested function
Pls kindly advise
Noks
i want a flag 2 go off within 5 days of doin a certain task (ie accepind a new clients' details & send some1 a mail aftawards, make an order via mail) Reason bein i wanna do a follow up and c if d requeted task has been attended to
Ma code:
Option Compare Database
Function Follow_up()
Dim Follow_up As String
Dim duration
Follow_up = "SELECT Customer_contact_details.* FROM Customer_contact_details WHERE Customer_contact_details.Date<Now()-5;"
MsgBox ("Please do a follow up on " & [Forms]![molo]![customercode] & ", " & [Forms]![molo]![Unique_ID] & ", " & [Forms]![molo]![CustomerName])
End Function
problem is i don't know where to put ma code coz i did it in a module and calles it in a macro as a function (runcode) but it's complainin dat it can't find d requested function
Pls kindly advise
Noks
