Search results

Hi, I have the following set up: Tickets - table New Tickets - form The fields in the form are: cboOpenedbyUserID txtRaisedby txtAssignedtoUserID txtSummary txtCategory txtPriority txtKeywords txtDescription cmdEmailAssignedto I would like to be able to email the 'Assigned'...

Hi, I hope someone can help, I want to be able to send an email on completing a form using a field within the form if possible, here is what I have... Tickets - Datasheet New Ticket - Form AssignedtobyUserID Row Source - (Users table) ID, Email and Full name I have 2 command...

Again thank you for your help. I am really struggling as to where I put the code, how I 'call a function' or 'pass the variable'. the code I have entered is not a standalone module. I appreciate your help but I think without a more hand holding situation your help is lost on...

Thanks for the quick response, i have removed the previous code and entered this as a visual basic module however nothing is happening, no error messages and no email? Is there something i am missing here? Many thanks AJ

Hi, I am new to this forum and to Access, i have very limited knowledge of VBA and am currently teaching myself how to find my way around Access. I have currently got the following set up: Tables AccessControl HelpdeskTickets LeaverRequest Users Forms AccessControlRequest NewTicket...