|
||||||
Access MVP (2010-2015) |
When tabbing between Controls on Forms and they contain text all the data within the Control is selected. This can be problematic as Users may inadvertently overwrite what is already there and not even realize it as they begin typing. To avoid that you can force the Cursor to land at the beginning or the […] 732 total views Last year when I was really starting to jump into exporting data to Excel I ran into an issue. I wanted the rows with duplicated data to only show the first row and hide the following rows… Conditional Formatting, right? So, why couldn’t I get what I wanted. When all else fails *Google* it! Which […] 996 total views, 1 views today 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 […] 725 total views 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 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 […] 884 total views |
 |
||||
|
Copyright © 2024 Gina's Coffee Shop - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
