Show MS Access Subreports With No Data

On MS Access applications, usually I use subreport objects with SQL queries of their own, linked to the main report which includes the subreport. Classic example of such master-detail reports is invoices: + master (main report) section includes invoice date, invoice number and details of the customer account such as name and address lines. + … Read moreShow MS Access Subreports With No Data

“Flex”ing with web services using Zend AMF

PHP has always been my favourite scripting language to develop applications for the web. I have always envied Flash applications! PHP applications, to me, are a fine mixture of PHP + SQL + HTML + CSS + JavaScript. You can always add the fancy TLAs in your applications such as XML, if you want to. … Read more“Flex”ing with web services using Zend AMF

Another clumsy application from Microsoft: cisvc.exe

Also known as content indexing service, this process is part of Windows operating system, and it is supposed to index the files on the drive(s), which should provide faster file search and access using the indexing service catalog. Instead of speeding up your machine, it sometimes slows it down, which is probably because some dummy … Read moreAnother clumsy application from Microsoft: cisvc.exe

Paging records in MS SQL Server 2005

After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).

It is simply unacceptable, non-standard, impractical! By the way, you can not use column numbers (e.g. ORDER … Read morePaging records in MS SQL Server 2005