Saturday, December 22, 2007

Photoshop Videos Search Results at macromedia.com

Search results for Photoshop videos. Lots of good Photoshop information, tips, tricks and techniques.

read more

Tuesday, December 11, 2007

Adobe Photoshop Tutorials - Best Of

An overview of professional step-by-step tutorials which can enrich your design skills and improve the quality of your works.

read more

Friday, November 16, 2007

Excel to Word mailmerge problem

Today there was this small thing that took my time. A date field in excel was formatted correctly but when the field was used in the mailmerge with Word. The format in the excel was not being reflected in word.

So I used the following steps to correct this in Word.

Step 1. Right click on the field name
Step 2. Click on the ‘Toggle Field Codes’ option For eg., { MERGEFIELD “AFinish” }
Step 3. Edit the field to include \@ “dd-MM-yyyy” e.g. { MERGEFIELD “AFinish” \@ “dd-MM-yyyy” }
Step 4. Right click and click update field.


You can see the date format as 17-08-2008

Thursday, November 01, 2007

Viewing DTS scheduled jobs

I wanted to view the scheduled DTS jobs. So obvious way I thought was to do view it where I created. But for some reason, the schedule has been reset. So there is no way we can view the scheduled jobs of DTS here.

If you want to view these jobs, you have to access the SQL SERver Agent as these jobs are run by SQL SERVER Agent. So follow these steps to ciew your scheduled jobs on SQL server.

Go to SQL SERVER Enterprise Manager -- Management folder
Then click on SQL SERVER AGENT -- Jobs

Here you can see the job name status etc.

Wednesday, October 31, 2007

Automatic processing of SSAS cubes

I needed to automate the process of refreshing my Sql Server Analysis Services Cubes. My SQL server is 2000 and Analysis Services is SP4.

The approach I followed today is as follows:

I created a package in DTS of SQL Server 2000

Step 1 Created a SSAS task and pointed the Dimension (Rebuild the dimension) that needs to be updated.

Step 2 Then I created another task to refreshh all cubes.

Step 3 I created a On Success workflow between the above two tasks.

I saved this package and scheduled it to run monthly.

Tuesday, October 30, 2007

Displaying Temporary Internet Files folder in Windows Explorer

I am so used to browse the temporary internet files folder for internet exploer but I was not able to do this since I upgraded my Internet Exploer to 7. I finally found a way to do this. Microsoft has made the temporary internet files folder a 'Protected operating system folder'. That is the reason we cannot view that folder even when we check on the option 'Show hidden files and folders'.

All we have to do is Go to Windows Explorer -- Tools -- Folder options -- View tab
Untick the 'Hide protected system files and folders'

And you can see the Temporary internet files' folder in C:\Documents and Settings\User\Local Settings\ folder.

Saturday, October 27, 2007

Java based math course includes problem-solving lessons and tests

Visual and interactive way to thorough understanding and mastering Trigonometry without getting wearied on the very first chapter! Java- and web-based math course includes theoretical

read more

Friday, October 26, 2007

Concatenate values from two text box and populate the value in another text box

Today I had to create a function to concatenate two values from a text box and populate the output in another text box. This I did to inmprove the usability of the form for inputing the credit card data.

This is what I wrote



function conc()
{
var mon;
var yy;

yy=document.getElementById("Texty").value;
mon=document.getElementById("Textm").value;
document.getElementById("Texte").value=yy+mon;
}

Wednesday, October 24, 2007

Web Photo Gallery with Photoshop

Today I was googling for some CSS photo gallery that I want to use for my website. I found quite interesting ones as follows:

Library of CSS Stylesheets
Joshuaink Photo Gallery Template
http://www.cssplay.co.uk/menu/lightbox.html

The one that suited me was described in this chapter on Techrepublic.

As I was about to call off my search, I found this easy way of creating a photogallery using Photoshop CS2 which is really handy if you have to create a photo gallery out of many photos.

Wednesday, October 17, 2007

How to Create an "Invisible" Folder for Your, um, "Private" Files

You ever have a folder on your computer that you really dont want any one to find? You can make this folder hidden but then you have to un-hide all the folders when ever you want to find it. So how can you make a folder truly invisible? Follow these simple steps and your unmentionables will stay that way

