The Linux Page

Help other users realize that everything is possible, especially avoiding Windows for their own personal use.

Welcome to The Linux Page


Fox Trot by Bill Amend. Click to enlarge.
Click to enlarge

This site is a collection of my own work with Linux. Certain things are easy, others take time to decipher and if I ever need to repeat the work (which usually happens!), then I need to remember everything by memory or... have a site with all the steps taken and to take again.

The following are my most recent posts:

Whenever you open a dialog in MS-Access, you may need/want to get a result.

The MsgBox function is often enough and it can be used as a function. Unfortunately, when it isn't enough and you want to create your own modal dialog, you cannot call a function. The call is DoCmd.OpenForm and that's a sub-routine. No choice.

The idea is simple, we need to open the dialog, let the user interact in some ways, then return the value the user just entered and move on.

Simple Sum

When you create a form in MS-Access and include a sub-form with a table in it, you may want to compute the sum of a field. This is done simply by creating a TextBox and writing the following in that box content:

=Sum([Column-name])

Where "Column-name" is (obviously) the name of the column you want to sum up.

This is neat, but it breaks if the specified column has an unsupported type. Very strange, but for me it breaks with a currency column! That feels a bit weak to say the least. According to my testing and what I have found on the net, it should work with any ...

In VB and MS-Access, whenever a variable referencing an object is set to Nothing, you cannot access any field since the variable does not actually point to a physical object.

This, code like this breaks:

	Dim r Is Object 
	r = Nothing 
	...
	r.Field = 5  ' Breaks if r is still Nothing

Thus, you need to test whether the variable r is defined.

My compamy creates many software and some are translated. Up to here, nothing serious.

Now compiling can be a problem as older versions of msgfmt do not like the BOF character at the start of text files. It has to be clean UTF-8, but no BOF.

Anyway... Now I compiled and I need to test the results. So I need to run in French, Spanish, etc.

The normal way under Unix is to do this:

   LANG=es program-name options

Although the name of the language can be a bit more complicated such as es_ES.ISO-8859-1.

To define a constant in MS-Access, use the Const keyword as in:

Private Const varname = "Some value"

The value can be a string, integer, floating point. The variable can be made public in which case it is global among all modules and forms.

The value after the equal sign must be constant at time of compilation which is why it is limited to strings, integers and floating point values.

The MS-Access system has a limited way to lock records...

This is done within what is called the Recordset object. That object has a field called LockType.

Available lock types are Optimistic, Pessimistic, Table. The last one prevents all access from anyone else (read/write lock). Pessimistic locks let other users read the locked data, but not write (write-only lock). Optimistic locks do nothing (in other words, no locking.)

The following is a synopsis for this locking feature:

This page is an extension to the InsertNode module available on Drupal.

I include here a set of files that one may be interested in to enhance the experience with that module.

If you have another file, let me know, and I might very well include it here (After reviewing the code!)

Thank you.


fckeditor-6.x-2.x-plugin.tar.gz

This file adds two prompts to help enter your [node: ... ] tag. This is based on Zewa's work.


fckeditor-6.x-1.x-plugin.zip

Today, I found out that the current row in a MS-Access form is not so current.

Somehow, it can extract the data from the current row, but trying to change some parameters on the current box actually affects the entire column. This is because a ContinuousForm includes only one box per column and that box is repeated for each row.

Radio Button in MS-Access

In MS-Access, it is possible to make use of Radio Buttons. They work just like in any other system. The last selected radio button represents the result of the selection. The problem is: how do you make multiple radio buttons work in concert?

Your first reaction is to simply add some radio buttons on your form. That looks fine. Seems to work actually. Somehow they are shown in a "3rd state". That state actually shows you that the radio buttons are not initialized. So it is not helpful in any way.

So... Now we have a radio button and... you try to ...

When I looked around for samples on how to query a MS-Access database using an SQL statement, it was telling me to declare a record set variable of type Recordset.

Thank you for visiting my website.