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

2d
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
Dec
11
comment MS access compact via sql
@krishKM not true if you are accessing mdb files since Windows has had the necessary drivers for them wince Win95. The ACE drivers (or a full/runtime installation of Access) are only necessary if you are using the accdb format introduced from Access 2007).
Dec
11
answered Dynamically Update Office References in VBA
Dec
11
comment Is there a way in MS Access to convert a text box into a radial button?
We'll need more information here, do you have any screenshot of what it currently looks like and what you want it to look like? What have you tried so far?
Dec
11
answered Set different font sizes for different lines in a text box
Dec
10
awarded Supporter
Dec
10
awarded Autobiographer
Dec
10
revised SQL ORDER BY behaving strangely in MS Access 2010 report
Added instructions to access the grouping and sorting panel
Dec
9
answered SQL ORDER BY behaving strangely in MS Access 2010 report
Dec
9
answered how can i write a function to strip numbers from a text field in msaccess97
Dec
9
answered access, OpenDatabase() relative path
Dec
9
answered Specify Date/Time Field Format through SQL in MS Access
Dec
1
answered Importing CSV file into MS Access 2010 Tables
Nov
30
answered Microsoft Access 2010 filtering data based on tempvar
1 2 3 4 5