read more

Friday, October 12, 2007

My first project in c# ASP.net

Today for the first time I created a project in ASP.net. All this while I was doing some modifications for SQL code and reports for existing .NET projects. I wanted to recreate the functionality described here

When I did exactly what was said and tried to access the webpage, I got the error "Code not parsed...." When I googled for this error, then only I realised that I did not build the solution. So the error was fixed when I compiled the project.

Monday, October 08, 2007

Problems with connecting to proxy

Wayne, our systems Administrator contributed this:

Having problems with a user who cannot connect to our proxy server because their Internet Explorer keeps using a manually entered username and password, instead of their domain username and password. Even typing in the correct username and password doesn't work. Tried resetting IE settings, changing authentication options, with no success. Finally found instructions on removing the saved passwords, and that fixed the problem.

Windows XP does not offer a very easy way to review or remove the saved passwords though. If you follow the steps below though you can access a graphical interface to add, remove or edit the saved passwords on a given system.

1. Click Start and select Run

2. In the Open field type "rundll32.exe keymgr.dll, KRShowKeyMgr"

3. Once the Stored Usernames and Passwords interface opens you can select any of the entries and select Properties to view the existing information

4. To remove a saved password you can select one of the entries and select Remove. A confirmation screen will appear. Click on OK and the account will be removed

5. You can add additional saved passwords as well by clicking on the Add button and entering the appropriate information

6. Repeat the steps above as needed to add, remove or edit saved passwords

7. When you are done using the interface click the Close button

Thanks Wayne, for your contribution.

Friday, October 05, 2007

12 Ways to Make Better Use of Your Footer

Great list of ways to use an extended footer on a blog, and why you should move stuff down there as opposed to cluttering up your sidebar.

read more

Wednesday, October 03, 2007

Tuesday, October 02, 2007

Use SQL subselects to consolidate queries

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

read more | digg story

Sunday, September 30, 2007

Messy Code? Stumped? Submit it to be refactored @ refactormycode.com

Have you got a method that you're dying to simplify? A class that's growing out of control? Or an algorithm that you just can't get working? Submit it to the new, awesome web app Refactor My Code, and have it refactored.

read more

Tuesday, September 25, 2007

The Flash Blog - Some great examples of Flash UI development

It seems as though Lee Brimelow is from Adobe. He is somehow connected to gotoandlearn.com, which has a lot of awesome tutorials on how these sites are made. Good site to check out if you're into flash UI dev. Cool stuff, check it out.

read more

Thursday, September 20, 2007

Prompt for downloading word documents

I have created a functionality that will allow the users to download a pdf or a word document. The download was working fine when I used it, but on another machine I noticed that the prompt for download that asks the user whether to open or save the word file was not appearing.

These are the steps you need to follow when you are faced with this problem.

Go to the windows explorer,
Choose Tools-- Folder options
Click on File Types tab
Choose file type 'DOC' for word, 'PPT' for Powerpoint etc.
Click on the Advanced botton
Make sure that the "confirm open to download" checkbox is ticked.

Hope you enjoy it.

Sunday, September 16, 2007

Wondershare Flash Album Studio v1.8.0

Looking for a new exciting way to show off your photos? Amaze your friends by taking them into the stunning flash photo galleries with Wondershare Flash Album Studio.

read more

Monday, September 10, 2007

Flash Effect Maker Pro v3.5 w / 578 Templates

Flash effect Maker is the great Flash effect tool to help webmaster design animated Flash intros, Flash banners, Flash ads, and any other Flash. With Flash effect Maker you can place your own photos as font front ground and page background. And then combine them with animated text, background effect to create fun Flash movies, all in just minutes.

read more

Monday, September 03, 2007

Mp3Resizer v1.8.3

Mp3Resizer is created to optimize the capacity of your portable music player by reducing the size of mp3 files. This is especially useful when listening to MP3 files or MP3 Audio books on a mobile phone, MP3 player, Pocket PC, etc.

read more |

Wednesday, August 29, 2007

Ajax Utilities

Here are more than 150 ajax utitlity with full description about each utility

read more

