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

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)

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

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

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,

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

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

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

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,

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

Top