The Linux Page

Page list for MS-Windows

  • MS-Access defines many different types, including a newer one called DECIMAL.

    You are supposed to be able to create tables with the DECIMAL type. So a statement such as:

       CREATE TABLE MyTbl (decimal_test DECIMAL(20, 5))
    

    should work. Right?

    I have been using CurrentDb.Execute for a while and that statement was causing the Execute function to return an error saying that the field definition was erronous (Syntax error in field definition, to be exact).

    The trick is very simple!

  • A quick CSV (Comma Separated Values) reference:

    1) Row separator

      \n   \r\n

    In order to separate lines, use a newline character sequence.

    Most loaders probably support the \r sequence too. (Especially on MacOS/X)

    [toc hide:1]
  • 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
  • Today I ran in a problem with cmake which was to very simply select /MT instead of /MD for a small set of projects. The problem is that so far this feature was at least on a per directory basis. Since the exact same directory is used to build the dynamic (DLL) and static (.lib) libraries, having two directories is not exactly an option here.

    set ( CMAKE_CXX_FLAGS_RELEASE "${CMAKE_CXX_FLAGS_RELEASE} /MT" )
    set ( CMAKE_C_FLAGS_RELEASE "${CMAKE_CXX_FLAGS_RELEASE} /MT" )
    set ( CMAKE_CXX_FLAGS_DEBUG "${CMAKE_CXX_FLAGS_RELEASE} /MTd" )
    set ( CMAKE_C_FLAGS_DEBUG ...
  • Synergration AccessBooksRT is a tool we use to get a copy of QuickBooks tables in an MS-Access database.

    It works great for our purpose and transformed some super sluggish forms into lightning fast forms. We still use QODBC for some of the work (updates) but 99% now goes through the database generated by Synergration instead.

  • Since I got my Android phone earlier this year, I got a huge problem with Google Calendar.

    I use the calendar mainly on my Desktop. Big screen, easy to read and use. But on the Android, the format is Agenda to make it possible to use at all.

    Somehow that has a really bad side effect: the display is now always forced to Agenda on my Desktop too. Really annoying!

    Tere is actually a very easy fix! It took me months the discover it and it's actually very easy.

    I have the Calendar link bookmarked so I can just click one button to get it open.

    All I had to do is add the following anchor at ...

  • Today I found a table describing the keystrokes you can use to generate different letters in another language than the bare ASCII set used in the US. For example, it is nice to use "à" in French whenever necessary because "à" (a preposition) has nothing to do with "a" (a conjugated verb).

    Microsoft includes that feature for most of their software. It may not work in all software, although you can always open wordpad and then copy and paste the output. (Notepad is not enough, it does not support UTF-8 or Unicode too well.)

    ...
  • I was ask by a customer to add line numbers to each entry in a table shown in an invoice.

    The concept is pretty simple, but really, how do you do that properly in MS-Access?

    Microsoft actually has a solution (see link below) and it comes down to writing a function that counts the number of items from that item's current position to the beginning of the table (i.e. going backward). It works, it is just really bad if you have very large invoices since it will tend to slow down as you start getting many items.

    There is the function, we can see the counting in the do until near the end ...

  • As I write programs, mainly in C++, I document them using the Doxygen tool. This is a very powerful parser that is capable to finding functions, variables, macros, and many other things in the source code and attach the corresponding documentation to those functions, variables, macros, etc.

    This is extremly practical when creating large projects or libraries that you want to share with others.

    One problem though, by default it seems like global functions (and thus C functions) and variables do not make it to the documentation, when C++ classes work fine.

    There are two potential issues:

    ...

  • Let's start with my rant!

    I like Drupal, in general. But like most PHP code bases, if an "error" (mistake) occurs, nothing is reported.

    I spent hours trying to make one of my menu work (Note that the "menu" module is also called the "links" module.) It just did not want to go. In order to have the nice breadcrumb and other such features, you need to have menus with sub-sub-menus...

Syndicate content

SMS From Me Logo

SMS From Me

To automatically start one on one conversations with your online leads.

     

   

Terms of Site Index

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