A foreigner living in a foreign land.

I have a love/hate relationship with VBA.
I loathe it as much as I am strangely drawn to it.
It is old but it will not die, it is ugly but equally fascinating.
When I code in VBA, I feel like I discovered an old secret that begs to be understood.
I imagine ways to hack it, to ply its ancient curses into modern idioms.
Then I fail.
Then I try again.

May the god of F# have mercy on my soul and liberate me from my sisyphean plight.

http://blog.nkadesign.com

Apr
5
answered My C#.net windows service is not executing its startup code
Mar
19
awarded Inquisitive
Mar
13
comment How to update front-end for MS Access 2007
@EricG I've been thinking about this but haven't found the time yet. Will probably do it when I can. It's not complicated, but it's not trivial either, especially if we want to make it generic enough that it can help a lot of people rather than target my narrower needs.
Mar
8
comment Win2008R2 Firewall will accept incoming connections from WAN but not from LAN
@Davidw The firewall logs show that the LAN packets are dropped, but there is no indication of which rule was triggered. Is there a way to actually debug the firewall in windows?
Mar
7
comment Win2008R2 Firewall will accept incoming connections from WAN but not from LAN
@Davidw it's what I am wondering. I can't see anything strange in the firewall configuration itself, and the rest of the server is working fine. When the firewall is Off, access to the server is working fine. When the firewall is on, access to the server doesn't work, even though the firewall rules allow this.
Mar
7
revised Win2008R2 Firewall will accept incoming connections from WAN but not from LAN
Added firewall properties screenshot
Mar
7
asked Win2008R2 Firewall will accept incoming connections from WAN but not from LAN
Feb
27
awarded Revival
Feb
16
awarded Famous Question
Feb
1
awarded Revival
Jan
27
awarded Notable Question
Jan
12
awarded Enlightened
Jan
12
awarded Nice Answer
Dec
19
comment Microsoft Access Linked Table - Can I use an .accdr file as a backend
@damon yes, an accde is just a database with its code precompiled and the source removed (although you can just rename a database and it will behave the same way, but the source code will not be removed of course).
Dec
18
revised Network file path not opening in VBA/MSAccess
Added alternative
Dec
18
answered Network file path not opening in VBA/MSAccess
Dec
18
answered What constitutes a design change in MS Access 2013?
Dec
14
answered Input mask in MS Access, uppercase and lowercase letters
Dec
11
answered How do I manage to hide my ID field in my form
Dec
11
answered MS access compact via sql
1 2 3 4 5