|
||||||
Access MVP (2010-2015) |
Function fncOpenSpecificWorksheet(strSheetName As String) ‘http://www.access-diva.com/tips.html ‘Open Excel to the specified Worksheet Dim xlApp As Object Dim xlWBk As Object Dim xlWSh As Object On Error GoTo Err_Handler Set xlApp = CreateObject("Excel.Application") Set xlWBk = xlApp.Workbooks.Open("C:\… ENTER YOUR PATH HERE") xlApp.Sheets(strSheetName).Select xlApp.Visible = True Set xlApp = Nothing Set xlWBk = Nothing Set xlWSh = Nothing […] 726 total views, 1 views today Question: How do I send eMail and include my Outlook signature? Answer: Create a Module, name it anything you like except the name of the Function. At the top of your Module under… Option Compare Database Option Explicit …place Function streMailWithOutlookSignature() ‘Works in Office 2000-2016 Dim OutApp As Object Dim OutMail As Object Dim strbody […] 785 total views Since Microsoft Access 2007 getting a different Image to show up for each record is pretty easy, you just need to bind the Image Control to the field that holds the path to the image and you are done. However, I wanted a conditional image on my Continuous Form based on whether there was a […] 2,102 total views, 1 views today Recently, I watched Free Tools for Microsoft Access recorded by Crystal Long and Adrian Bell (Microsoft Access MVP’s) on Channel 9. Upon looking at comments below it dawned on me there is no central location for all those great free tools! How is anyone to find them? After all, you may not know they […] 673 total views Question: Can anyone tell me how to eMail a report with content based data based on the individual? Answer: Create a Module, name it anything you like except the name of the Function. At the top of your Module under… Option Compare Database Option Explicit …place Public olApp As Object Public olNameSpace As Object Public […] 885 total views, 1 views today |
 |
||||
|
Copyright © 2024 Gina's Coffee Shop - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
