Search results

I have a command button on an excel spreadsheet to open a word document with this code. Private Sub CommandButton1_Click() Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True objWord.Documents.Open "H:\Spreadsheets\400 Book\400...

In an on click Event to send emails from a form I have to following line of code as part of code that sends an email. .ReplyRecipients.Add "email@gmail.com"This is for the recipient to reply to a different email than the one it was sent from. This works great if sent to an email address. Does...

Have a form that is only for viewing records. When opened the first text box is selected and then very difficult to read. I could change the tab order, but I don't want any selected. Is there a way to do this?

I have a table with the following fields, ID (primaryKey) Date_Created Date_of_Event Time_of_Event Number_Staff_Needed Staff1 Staff2 Staff3 that keeps track of events that 1 to 3 staff may be involved in. My question is does this violate the 1st normal rule of no repeating groups. If it...

Now that my first question was answered I move on to the next. I have this code to send an email Private Sub Request_Click() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Dim strbody As String Set OutApp = CreateObject("Outlook.Application") Set OutMail =...

I have a form that sends emails with the On_Click Event of a command button using this code. Private Sub Confirm_Click() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Dim strbody As String Set OutApp = CreateObject("Outlook.Application") Set OutMail =...