Access SQL Editor Documentation
Recent Posts
- Is There a Trick to Remove 3D Printing Supports?
- PETG “Blobbing”: What is it, and how do I prevent it from happening?
- 3D Printing: A Beginner’s Guide
- C#: Quickly Propagating Properties of an Object to the Parent Class
- Fix for applications that do not support high DPI
Electronics Projects
-
Virtual Keyboard/Mouse System – an open source hardware project to hook your laptop up to a second computer for use as a keyboard/mouse.
-
Generating a Color NTSC video signal with an FPGA – General information on the NTSC signal, and how I generated one.
-
FT232RL Breakout – Home etchable breakout board for FT232RL.
-
A USB-On-The-Go Fileserver – An idea to create a file server that uses USB On The Go.
Recent tech articles/notes
-
Development Technologies
-
DB2 Hints and Tips – DB2 hints and tips
-
Examples of HTML::TreeParser – examples of HTML::TreeParser for Perl. Use this to parse HTML in Perl.
-
Android/Linux
-
Electronics/Embedded
- Linux on ARM / BeagleBoard support
- Yocto Project – System to build custom Linux distributions for embedded systems
- Writing an MLO (first stage bootloader) for BeagleBoard
-
Misc Technology
- Why OpenVPN is so slow (and how to fix it)
-
MS-Access
Helpful links
-
Jesus
- AngularJS
-
Virtual Machines
-
How to Mount a VirtualBox VDI Image
- The basic process:
- Install qemu-kvm
-
Use qemu-nbd -c /dev/nbdX <image file>
- qemu-nbd recognizes many different image formats
- The basic process:
-
-
Code injection – Code injection is interesting, and has some legitimate uses. For example, I have some automated jobs running in a service. Many of these jobs are accessing resources from shared drive letters, rather than UNC paths (as Microsoft recommends), and changing this is beyond my control. So, following EasyHook’s tutorial, I was able to hook into CreateFile, and translate the paths at runtime.
-
EasyHook– C# library for hooking into unmanaged libraries.
-
-
C#
- Exporting Unmanaged (C-type) Functions From .NET DLLs (Nuget here)
- Converting Java jar files into .NET assemblies via ikvm
- RCW Internal Reference Count – details about the reference count of a COM Runtime Callable Wrapper in .NET
-
Using Unregistered COM Objects in PowerShell – I don’t use PowerShell, but has some good info on SxS assemblies.
-
The Arbitrary Geek: COM Interop Series – Very helpful series on the internals of COM Interop, writing your own RCWs, marshaling, and the internals of COM.
-
(Linq) How to Group Results by Contiguous Keys – Great way to split up large Linq queries into subtasks. Used this to read a large text file with contiguous keys & split up results into smaller Linq queries.
-
Linq To Text: CodeProject, MSDN
-
Dapper Dot Net – map SQL queries to dynamic objects in C#
-
Regex Grouping Constructs – Positive/neg lookahead, named groups, etc.
-
How to register a .NET CCW with regasm from a Visual Studio 2008 Setup project – same as below without manual call to regasm.
-
Interop UserControl in MSAccess – resizing problem when using an Interop UserControl (AKA ActiveX control) in an MS-Access form.
-
Key to fixing this was the following. Add a panel in the usercontrol that contains everything. Set panel’s anchors to top, left, right, and bottom (instead of using Fill: Dock). Set the usercontrol’s AutoSize property to true, and the panel’s AutoSize property to false. Implement a resizing routine like the one in the linked page above, to allow the panel to be sized in twips instead of pixels. Then, put the ActiveX control on the Access form and make it much larger than the screen (for example 20 inches x 20 inches). Finally, call the resize function of your COM object that you created from the linked forum discussion.
-
-
Operating System Development
-
Database
-
H2 Database – High performance Java database
-
Prevalyer – High performance Java database
-
-
MS-Access
-
SVN
-
Active Directory Queries
-
ANTLR
-
Antlr v3 – ANother Tool for Language Recognition, is a language tool that provides a framework for constructing recognizers, compilers, and translators from grammatical descriptions containing actions in a variety of target languages.
-
-
Yeah, language=CSharp3. Also, “parse” doesn’t seem to show up as a method, unless it’s preceded by “public” in the .g file, like “startProg” is, here
-
-
Miscellaneous
-
Getting a List of Installed OLE DB Providers in .NET
-
PowerShell 2-liner:
[System.Data.OleDb.OleDbEnumerator]$oledb = new-object ‘System.Data.OleDb.OleDbEnumerator’ $oledb.GetElements() | select sources_name, sources_description
-
-
Debian debootstrap – details on what to set up after a debootstrap
-
Fix for problem with mouse being jailed in Ubuntu with randr For 1280×750 resolution on a 1024×600 monitor:
-
How to use compat-wireless to build wired/wireless net drivers in Debian/Ubuntu
-
ALX (Atheros) driver is in a patch for compat-wireless; make sure to download the proper file
-
RTL8188ce intermittent connection fix – Question asked about Lenovo, but works in Toshiba L855 also. Basically compile rtlwifi from compat-wireless.
- Scaling desktop display on Linux
xrandr --newmode "1280x750" 78.32 1280 1344 1480 1680 750 751 754 777 -HSync +Vsync xrandr --addmode VGA1 1280x750 xrandr --output VGA1 --mode 1280x750 --output LVDS1 --fb 1280x750 --scale 1.25x1.25
- Compiling Squid with SSL on Debian
-
-
BusyCal – BusyCal can sync with both iCloud and Google Calendar simultaneously.
Please remember: anything you try based on the advice at this web site is AT YOUR OWN RISK and WITHOUT WARRANTY OF ANY KIND. I assume absolutely no liability for any damages caused by any content on this site, or on any other web site.
Questions? E-mail me at
1 Praise the Lord. Blessed is the man who fears the Lord, who finds great delight in his commands. Psalm 112:1, NLT
16 "For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life.17 For God did not send his Son into the world to condemn the world, but to save the world through him.18 Whoever believes in him is not condemned, but whoever does not believe stands condemned already because he has not believed in the name of God's one and only Son.19 This is the verdict: Light has come into the world, but men loved darkness instead of light because their deeds were evil.20 Everyone who does evil hates the light, and will not come into the light for fear that his deeds will be exposed. 21 But whoever lives by the truth comes into the light, so that it may be seen plainly that what he has done has been done through God." John 3:16-21
17 You may say to yourself, "My power and the strength of my hands have produced this wealth for me." 18 But remember the Lord your God, for it is he who gives you the ability to produce wealth, and so confirms his covenant, which he swore to your forefathers, as it is today. 19 If you ever forget the Lord your God and follow other gods and worship and bow down to them, I testify against you today that you will surely be destroyed. Deut. 8:17-19