Syndicate content

Page list for MS-Windows

  • 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 wrote some MS-Access code that I want to execute once a day.

  • 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

  • Use at your own risk! These are links to other pages outside of this website:

  • Story

    Inserting a row ina database is done with the INSERT INTO command line. This is quite standard SQL.

    MS-Access supports the INSERT INTO instruction too. You can write macros that make use of it.

    I have used it for a while and had not problems. But yesterday I discovered that there was a case when it simply wouldn't work at all. The strangest thing was that it did not work with an MS-Access database without any one error. No error at all.

  • Have you seen animated icons in your tabs? This has been working for a while, with IE and FF and Co.

    All you have to do is create an animated GIF file as your "favicon.ico", and it is better to name it .gif, by the way.

    Because icons can now be pretty much any image format, not just .ico

    And if you need some favicon for your site, check this one out:

    Many of these are free!

  • I create this page to talk about the work I've done to create a small Flash animation (under 1Kb) used to play a stream of audio (most specifically, from the radio Hotmix 106.)

  • How to force a download of any file in a CGI script

    I have been wondering for a while, now I have the answer, so I can share it with you guys.

    Your script has to do the following steps:

    1. Print a header which at least includes:

      1. Content-Type: application/force-download

        (you can also use octet-stream instead of force-download)

  • I have been wondering how to lock a few rows and/or columns on a side in Excel. I have seen that being done many times, but did not know how to do it myself.

    In the Windows menu (Before Office 2007) and in the View menu (Since Office 2007) you will find an option named Freeze Panes. You have three selections:

    1. Freeze the selected top rows
    2. Freeze the selected left columns
    3. Freeze the selected top rows and left columns

    If you just need one row and/or column, place your cursor in the A1 cell.

    [toc hidden:1]
  • Introduction

    These are common questions for MS-Access users:

    • How can I get the name of the currently logged on user?
    • How can I get the name of the computer the user is working on?

    Both names are available in the Kernel and we can make use of a function declaration to access those names.

    MS-Access Functions

    To determine the name of the current user:

    Private Declare Function GetUserName Lib "advapi32.dll" _
        Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
    Public Function GetLogonName() As String
        Dim lpBuf As ...
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.