Friday, August 24, 2007

Unable to enlist in the transaction

Today after about a month again I was facing a similar problem of unable to enlist a transaction. I took half a day, to realise that this is the problem as there was no error when I was using the web interface but the results were not coming up. Then I slowly started looking at the event viewer and only then I noticed the "Unable to enlist a transaction error". I didnot expect the reason for this until I read this article, When I disconnected the firewall everything seems working well. I have now switched the firewall back on by allowing the port for MSDTC as 3372.

Wednesday, July 25, 2007

document.getElementId() has no properties

Today I was getting this error, in Firefox even though the Javascript code that I wrote was working fine.

I had a feeling that my javascript code was not working, and concentrated to work on that.

But the error was not in the javascript code but in the xsl code.

To solve these kind of errors in FF give your elements IDs instead of names and reference them with

document.getElementById("id")

IE seems to be a bit relaxed even though you have a name defined and not the Id.

Tuesday, July 24, 2007

Adding lines on a stacked column chart

Today I had a need to do a graph in Excel where it need to display a stacked column chart and also a line in the same graph.

The data for this is as follows for three years

2008 2009 2010
12000 14000 16000
1000 1000 1000
170000 180000 200000

I wanted a stacked column with the first two rows and a line with the last row. But when I chose the normal 2d column chart, it was showing all three rows as one stacked column.

To get the desired results, I followed the following steps

First, include all three rows in the series part of the chart data and choose the 2d stacked column chart

Next, right-click on the colored part of the bar that corresponds to the year and choose "Chart Type". Then select the first Line graph. Click Ok

Finally, right click on the graph and choose chart options and tick the 'Value Y Axis' tick box under the secondary axis lable of the 'Axes' tab

You should now have the first two rows displayed as a stacked column chart and the third row displayed as a line graph above your columns.

Monday, July 23, 2007

Convert VBscript to Javascript

I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful

Beware that this tool does not work in firefox though.

Sunday, July 22, 2007

New transaction cannot enlist in the specified transaction coordinator

I was faced with this error when I was trying to configure a web application and trying enter a transaction through the virtual website. Thanks to the internet, I found a lot of information on the internet.

Here are the steps I followed to correct this:

Start the Component Services administrative tool. To do this, click Start, click Run, type dcomcnfg.exe, and then click OK.
In the console tree of the Component Services administrative tool, expand Component Services, expand Computers, right-click My Computer, and then click Properties.
Click the MSDTC tab, and then click Security Configuration.

Turn on the Network DTC Access
Allow Inbound
Allow Outbound
Enable XA Transactions
Choose No Authentication required

Save these settings and reboot your system.

The error is fixed.

In Windows Server 2003 SP1 and in Windows XP SP2, the Distributed Transaction Coordinator service gives you more control over the network communication between computers. By default, all network communication is disabled. The Distributed Transaction Coordinator Security Configuration dialog box has been enhanced so that you can manage these communication settings.

Friday, July 20, 2007

Tuesday, July 10, 2007

Understanding the C in CSS

This simple tutorial explains the cascading feature of CSS. Useful for those starting out with CSS or if you need a refresher.

read more

Thursday, July 05, 2007

Creating Excel Spreadsheets from VB.NET

This nice tutorial walks you through step by step creating an Excel spreadsheet with multiple worksheets. This nice introduction includes full source code and detailed instructions to help you get started.

read more

Sunday, July 01, 2007

Friday, June 29, 2007

Top Ten of Programming Advice NOT to Follow

A top programmer examines a number of the top items of programming advice commonly given, and makes a great case for why they should NOT be followed. Some interesting food for thought for any programmer.

read more

Thursday, June 21, 2007

Ten CSS tricks you may not know

Cascading Style Sheets are the foundation on which many of the best websites are built. Using CSS allows developers to describe the common style for the website, in terms of colours, fonts and layouts. In this tutorial, Trenton Moss of Webcredible shares some of his top tips to help you get the most from your CSS.

read more

Tuesday, June 12, 2007

Online JPG to HTML Converter

