Syndicate content


MO Paragraph trimmer filter test page

This page has empty paragraphs at the top (before this line), at the bottom and in between each paragraphs. In a way, this is a weird module!

It use the MO Paragraph trimmer filter1, written in PHP for Drupal 6.x, to remove all of those empty paragraphs. Sadly, there isn't a good way for you to check the page source, but you can test by posting a comment (I think...)

The idea ...

  • 1. Available on the Made to Order Software website.

MS-Access: INSERT INTO syntax error

Today I was creating a report and created a table with a column named 'Group'. It looked like it worked just fine so I moved on with it.

Then, at the point I wanted to insert data with a simple INSERT INTO ... statement, it broke. The statement would generate a syntax error. Yes. The simple answer is that GROUP is viewed as a keyword and thus when used as a field name it needs to be escaped (i.e. written between backward quotes: `...`). Not liking the need to escape a field name each time I use it, I just renamed the field which is even better.

I put that radio button in the wrong Option Group, MS-Access

It happens all the time. You create two or three option groups and start adding radio buttons.

Then you write some VBA code attached to each button and/or their option group.

And at some point in the development you notice that one was put in the wrong option group.

Just deleting the option and creating a new one is not a good option because then you have to make totally sure you have the right setup and that can take some time to review.

Instead, you can move a radio button from one option group to another by following these steps:

No AfterUpdate event on Check Boxes in MS-Access?!


  1. My checkbox does not have an AfterUpdate event
  2. When running, I cannot de-select that check box once selected

Discovery Process to Solution

In MS-Access, you often want to run an action after the user changed something in a form.

at job spool growing

How it works

The at command is often used to start a process at a later time. It can run any script at a specified date and time.

For instance, if you want the computer to send you a signal in one hour, use something like:

cat signal | at -q z now + 60 minutes

Assuming that the file named signal contains the commands necessary to generate the signal. Then in 60 minutes, the script will be execute and the signal will be heard or shown.

Connections to, why is that?

Lately, I noticed that I always had a connection. I was wondering why... I did install clamav but I did not recall changing anything in Apache where I'd get requests from the outside that would look like clamav.

The fact is I also installed freshclam. By default, that gives you a line like this in your netstat -a64 listing:

    tcp   383     0 halk:38272     CLOSE_WAIT

Most of the time you won't catch it when it is still connected and sending/receiving data. The deamon that accepts the connections is freshclam and it will save the new data ...

PHP glob function does not return softlinks

I use all sorts of tricks in order to duplicate functionality without actually duplicating PHP code.

One of the main, easiest way under Unix is to create softlinks. First put all your code in one folder, then create a softlink to it. That gives you two paths:

MS-Access constants

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.

ComboBox bug

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.

MS-Access weird = [Field] error...

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.

Syndicate content Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165


Terms of Site Index

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