CBlog(handziuk)

Bradley Handziuk's blog

What is Shell.Application.Namespace input parameter thinking?

I'm trying to work with the `shell.application` object to unzip some files but am having trouble pas [More]

Stop publishing Access to Sharepoint

Can figure out how to make your Access DB stop trying to publish to Sharepoint? Did you publish to S [More]

How to have multiple instances of the same form open at once in Access

(I'm pretty sure I didn't come up with this but it's been in some of my stuff for a few years now. I [More]

Calling out invalid data

Validating data before it get submitted on a bound form is easy enough. Each control should have its [More]

How effectively pass multiple values in an OpenArgs parameter

I always need to write up a little procedure to handle passing in values in the OpenArgs paramater o [More]

Always use Option Explicit

When writing any VBA for Excel, Access or Word or whatever you automate you have the option to use t [More]

Finding a Access backend data file

Because you should be splitting your Access database before you give it
to a customer to use you ca [More]

How to reuse VBA function in all your Excel files

Excel allows you to create .xlsm files (macro enabled spreadsheets) but these are a bit of a hassle [More]