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…
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…
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: Report View;Playing:GUI:Interface, TheSmileyCoder
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…
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, Access Europe, Client, Frontent, TheSmileyCoder, VBA
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
Recent Comments