Category: Tip Of The Week

Saved by the backup – Do you have a backup plan in place?

As per usual, I was working in my database and had modified a form and module, as well as removed a module I no longer needed. I accidentally hid MZ tools “add Line numbers” function, which proceeded to add line

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

Access Developers Conference in Vienna

Karl Donaubauer, who has been an Access MVP for 19 consecutive years, and have organized dozens of german conferences in both Access and .Net have decided to try to gather momentum for an english speaking conference in Vienna this spring,

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

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

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

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

Tip of the Week #4 Treeview To Excel

Yesterday I was asked if I knew of a way to export a treeview to PDF or excel. I did not at the time, but I always welcome a challenge, as its a chance for me to learn something new,

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

Tip of the Week #3: PathCompact

Wow, December was a very busy month for me, so I never got around to posting more than 1 tip of the week in December, so seems I am a bit behind. Anyways the inspiration and code for this tip

Posted in Random Tidbits, Tip Of The Week

Tip of the Week #2: Enum

This tip of the week will be about Enums. Enum is short for enumeration, and while you might think you have never heard of or used a enum before, I can almost certainly promise you that it is not true.

Posted in Tip Of The Week Tagged with: , , , , , , , ,

Tip of the week #1: Ctrl-Spacebar

Intro to Tip of the week I will admit the blog has been a bit dead for a while. I have been busy with the code below, and its taking up alot of time:

so instead of trying to

Posted in Tip Of The Week Tagged with: , , , ,