Recent content by SSAMarvel

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...