Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

List Tables and Fields…

When I’m designing a database I usually start off with one of my Templates. But, as with any Template, the Tables therein do not always fit exactly with the Client’s needs. And, since I like to document changes I built this tool…

In a nutshell… After the Template database is created I import the […]

96 total views, no views today

Hide Duplicate Rows in Excel…

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 […]

47 total views, no views today

Open Excel to specific Worksheet…

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 […]

43 total views, no views today

Send eMail with Default (Outlook) Signature…

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 […]

75 total views, no views today

Conditional Image on a Continuous Form (Reminders)…

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 […]

182 total views, no views today