MS Access and VB Programming
|
Dev Ashish's Access Web Page
|
Probably the best Access resource around. FAQs, code, utilities, add-ins and lots of tips,
plus a comprehensive set of links to other resources on Access.
|
|
VBnet Visual Basic Developers Resource Centre
|
Enhanced functionality using the win32 api for
intermediate and advanced visual basic developers using 'VBClassic'
(not VB.NET). If you need to call something using the win32 API, it's probably here.
|
|
Karl E. Peterson's Classic VB Code
|
Maybe Classic VB wasn't so bad after all...
Especially Karl's list
about how VFred (aka VB.NET) totally breaks most existing VB code.
|
|
Allen Browne's tips for Access users
|
A great set of tips for Access users, especially the
Tips for Serious Users and the
Pop-up Calendar.
We are especially grateful to Allen
for his assistance in helping us upgrade from Access 97 to 2003.
|
|
Tips from the FMS Team
|
A mixture of Access, VB, and other tricks and tips.
Includes what to do with the
Error 49 Bad DLL calling convention
error in your Access 2003 database.
|
|
ADO Connections
|
Carl Prothman's collection of ADO and ADO.NET connection strings.
Samples for OLE DB Providers, .NET Data Providers,
and ODBC Drivers, both DSN and DSN-Less.
|
|
Trigeminal Software
|
Michael Kaplan's site with utilities, components and tools. A bit dated now but
includes free code to recover the database password from any Jet 3.x/3.5x database.
|
|
Visual Basic Tutorial
|
Online Visual Basic (VB6) tutorials intended for programmers of all levels.
|
|
Jenda Krynicky's Regex Control
|
If you want to use Regular expressions (Regex) in your VBA code or use a
better interface than the messy Microsoft VBScript Regular Expressions object,
try using Jenda Krynicky's Jenda.Rex
Active-X DLL.
We have used this in Access projects to do some really hairy stuff
with large input data and frightful expressions. We love it.
|
|
FreeWheel mouse wheel support
|
Does your wheel mouse not work in VB6 or VBA? You've tried downloading the latest
Intellipoint software and it still doesn't work?
Try installing Jim Barry's FreeWheel software.
Works on both Windows 9X and NT+. We use it on 64-bit Windows 7.
|
|
Microsoft Naming Conventions
|
A concise guide to naming conventions plus tips on formatting and commenting your code.
Uses our preferred shorter naming convention for variable names: sName instead of strName.
|
|
Computer Programming Training Tutorial
|
A good collection of links to articles and tutorials on a selection of computer programming languages.
Includes links (eventually) to our friend Simon Thompson's books on
Erlang and Haskell.
|
Perl and Web Programming
Web Site Construction
Useful Utilities
|
ERUNT - Emergency Recovery Utility NT
|
Registry Backup and Restore for Windows NT/2000/2003/XP/Vista/W7. We now run this every night after we had an unfortunate
programming accident that deleted our entire registry.
|
|
Nullsoft Scriptable Install System
|
We now use the Nullsoft Scriptable Install System (NSIS) to package and distribute all updates to our clients.
Reckon on taking three or four hours to figure out how to use it. (Hint: work through the examples they provide, starting
with the simplest.) Then it's just a dream to use.
NSIS is a tool that allows programmers to create installers for all variants of Windows.
It is released under an open source license and is completely free for any use. Highly recommended.
|
|
Dimension 4 time synchronisation utility
|
Fed up with your computer's clock always being wrong?
Want it to be synchronised with the US Navy's atomic clock?
Install Rob Chambers'
Dimension 4 time synchronisation software onto your Windows 95/98/NT/2K/XP computer.
Inobtrusive, accurate and free to non-commercial users.
|
|
FRHED free hex editor
|
If you do any work with binary files you need a good hex editor.
Raihan Kibria's FRHED free hex editor is brilliant.
Very well constructed with options to work in hexadecimal, text or binary mode.
An excellent piece of freeware.
|
|
Highlight
|
Converts source code to formatted text with syntax highlighting.
Coloured output in HTML, XHTML, RTF, TeX, LaTeX, SVG, BBCode and XML format.
Supports 160 programming languages.
Includes 80 colour themes.
|
Computer Security
|
AVG Anti-Virus system by Grisoft
|
Grisoft offer a free version of their excellent AVG anti-virus software
(just keep following the links for "Free Basic Protection" and avoid options to "Update").
They put out frequent updates. We have installed this on a variety of Windows operating
systems without any problems (which is more than we can say for McAfee or Norton).
|
|
Zone Alarm free personal firewall
|
ZoneAlarm is probably the best software firewall available. The
"no-frills" version is free.
ZoneAlarm monitors any unauthorised outgoing connections from trojans
and spyware inside your computer.
(It also prevents Microsoft utilities "phoning home", which MS's firewall probably still forgets to tell you about)
We once paid for the "Pro" version and upgrades which we were happy with until we required support, which is pathetic.
When downloading, follow the links for the "Basic Firewall" carefully and avoid any options to "Upgrade".
|
|
Firefox browser
|
We recommend installing the Firefox browser to eliminate all the security hassles of Internet Explorer.
Just install (it's free) and then delete all the obvious links to MSIE on your desktop.
We especially like the
NoScript and
FlashBlock add-ons.
Status update: We are no longer going out with Firefox. We've dumped her for the faster
Pale Moon custom-built and optimized Firefox browser for Windows.
We use the Pale Moon x64 version and it works a treat - so far all our add-ons work fine.
|
|
Magic Mail Monitor
|
Magic Mail Monitor is a free utility that sits silently in your system tray and notifies you about new messages in one of your mailboxes.
You can preview messages and delete unwanted emails before they get onto your system.
Set your email client options NOT to download messages unless you
click on the Send/Receive/Get Mail button.
(In Outlook Express, uncheck "Send & receive messages at startup" and "Check for new messages every...";
in Thunderbird: Tools > Account Settings > Server Settings and uncheck "Check for new messages at startup"
and "Check for new messages every ...")
|
|
Shields UP!
|
Follow the
Shields UP! link to have Steve Gibson's excellent site check the security of
your computer's connection to the Internet. You'll get very paranoid and with good reason, too.
Lots of other good information on security and network issues.
|
|
Startup Monitor
|
Startup Monitor is a small, free utility that runs transparently
(it doesn't even use a tray icon) and notifies you when any program registers itself to run at system startup.
It prevents annoying programs from registering themselves behind your back.
Teach your kids not to click on OK when they are surfing the web.
|
|
SnoopFree Privacy Shield
|
Prevents keyboard loggers and other spyware from monitoring your system.
Free and low impact, but annoying icon in the tray.
|
|
HijackThis
|
A free utility which quickly scans your Windows computer to find settings that may have been changed by spyware, malware or other unwanted programs.
For expert users only.
|
|
CCleaner
|
CCleaner is a freeware PC optimization tool.
It combines a system cleaner that removes unused and temporary files from your system and also a fully featured registry cleaner.
The underlying software appears reliable but be careful following links on their site that suggest you "may need a tune up".
|
|
Ad-Aware by Lavasoft
|
Ad-aware is a free multi spyware removal utility designed for all
Windows platforms.
It scans your system for components of known spyware parasites and lets you remove them safely.
If you are plagued with pop-ups, use this or Spybot Search & Destroy.
|
|
SMTP2Go
|
Are you trying unsuccessfully to send emails from your laptop, desktop computer, iPhone or PDA?
Simply use smtp2go.com as your outgoing mail server.
In our opinion, this service is worth every cent of its very reasonable annual fee.
We travel a lot and find smtp2go.com works every time. Their customer service is top rate. Highly recommended.
|
|
Witopia VPN
|
Reasonably priced personal VPN service. Useful to bypass internet filters installed by
primitive third-world authoritarian governments, like Australia.
Be careful using with Windows 7. You need to Run As Administrator every time.
Microsoft's "improvements" to the UAC in W7 seem to have made things worse!
|
Windows
|
Agent Ransack
|
The free Agent Ransack tool helps you find files and information on your hard drive quickly and efficiently.
Much better than the Microsoft search tool. The latest version will work on 64-bit machines.
We love this tool.
|
|
Xplorer2
|
Fed up with Windows Explorer?
Zabkat's xplorer˛ is a desktop file manager combining the simplicity of windows explorer with the speed and efficiency of traditional dual pane orthodox file managers.
|
|
Safarp
|
Finding the Windows "Add or Remove Programs" applet is taking forever to load?
All the fancy (and useless) extra information it gives just takes too long to find.
Use the open source and free Safarp
(Small And Fast Add/Remove Programs) program instead.
It loads up almost instantaneously.
|
|
Image Resizer Powertoy Clone for Windows
|
In Microsoft XP PowerToys there was a really useful utility that re-sized your photo files and could be used with the context menu.
Simple, eh?
In Vista and Windows 7, you can't get this. So, despite all the bloatware and the so-called media-friendly approach,
you need a third-party utility to do something as simple as re-sizing your photos.
Image Resizer Powertoy Clone for Windows allows you to right-click on one or more image files in Windows Explorer to resize them.
|
|
IrfanView
|
Irfan Skiljan's wonderful freeware viewer for just about any sort of graphic or media file.
|
|
VLC Media Player
|
Do you hate Windows Media Player and all its unwanted "protection" and its rights to destroy your computer if it does not agree with what
you are doing? (If you didn't realise this, read the license conditions.)
As an alternative, use the VLC media player - a highly portable multimedia player for various audio and video formats as well as DVDs, VCDs,
and various streaming protocols.
|
|
WinDirStat
|
WinDirStat is a disk usage statistics viewer and cleanup tool for Microsoft Windows. Find out which files and directories
are taking up the most space on your hard drive. Has a brilliant visual display.
|
|
Process Explorer
|
Mark Russinovich's Process Explorer shows you information about which handles and DLLs processes have opened or loaded.
Shows much more than the standard Windows Task Manager, including services that may have been added by a virus
|
|
Speccy
|
Priform's free Speccy is an advanced System Information tool for your PC. Use it to find out what's inside your computer.
|
|
FileMenu Tools
|
FileMenu Tools by LopeSoft allows you to customise the context menu of Windows Explorer.
Get rid of all those annoying options when you right-click on a file.
Plus lots of handy utilities.
|
Networking
|
OzCableGuy
|
If you have a problem with your broadband ADSL or Cable internet connection, or need
to configure your network to work with it,
Darren Stribning's excellent site will have the answer. Well laid-out
with FAQs and complete 'how to' guides to set up your network and troubleshoot.
It includes how to cope with the Telstra Cable
'heartbeat' and how to set up a LinkSys router to work with it.
|
The worst hotel in the world
|
Worst hotel in the world
|
We finally found the worst hotel in the world in, of all places, Accrington, England.
The Norwood Hotel in Accrington is owned and managed by one Stuart McGlynn, someone who makes Basil Fawlty look like the most jovial mine host.
Read about our experience and what other guests had to say on
TripAdvisor.com
about how terrible it is.
|
|
Links to useful sites
