|HCS Consulting Group.|
|We make Complex Systems simple|
Software Design and Consulting Group.
Need help for MultiValued Database systems?
Pick (d3), Ultimate, jBase, Advanced Revelation, UniVerse
Migrating to or from a Multi-Valued
system? Migrate to sql server?
Office, Word, VB, SQL-server, FoxPro, Access. SharePoint ->we can help.
Migrate MS Access applications to SQL server
Migrate MS Access applications to web based applications
Send invoices from Access to your Accounting system?
We build interfaces from Access to QuickBooks, or SAGE50 (Simply accounting)
Contact me: Albert D. Kallal - email@example.com
About me: click here
Skiing at Marmot Basin - Jasper National Park, Alberta, Canada
I took this picture at the top of the Eagle Express Chair
(all pictures on this site were taken by me)
Rides reservations systems.
For information on Rides click here
Everyone says they make software easy to
so why does our HCS group do a better job? click here for more.... .
My Articles and Comments:
Merge PDF's in Access - x32 and x64 bit version
October 12, 2021
With the rise of office x64 bits, then some of our old and long time merge PDF's don't work
I share a working solution. It does not require any client side install, but does require a simple copy of two .dll's (included)
Access PDF Merge
Simple rounding errors can bite you in Access!
February 6, 2014
Simple tips to avoid math rounding errors in your applications.
Access is a great business tool and while we don't as a rule have to worry or think about rounding errors, there ARE some simple tips to keep one out of trouble.
Simple rounding in Access
Become friends with the nav pane in Access 2007 and beyond.
Auguest 14, 2012
Tips to be even more productive with the navigation pane.
Nav Pane Tips
Access Web Development - free Web broadcast - April 30th - 7 pm to 8 pm
I share my experiences and give tips on what it takes to do web development with Access.
Web Broadcast - The road to the web, with access!
January 9, 2012
Tips to be even more productive with the navigation pane in 2010.
When faced with this new navigation pane system, I had to either figure out a new way to work or I was going to suffer. I share some tips that not only allowed me remain productive, but take an real liking to the new navigation pane in Access.
Building a Soundex search in Access Web Services
September 13, 2010
Searching for names in Access based on sound, not spelling.
While we not going to build the next great search engine in Access, you can easily create a search form in Access that allows you search for names that sound the same. The end result is a search form that behaves much like using any modern search engine on the web.
The long Access road to the WEB.
Converting applications to the web PART 1
19 Jul 2010
You built a great application in Access. Now your company wants this to become web based.
I outline the issues and considerations.
Tame the Access ribbon with my ribbon class object.
24 Apr 2009
The access 2007 office ribbon is a real handful to program in code.
With this class object I show you how enabling/disabling buttons on the ribbon is easy as pie.
Deploying updates to access runtimes.
26 Dec 2008
The access 2007 runtime system is now free. Find out how you can
update applications deployed this way.
Data processing in ms-access
25 May 2007
Data processing with ms-access! Did you know that punched card data processing was often
MUCH more productive then ms-access. This article explains why, and how you can also
achieve large increase in data entry productivity, or simply reduce your staff needs for data entry work.
Batch processing in ms-access
(how to run ms-access as a batch job)
27 April 2007
Data processing with ms-access! What ever happed the to nightly batch process? Don't dismay,
if you long for the good old days of command prompts, punched cards, and batch jobs, there
is some hope!
While I can't deliver on the punched card part, you certainly can run a ms-access program as a
nightly batch job.
Splitting a access
database, or how to run ms-access in a multi-user mode.
19 Aug 2005
One of the neat things about ms-access is that you can take a application you written, and turn it into a multi-user application without having to change code.
Dialog and prompt forms in
04 Jun,, 2004
This prompt form information is likely one of the BEST things you can learn to improve your
UI in ms-access. I also clarify the COMMON confusion between dialog forms, and model forms
Using Objects in Ms-Access
16 Sep, 2003
You can create class objects in ms-access. Why would you want to?
I give some ideas as to when, and why you would create objects in ms-access.
Ms-access and WANS?
09 Aug, 2003
Can you use ms-access on a WAN?
I attempt to provide some sane and simple advice.
Why bother with .net when you have Thin Client?
02 Sep, 2002
Why bother with .net when you have thin client technologies that can web enable any windows application with the click of a button? Did you know that you can web enable any old VB or windows program that you have with out re-writing ONE line of code?
I attempt to answer why thin client is not the answer to creating web based applications.
Working slower can = More work
08 Jan, 2002
Ever wonder how to increase the speed of your developers? Read this and find out why working slower can actually result in more work!
Sub forms in Ms-Access
03 Jan, 2002
Every software vendor seems to claim that they have the best RAD tool around. One main feature of Ms-Access is the idea of sub-forms. Read here as to why subs forms are one key feature to productivity in Access.
Why are Multi Valued databases so good?
10 Dec, 2001
Read why the Pick (multi-valued) system is still the best kept secret in the IT industry.
Conversion of a MVApplication to Ms-access
06 Apr, 2001
My notes on converting some software from a MV system to Ms Access. Multi Valued systems are still the best kept secret in the IT industry. If you attempt to convert one of these systems, you better read this!
Jobs in the It Market. Why it is so bad?
06 Jul, 2001
I was asked a question about jobs, and is the Access programming / consulting market dead? This question was asked to me in the comp.databases.ms-access newsgroup. My response explains why, and how jobs in the IT market work.
For some of my ms-access files you can click here: My Temp ms-access page