Category: Tip Of The Week

One of the perhaps lesser known properties of the access form is the navigation caption. This property controls what you see in the bottom left corner of your form (Provided you have not turned off navigation buttons). If you leave …

Navigation Caption Read More »

If you have used VBA for more than just recording Macros in Excel, you probably know about Debug.Print, so I won’t go into the usual stuff, but rather tell you about some of the lesser known features of Debug.Print. A) …

Debug.Print “The Fine Print” Read More »

Tagged with: , ,

I had an issue today where I kept getting error reports from a user. The procedure in question exports a file, and the error report kept saying the file was busy. I told him he couldn’t do a “fresh” export …

Prevent click event from firing twice on doubleclick Read More »

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 …

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

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

Access Developers Conference in Vienna Read More »

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

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 »

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 »

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

Tip of the Week #4 Treeview To Excel Read More »

Tagged with: , , , , , ,

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 …

Tip of the Week #3: PathCompact Read More »