Syndicate content


Display a line number in a table (i.e. subform of records)

I was ask by a customer to add line numbers to each entry in a table shown in an invoice.

The concept is pretty simple, but really, how do you do that properly in MS-Access?

Microsoft actually has a solution (see link below) and it comes down to writing a function that counts the number of items from that item's current position to the beginning of the table (i.e. going backward). It works, it is just really bad if you have very large invoices since it will tend to slow down as you start getting many items.

There is the function, we can see the counting in the do until near the end ...

A C++ implementation of a UDP client/server

I have noticed that quite a few people were trying to create UDP communication and I thought that proposing my class could help them. This is very basic as it does not define anything such as the size of a packet or any protocol to ensure arrival of the packets. However, it can be useful if you want to send a signal from one process to another, which is exactly how I use this implementation.

This code is part of the Snap! C++ implementation. It can be found in the corresponding repository.

Header file:

// UDP Client Server -- send/receive UDP packets
// Copyright (C) 2013 ...

Multi-level lists in MS-Word... The new way!?

Okay, it has been a little while now, but each time I just have to search forever to find out how to create a multi-level numbering list.

By default, a list will appear as this:

1. Chapter

    1. Section

        1. Sub-Section

Which may work for you, but in many cases you want to have all the list numbers appearing in your section and sub-sections as in:

1. Chapter

    1.1 Section

        1.1.1 Sub-Section

Okay, so that in itself it actually very easy, but it used to be that you could ...

Compile Qt 4.7.x with Visual Studio 10 (VC++ 2010)

Try to recompile Qt with Pavel's instructrions...

I did not encounter much problems, although the examples failed. It looks like jom would be the problem as some people reported not having problems following the same steps, but using nmake instead of jom.

The instructions go like this: [Update: the links below all stopped working.]

  1. Visual C++ 2010 contains all necessary SDKs for Qt compilation. However if you plan to use Qt with Phonon you need to install additional software from Qt for Windows Requirements list.
  2. Download and extract Qt 4.7.4 Sources. (Or Qt ...

OpenSSL commands working with certificates

The following are some commands I use to read certificate and otherwise work with OpenSSL which I otherwise find somewhat difficult to use.

To read a certificate, you use the -text and -noout to get the result in stdout. Use the -in to specify the

openssl x509 -text -noout -in server.pem

The first parameter is the type of of key. I'm not sure where you should use what, but in general you can use x509 (csr file) and rsa (rsa files). I'm not too sure why they cannot just detect what's what...

Getting rid of the new Overlay Scrollbars (Invisible Scrollbar feature)

As I upgraded from Ubuntu 10.04 to 11.04, I got a bit of a surprise... many system windows started using a new type of scrollbar that is pretty much unusable (at least it slows down my production time on my desktop.)

Yes, these invisible scrollbars (which they call Overlay Scrollbar) are... invisible. Now you have to hover the mouse at the right place to get arrows that you can grab and move up and down. Oh! Did I say that you have to however in one place and these arrows, on purpose, appear AWAY from your mouse? This means you need to then move the mouse over those arrows before you can

C printf(3) for int, long and long long that works every time

Of Note: This only applies to C99, not C++.

I learned something quite interesting today and wanted to keep a note of it.

Whenever I use a printf() with a format such as %ld and try to compile my code on "many" different platforms, I often get warnings on another one.

The fact is that an int, a long, a long long, an int32_t, int64_t all use a different combination depending on your platform and whether you're running in 32 or 64 bit.

So, the answer to this problem are the #define found in the inttypes.h header file:


These entries are used after

The Expression On Load you entered as the event property setting produced the following error: User-defined type not defined


A few days ago, I made many updates in one of the MS-Access forms I'm working on.

Then, when I tried to open the form I'd get this error...

The Expression On Load you entered as the event property setting produced the following error: User-defined type not defined

This doesn't mean anything to me since I did not define any type... Removing the Form_Load function (commenting it out) made that very error go away, however, since that's the sub-form of another form, it still generates errors when the main form is trying to initialize the sub-form.

Note that it ...

Apache misconfiguration: AddType versus AddEncoding

I've been using Drupal for a while and only now started to notice a problem with the cache of JavaScript code. In general, I don't cache the JS since they are not dynamic files. But we do that with Snap!.

The Apache mime module offers two options: AddType and AddEncoding

Both options are used in a similar way meaning that both react on file extensions. When a match is found, the corresponding MIME type or content encoding is attached to the content being sent.

If you install the MIME module, it will attempt encode data properly for the most general case, but not all cases. That is, it does

AddThis is down, how to prevent the slow download of your pages?

Today AddThis is down, big time! For hours...

So to make my websites load faster (although I did not delete all the caches, which is a problem too?!) I removed the functionality. If you have Drupal, there is what I have done to leave the settings the same but still hide the AddThis button and thus get all the pages of all my websites to load fast.

First we remove the link by returning an empty array:

 * Implementation of hook_link(). 
function addthis_link($type, $node=NULL, $teaser = FALSE) {
return array(); // immediate return
  $links = array();

  if ($type ===  ...
Syndicate content Syndicate content


Terms of Site Index

Find the page/content you are looking for with our index.

  • column
  • Gibbon
  • IsNull

    The Visual Basic function to check whether a value is set to Null. The PHP equivalent is is_null().

  • sink
  • URL