Syndicate content


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.

Marking a Subversion tree with a label

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]

Dates in MS-Access & QODBC

Working with MS-Access and writing SQL queries to run via QODBC to get data from QuickBooks, I ran in a problem with dates.

I needed to sum the sub-total of all the rows for a given year. So that is pretty simple SQL1:

SELECT SUM(subtotal) FROM Invoice WHERE YEAR(TimeCreated) = YEAR(NOW())

That does not work. So I tried to generate the year in the macro code and sticked that to the statement:

SELECT SUM(subtotal) FROM Invoice WHERE YEAR(TimeCreated) = 2009

And that does not work either.

I tried ...

  • 1. Although at first I tried with BETWEEN, I simplify my samples here

MS Access classes

As most people know, all of the MS-Office macros are written in Visual Basic.

Visual Basic is for sure a huge whole lot better than the BASIC I had on my Apple //c. For one thing, it does not require line numbers and you can declare functions, procedures, and have local variables (FOR loops that use the variable I do not overwrite the variable I of the FOR loop from the calling function!)

Since MS-Access 2007, we have the possibility to create classes!

RETURN not working in Visual Basic & Arrays...

RETURN statement in BASIC

Like many programmers, I switch between languages quite often.

I have worked with BASIC before since I had an Apple //c and used other Apple ][ computers that had some (really bad, early) BASIC language in their ROM.

At the time, the worst part was the line numbers. You had to write in BASIC as if you were writing assembly language. And I'll skip the numerous problems with memory...

PAD File

PAD File Module for Drupal


You can find my PAD File module on Drupal.

It is intended for any company and individual that has executable files for download but its customers and potential customers. The PAD File describes the content of such executable to the target machine (robots that spider the Internet for PAD Files).

With the module you can create, import, update and delete PAD Files as necessary. It automatically generates the XML files and maintains them on your website without you having to do anything about it.

It is also intended ...

Enhanced DLLs

Pre-Pre-Scriptum: Please, look for the edll library. It is now available as a free library for MinGW.

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.

  • Fiesty

    Name of a Walt Disney character used for a version of Ubuntu.

  • HTML
  • cc
    The Unix C compiler. This is an old language that started the frenzy of advanced C, C++ and C# languages. Many other languages are also based on C such as PHP, Java and Javascript.
  • code
  • server