The test box is for display only. just noticed combo box is not combo it is a list box that lists employee names from a table that just holds the names.
Control Source
Turned In by
Row Source
SELECT [Employee].[Employee] FROM Employee ORDER BY [Employee];
I have a form for users to submit a work order. The form is simple it has a combo box to select the name turning in the form and a field to state the problem. I want to add a text box that will look at the combo box look at a record based on selection in combo box then return the data from...
I got it to work thank you for the lead once again. The code that worked was
Private Sub Email_Click()
Dim stDocName As String
stDocName = "New Work Order Report"
DoCmd.SendObject acReport, stDocName, acFormatXLS, _
"emailaddress", , , _
"subject", "message", True...
Thanks for the lead on the DoCmd.SendObject. I was able to get close but keep snagging saying that object does not exist or is misspelled. Here is what I have so far
Private Sub Email_Click()
DoCmd.SendObject acSendReport, "[New Work Order Report]", acFormatXLS, _
"emailaddress"...
I have a Database that logs and stores work orders. This is a very simple tool that allows users to submit a work order by using a form. On this form I currently have a macro linked to a button that emails the new work order to a joint email account in outlook. Due to having to leave the trust...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.