Author: TheSmileyCoder

Access Email with Hyperlink to record

A couple of days ago I posted about ways to get an email hyperlink to activate your access database and navigate to a specific record. It was a bit cumbersome because it had to use both batch files and vbs

Posted in Misc., Random Tidbits

Deep Linking or Hyperlinking in Microsoft Access

Email hyperlink/Deep Link to Access record Literally for ages, I’ve wanted to ability to email a link to users, that would take them to a specific record within my access application. For quite a while I’ve been sending out Monday

Posted in Misc., Random Tidbits Tagged with: , , , ,

Playing with Report View as a subform

I’ve been playing with adding a report as a subform. As far as I know, that means the report is displayed in report view. That means no format event, and there are several other events that don’t fire either. The

Posted in Misc., Random Tidbits, Tip Of The Week Tagged with: ,

Office automation: Outlook 2010 randomly renames file attachments

Alternative Title: Guess what I wasted the past 2 days on? We recently got a bug report from one of our contractors. They told us that the attached files they had received via outlook was not named correctly. In fact,

Posted in Misc.

Whats new in Access 2016

Jeff Conrad from the Access Team recently released this list of new features for Access 2016. Personally I am still on 2010, but it does look like some of the features are features the Access community has been requested for

Posted in Misc., Random Tidbits, Tip Of The Week

Stop or Check multiple instances of Access on startup

Prevent users from opening multiple instances of access Quite often we want to only allow the user to open the frontend file one and ONLY one time. It could be that some functionality simple doesn’t work if the frontend is

Posted in Misc., Random Tidbits

Access Europe August 5th: Automate Client Distribution

Access Europe has a special session lined up for you this time. On August 5th we will demonstrate how to automate pushing updates out to your users. Now if you’r an access developer with multiple users, you are probably aware

Posted in Access Europe, Misc., Random Tidbits Tagged with: , , , , ,

Access Europe Virtual Group June 3rd 21:00 CEST – Open Q&A

Tomorrow evening Access Europe is once again opening the virtual meeting for free Questions. Come and ask question you want (preferably access related) and I will try my best to answer, and I might even have some sample code I

Posted in Access Europe

Live vs Test? How do you tell?

During my day, I will often switch between development, test, data admin duties, running custom reports and more. This also means I often switch between a backend with test data and a live backend. Now since the test data is a copy of the live

Posted in Misc., Random Tidbits

Exporting Rich Text To Excel

The Problem Every once in a while I will come across a user who wants to export rich text (Feature added in 2007) to excel. If you have ever tried automating Excel from Access you will know how great the interaction

Posted in Misc., Tip Of The Week