Probably how the "Crazy guy can draw using HTML!!!"A table is created which is filled with large numbers of 1x1 cells. Each cell has a background colour of the corresponding pixel in the image. That's all it is; just a massive grid of coloured table cells. View the source to see the details.

read more

Wednesday, June 06, 2007

Inspiration Package: 60+ Usable & Elegant Designs

Over 60 elegant, usable and impressive designs with a well thought-out color scheme, typography and visual structure. Their beauty lies in the way both information is presented. Their usability lies in the way they communicate presented data. That's what make them different.

read more

Tuesday, May 22, 2007

DTS -- My learnings today

Today I wanted to schedule a data update process to be processed every month for the table I created using DTS last month.

I wanted to populate a brand new database from an exisitng database. I thought I would just schedule a package with a few SQL queries to populate the different tables in the new database. But before I proceededI wantedto find out an efficient and best way to do it.

So I posted my questions in two forums. This is what I found out from the experts:

Before you decide on setting up the DTS package there are several aspects to consider.

Do you want to recover the database from a backup when something goes wrong?
Do you want to just reload everything when something fails?
Do you want to save logging information so that you can recover the database?

Based on the answers to these questions, the best way to create a DTS package for my scenario is to create the tables with the structure and then create the DTS package using many Data Driven Query Tasks that contains the SQL statemetns of select, Insert and Update depending on whatever the case may be.

DTS is an excellent tool to schedule population of data into a database.

Monday, May 21, 2007

SQL query to get Month Name for today

I wanted to insert the month name of the current date into a table using a SQL query.

I first thought that I could achieve this by simply using the monthname function. But when I typed that in the SQL Query analyser, the error made me realise that it is not that easy to get the result I want.

So in the end here is what I came up with:


select datename(month, getdate())+'-'+ convert(varchar,year(getdate())) as Month_

Sunday, May 20, 2007

Automating the .NET Framework download and installation

Here's a script that automates the download and installation of the .NET 2.0 Framework prior to installing a .NET application, using all free tools including InnoSetup. If .NET is not installed on the target computer, then this script goes out and downloads it, showing a progress meter along the way, and then installs it on the target machine.



read more

Thursday, May 17, 2007

Five ways to defeat blog trolls and cyberstalkers

Online harassment is going gangbusters in the blogosphere. With 70 million blogs in existence today there are a lot of nut jobs out there. From cyberstalkers and trolls to flamers and kooks, it's only a matter of time before some of them find their way to your blog. Here are five ways to make sure you don't become a victim.



read more

Wednesday, May 16, 2007

Top 17 Free Webmaster tools

A list of 17 Free webmaster tools. This list includes several HTML and CSS tools, SEO tools such as backlink checker, keyword density, and several other useful miscellaneous tools.



read more

Thursday, May 10, 2007

Toolbox for Web Developers/Programmers (tlbox.com)

Add tools to your tool box that you can refer back to. Useful website listings for HTML, PHP, CSS, Images, Tutorials, Widgets, etc. Great links.



read more

Wednesday, May 09, 2007

What's Wrong With My Blog? Guide to common pitfalls & mistakes in blogging

Creating a blog is easy - but alas, building a readership is somewhat more difficult. So where do nascent bloggers most commonly go wrong?



read more

Thursday, May 03, 2007

Dramatic Black and White photos using Photoshop

Converting photos from color to black and white can be done in a variety of ways in photoshop. The easiest way is just to convert your image to grayscale, but this usually leaves you with a rather flat and dull looking image. This article will show you how to convert color photos to dramatic looking black and white photographs in photoshop.



read more

Monday, April 30, 2007

Javascript and CSS Tutorial - How to make Sliding Panels

A step-by-step tutorial on how to create sliding panels using javascript and css. Included in the tutorial are good examples guiding you through each step.



read more

Thursday, April 26, 2007

Test your Web Application’s Performance

A step by step tutorial on how to stress test your web application and your web server with proven Open Source software.



read more

Tuesday, April 24, 2007

Monday, April 23, 2007

Data Transformation Services -- SQL Server

Today I used Data Transformation Services (DTS) of SQL Server 2000 to populate a table in the SQl Server database from an excel file. This was an easy way of creating a table on the fly without bothering to create the table structure first and then populate the table with the data.


