Syndicate content

Microsoft

Display a line number in a table (i.e. subform of records)

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 ...

not enough actual parameters for macro min() or max()

As I was porting wpkg to Windows so it would compile under Microsoft IDE version 10, I ran in a problem with variables named min and max. Windows wanted to see them as the min(a,b) and max(a,b) macros.

That started happening when I included Windows.h which I needed for handling files (CreateFileA, CloseHandle, etc.).

Since these are macros, i.e. defined with #define ..., they take priority over anything in your C++ code (since that's handled with your preprocessor.)

One way to get rid of them is to undefine those macros after the #include, something like this:

#include ...

Compile Qt 4.7.x with Visual Studio 10 (VC++ 2010)

Try to recompile Qt with Pavel's instructrions...

I did not encounter much problems, although the examples failed. It looks like jom would be the problem as some people reported not having problems following the same steps, but using nmake instead of jom.

The instructions go like this: [Update: the links below all stopped working.]

  1. Visual C++ 2010 contains all necessary SDKs for Qt compilation. However if you plan to use Qt with Phonon you need to install additional software from Qt for Windows Requirements list.
     
  2. Download and extract Qt 4.7.4 Sources. (Or Qt ...

Saving a .dot file as a template for MS Office

To avoid recreating the same styles and title, summary pages over and over again one wants to create a template file. These are called <name>.dot where dot means document template.

To create a .dot just create a regular .doc file and then when saving it, change the extension to .dot. Nothing complicated here.

Now, if you are with a large company, the template file would be saved in a folder where Microsoft Office can find it automatically so when you say New you can then choose your template, it has to be placed here:

    C:\Users\<name>\AppData\Roaming\Microsoft\Templates

Where are the network connections on Windows 7?! (for static IP addresses)

I don't know about you, but on my end I like to use static IP addresses on my Intranet.

But under Windows Vista and Windows 7, Microsoft have done an incredibly good job at hiding the network connections to make sure you don't temper with them.

The path is as follow:

        Control Panel\Network and Internet\Network Connections

Once you are in there, you can use the right mouse button to get to the usual MS-Windows settings (The one where you can click on IPv6 or IPv4 and setup the IP to static.)

Windows 2000 SP4, new logon policy forced to Roaming by default.

Not too long ago, I accepted the update from Microsoft to go to MS-Windows 2000 SP4. Neat. Except that when I rebooted (I think the 2nd time, but not totally sure, my wife used the computer in between, it seems...) it could not load my profile anymore.

MS-Access variable types that do not exist?!

Problem

I worked on a project with many functions that access the database. These functions will generally have a Recordset variable. Yet, when I tried to run a script with the recordset declaration, it would fail with the error Undefined variable type.

  Dim rcd As Recordset

Since that definition was not required for the software to work, I ignored the error for a long time.

PNG Fix for IE 5.5 and 6.0

If you don't work on creating web pages, you are probably not much aware of the creativeness necessary to make them work in Internet Explorer 6.0 and older.

Today, I had to make PNG images work in IE 6.0 since one of my customers still has that version of the browser and his website has several PNG images that require to have a working alpha channel.

[toc hidden:1]

Scan Alert

Just got that message today:

[18:06:04] Scan Alert: WINDOWS REQUIRES IMMEDIATE ATTENTION
=============================

ATTENTION ! Security Center has detected
malware on your computer !

Affected Software:

Microsoft Windows Vista
Microsoft Windows XP
Microsoft Windows 2000
Microsoft Windows Server 2003

Impact of Vulnerability: Remote Code Execution / Virus Infection /
Unexpected shutdowns

Recommendation: Users running vulnerable version should install a repair
utility immediately

Your system IS affected, download the patch from the address below !
Failure to do so ...

OpenOffice Presenter

Already used OpenOffice? This is a free office suite just like Microsoft Office (or MS Office). It does not include absolutely everything, but it has most certainly a lot more than you need!

Syndicate content Syndicate content