Author: TheSmileyCoder

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 »

Looking forward to PAUG 2014. If you have never heard of it before, its a an all access conference in Portland, arranged by and attended by people who love Access. I went this year (2013) and had a great time …

Just signed up for PAUG 2014 conference Read More »

I while ago I made a post saying that I couldn’t get the treeview working in Access 2013. Mr Jan Karel Pieterse was kind enough to drop by and leave a remark saying that the treeview should work. So I decided …

Got treeview working in Access 2013 again! 🙂 Read More »

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

Tip of the Week #2: Enum Read More »

Tagged with: , , , , , , , ,

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 …

Tip of the week #1: Ctrl-Spacebar Read More »

Tagged with: , , , ,

EDIT: I managed to get the treeview fully operational again, so you can dis-regard this post. For the updated post, see: https://thesmileycoder.com/treeview-working-in-access2013/     I had heard rumours that the mscomctl treeview would not work in a Access 2013 database. …

Very limited treeview functionality in Access 2013 Read More »

Today I had a control that I wanted to place right at the center of my popup form. I could get it roughly right in design mode, but just not 100% there. Thankfully Access vba can be used to write …

Center Control on form in design view Read More »

Intro A great deal of my database works revolves around tracking text, whether it be requirement specifications, comments, test procedures or hazard logs the requirement is always there for being able to track changes. Who created the piece of text, …

Track Changes, Compare text and highlight difference, Text Diff Read More »

Sometimes as part of your application you need to copy a file. You can use the built it FileCopy for this purpose, but if you are moving large files, or are moving files over a slow connection it will of …

File Copy with Progress Meter Read More »