Category: Misc.

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 …

Access Email with Hyperlink to record Read More »

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 …

Deep Linking or Hyperlinking in Microsoft Access Read More »

Tagged with: , , , ,

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 …

Playing with Report View as a subform Read More »

Tagged with: ,

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, …

Office automation: Outlook 2010 randomly renames file attachments Read More »

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 …

Whats new in Access 2016 Read More »

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 …

Stop or Check multiple instances of Access on startup Read More »

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 …

Access Europe August 5th: Automate Client Distribution Read More »

Tagged with: , , , , ,

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 …

Live vs Test? How do you tell? Read More »

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 …

Exporting Rich Text To Excel Read More »

I have some great news to share with you today. On June 2nd, Access Europe will host a one-day seminar in Denmark, and I have some fantastic presenters and presentations lined up for you! I have gathered no less than four Microsoft …

Access Europe Seminar – June 2nd in Denmark Read More »