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:

Most of the database systems I've worked with do not support having column names with a space.

Oracle and PostgreSQL accept double quotes for that purpose (i.e. "First Name").

MS-Access and MySQL accept back quotes (i.e. `First Name`)

Visual Basic accepts square brackets (i.e. [First Name])

Obviously, this is just plain craziness! One should just never use spaces in such a place since it completely breaks the object oriented capabilities of pretty much any sensical language.

What a strange error!

You execute an SQL statement with the usual OpenRecordset() function in MS-Access. So as usual, you put one parameter to the function, the SQL order.

You have written 100 of those before and had no problems.

Today, the last one you wrote says:

Too few parameters. Expected 1.

You look at this latest statement and your older statements and you just plainly don't get it. There is one parameter, it is the SQL string and it looks just fine.

So? What's wrong?

Simple! The error actually means a field name in the SQL statement is wrong. Yeah! That's how you need

I created a form in MS-Access and noticed, after a little while, that a ComboBox would not render properly.

The problem is pretty simple, I marked the combo box as having a Normal Back Style. When I first open the window or when I click in that ComboBox, it works and renders the specified Back Color. That's great, but that's not exactly the solution, is it?

The box has a Fore Color of Black (that's the color of the text). That Fore Color is used because the background is expected to be either gray or green. Either way, black shows pretty well.

I started using MS-Access not too long ago, but this one is really getting me each time.

Once in a while I get this error telling me that the Form is messed up, that a field or a macro just do not match. That macros are missing even though I ask the Form to call the corresponding functions. And some other strangeness like those.

Today I bumped in another problem: I want to show my user a message saying that I'm terribly busy looking for data in the database. Because I use ODBC with QuickBooks (QODBC to be precise), the system is somewhat slow. Therefore, it can take a little while and people just can't wait and they start clicking everywhere like crazy. That's a big problem...

Problem

I had a problem with my CuteMenu1 module and tried many times to fix it but just could not find the problem with Internet Explorer.

The fact is that I created dropdowns that are supposed to be full width, but that did not work, somehow.

I wanted each item to have a pre-defined height. So in the style for my DIV I wrote this:

[toc hidden:1]
  • 1. This is a Drupal module. You happen to have Drupal? Download CuteMenu now then!

If you have your own Drupal site, you may have noticed a set of tabs appearing at the top. The View and the Track tab often appear on your site even for anonymous users. This is really annoying!

Here I show you what I see when I go to one of my pages. The View, Edit and Track tabs.

Problem

As I'm working with MS-Access, I'm learning all sorts of things.

I had to write my own SQL because the database management was such that a simple form just did not fit well (i.e. things like multiple unique keys to be checked between MS-Access and a QuickBooks database...)

The SQL is relatively easy to write (there are a few tricks with MS-Access, for instance, dates are written between hash characters: #2009/01/01 00:00:01# and you cannot use all balls or it fails!)

Now, I tried to use the same form to:

Subversion Labels?

At this time, Subversion does NOT support simple labels.

This would be neat, but it simply isn't available.

What I usually want to do is mark all the files in a folder with a label to mark that point in time as a specific version. There is no feature in Subversion to do that.

There are many different things you can do to circumvent this problem.

[toc hidden:1]

Whenever I try to merge, which does not happen very often, with the SVN source control system (i.e. Subversion), I have to test 20 different ways before I finally find the right way.

Now, I'm writing the solution that works for me.

The command I have to use is:

svn merge -r N:M file:///path/to/svn/file /destination/path

The path to the SVN file is the same as what you would use to check out that specific folder (file).

Thank you for visiting my website.