Procedure I followed was as follows:

Right click on a table or a database in the SQL Server Enterprise manager.
select Import data
Select the source as an Excel driver
select the destination as the table to be created inthe database.
Click finish and your table is ready with the data populated

Yes, it is that simple.

Thursday, April 19, 2007

15 Javascript Snippets You Can't Live Without

"You either love Javascript or you hate it. Either way it can provide great functionality that users love. And it doesn't have to affect usability. Here are the top 15 Javascript snippets for making great sites that bit extra special."



read more

Tuesday, April 17, 2007

How to make 'related articles' for your blog

If you operate or post for a blog of any kind (and chances are, you do), it's very useful to add a "Related articles" section to your blog so when somebody finds your article, the related articles will keep them on your site while keeping their interest in specific topics.



read more

Friday, April 13, 2007

View .psd's Thumbnail Previews In Windows Explorer

As of photoshop 7 you can no longer view your PSD files as thumbnail previews! Re-claim this great feature instantly with a quick registry edit.

read more 

Wednesday, March 28, 2007

Fade the Background Color of an Element using Javascript

This is probably the easiest way to fade the background color of an HTML element without having to use some huge DHTML library that has a bunch of things you don't need in it.



read more

Wednesday, March 21, 2007

Ajax for Web Application Developers

FREE Ebook! This book not only explores the technologies that define Ajax and how they come together to create powerful client-side interactions, but also ...



read more

Sunday, March 18, 2007

Building a Content Management System with Prototype

The Prototype library has grown in popularity among JavaScript programmers because of the powerful features that come bundled with it. In this set of three articles, you'll learn how to use this versatile framework for building a content management system. This first part will deal with the creation of the front end of the CMS.



read more

Monday, March 05, 2007

Full Guide On How To Make $1,000 A Month With A Video Blog

A step by step guide on how to design, build, optimise and market a video blog and make $30-40 a day. Two days work, months of profit!



read more

Wednesday, February 28, 2007

10 steps | Migration from a static website to automated content management

Many people do not know this, but the latest version of WordPress, combined with our optimized themes (this website is one) can fully automate a website, even for someone who knows absolutely no HTML at all, with limited computer savvy: As many static pages as desired can be built by simply posting, just like a blog post - the pages are automat...

read more

Monday, February 12, 2007

FindThatFile.com - Find any file you want on the web

Tired of searching through all the net just to find one file you want?
FindThatFile.com is a specialized search engine geared towards finding files instead of web pages, with a slick AJAX interface. The search engine is a crawler which looks for links to files over the web, saving you the effort of finding the file you are looking for by yourself.

read more

Monday, February 05, 2007

ThinkFree - The Best Online Office On Earth

ThinkFree is the world’s most compatible alternative to MS Office. ThinkFree office applications run online, on local servers, from the desktop, U3 drives, or from iPods, and include ThinkFree Write (word processing), Calc (spreadsheet), and Show (presentation).

read more

Sunday, January 28, 2007

ReportWala - No Hassle Reporting...

ReportWala is Crystal Reports Viewer. However you can do more than just viewing crystal reports with ReportWala. ReportWala is developed for Crystal Reports XI. If you want the Crystal Reports viewing capability for many users across the organization without buying expensive licenses of Crystal Reports Designer then ReportWala is rt choice for you.

read more

Sunday, January 21, 2007

Example: Quiz (Interactive Presentation)

This is just a simple example of interactive Quiz made with Spresent, using Button links to slides within presentation. What's interesting about it - it's interactive Web presentation, all done in the browser (created and published) and embedded into WordPress blog with easy Copy/Paste.

read more

Monday, January 15, 2007

Reset Windows Password

Password-Reset offers Windows users an easy way to gain access back into their computer if the administrator login password has been forgotten. This avoids the time consuming and costly process of reformatting the hard drive and losing all your valuable data.

read more

Friday, January 12, 2007

CrazyEgg - Measuring Web Site Usability

Jakob Nielsen's latest book, Prioritizing Web Usability, the usability guru presents his latest discoveries on how to design usable web sites. His meticulous research is based on lab experiments, with thousands of users of diverse backgrounds.

read more

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...