Total 2 column When 1 Column Has A Null Value

Problem  : I have 2 column that contain numeric fields but then one column sometimes does not have any value, means that it has null value.

Solution :  Use NZ function to convert the values to zeroes.

Example : NZ ([columnName1, 0 ]) +  NZ([columnName2, 0])

Running Number On Report MS Access

Problem :  Running number for each records for report  MS Access / Numbered Query

Solution : First add unbound text box. Then click properties, control source is = 1 and set Running Sum
               to all over.

                                       

Credit To : http://rogersaccessblog.blogspot.com/2010/12/domain-function-examples-numbered-query.html

Relationship Indeterminate

Problem : I want to create One-To-Many relationship between 2 tables, but it show indeterminate.

Solution : Specific fields must be primary and make sure dekat properties tu choose no duplicate.

Include All Records On Query

Right now I'm working on access project..

Problem : Pegawai yang tidak berkursus tidak akan di display dalam result query

Solution : Click edit the relationship line in the query and select the 2nd radio button to include all records from the first table termasuk pegawai yang belum pernah berkursus.

Credit to : http://stackoverflow.com/users/13302/marc-s

Uztaz Azhar Idrus

Today : 11.11.2011

Its been a while since I write something on my blog.
Malas nak tulis apa2 la...xdak idea.hehe..
Saja nak wat entri sbb date hri ne mcm best jak...=)
see u next time ..

Cronjob + Ruby Script

######### To Run Ruby Script Manual#########
/home/path/of/ruby/script ruby script.rb

########## To Run Ruby Script With Cronjob ##########
crontab -e

-------------------

RAILS_ENV=production

*/5 * * * * /bin/bash -l -c 'cd /home/path/of/ruby/script && ruby script.rb'


*p/s make sure script.rb file executeable without any permission denied.can use chmod +x..

Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName

Quite often, i face the same error. Well at first, i did not care as long as it still functioning..
Well, i follow this blog http://vyc0d.blogspot.com/2010/10/fixed-apache-error-on-ubuntu-how-to.html, and then there is entry about apache error on ubuntu..

When u restart apache with this command, sudo /etc/init.d/apache2 restart , result will be
* Restarting web serverapache2 apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
... waiting ...apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName


What u need to do is,

Type this command in ur terminal
sudo nano /etc/apache2/httpd.conf,
then at the end of the line, add this line : ServerName localhost.
After that,restart ur apache again. sudo /etc/init.d/apache2 restart.

Remember!!

[Al-Baqarah: 251]
And if it were not for Allah checking [some] people by means of others, the earth would have been corrupted, but Allah is full of bounty to the worlds.

[Al-Baqarah : 253]
If Allah had willed, succeeding generations would not have fought against each other, after clear Verses of Allah had come to them, but they differed - some of them believed and others disbelieved. If Allah had willed, they would not have fought against one another, but Allah does what He likes.

403 Forbidden Access Apache2

Bru dapt solve masalah forbidden access ne...
Well, at first my project working just fine until I accidentally do something with my laptop.
Then when i want to view my project through browser, I got that forbidden message saying that
I don't have access for my project view..
So what I do is asking Mr Google, and most of the solution said that my configuration file might be corrupted. I tried my time and I still got the forbidden message.
One of the solution also said about file permission but they did not explain throughly so I try to see file permission of my project folder and then I realize that my project only permit me view the folder. Then I use chmod 715 for my project folder and guess....it really work.
Alhamdulillah...
Well next step is to re-code existing function, I need to try other method.

Ihya Ya Ramadhan

Alhamdulillah, ramadhan bertamu lagi..
Ustaz ada kata b4 nak berpuasa ne kena la ade persediaan,mcm la nak bersedia tuk exam...
Antara persediaan yg ptt ade, kena la rjin berpuasa sunat kan,biasakan puasa dan jalani aktiviti harian dan juga peringatan2 tntg ramadhan.
Manusia ne sifat dia pelupa, jdi walaupun da tau kena di ingatkan selalu...
RAMADHAN.... Biasa kita dngr, puasa ne mgajar kita mcmn org miskin ne jalani hidup mereka..dan juga puasa ne ngajar kita mcmn nak kawal diri dari wat bnda2 yg kurng berfaedah... Ramadhan ne juga bermaksud Allah nak tunjk kat kita yg manusia ne lemah, tak boleh hidup tnpa mkn dan minum.. mgkin kita boleh hidup tanpa mkanan tuk bberapa ari tpi tanpa minuman berapa lama je kita leh berthan kan..Tue la sifat kita sebgai hamba yg lemah... Allah nak tunjukn yg kita ne hanya la hamba..hamba yg lemah..DIA la yg berkuasa atas semuanya,tanpa perlu mkn atau minum dan tnpa tidur..

Bila ramadhan, kita di galak kan untuk bgun bersahur..Tapi apa yang biasa kita buat adalan makan tuk sahur pukul 2-3 pagi. Bangun sahur sepatutnya adalah before subuh selepas tidur seketika. Dengan tue, kita juga boleh bwat solat tahajjud juga.Bukannya sahur untuk mengelak kan rasa lapar di pagi hari saja tapi sahur yg membezakan antara puasa umat islam dengan puasa umat lain.

Kita juga di galakkan beramal sebanyak-banyaknya bagaikan inilah ramadhan kali terakhir kita.
Antara amalan yang kita patut perbanyakkan adalah :-
# banyankkan bacaan tahlil ,lailahaillallah
# Istigfar, astagfirullah
# Minta la syurga Allah
# Doa perlindungan dari api neraka .

Malam raya biasanya kita sambut dengan meriah ttapi bukan dengan amalan2 ibadah, yang kita sibukkan adalah baju raya dah siap ke belum, kuih2 raya dah masuk balang ke blum...
Tetapi apa yang kita patut amalkan adalah lagi banyak kan ibadah sebab malam raya adalah malam penganugerahan,malam kesimpulan,malam penghujung ramadhan.

Netbeans/PHP

Just now bru je berjaya wat pojek test using PHP in netbeans..
Berpindah sebentar dri ruby kepada PHP since kena maintain dlu pojek org lain..
Mcm seronok je bila da kuar index.php tue padahal bnda simple je.. ne sebab xpernah nak ambk tau sal
PHP,cian kat dia kan...=)
Since nak write pojek ne gn netbeans,so first step kena la PHP tue wujud kat dlm netbeans tue...
First pg kat Tools --> Plugin ,pastue taip je PHP then
install la plugin tue..dah siap...=)
Then start la new project for PHP...ikut je smua default setting dia so xyah risau pape kot..
Tpi bila da run pojek tue, kuar lak error 404 not found.(The requested URL /PhpProject1/index.php was not found on this server.). bila check apache server,dia function je.
Then guna la Mr Google,teman baik kita semua.. Bila search,xdpt pun solution dia...
THen Allah bg ilham,try tgk kat url link dia... bila tgk blik pojek directory tue ade kat Desktop
tpi kat url tue tru je g nama pojek folder tue,so try letak nama Desktop kat depan tue...
mcm magik je kuar la index.php tue...akhirnya alhamdulillah...^^

Maher Zain

Insha Allah Lyrics | Inshallah Lyrics

By: Maher Zain

Everytime you feel like you cannot go on
You feel so lost
That your so alone
All you is see is night
And darkness all around
You feel so helpless
You can’t see which way to go
Don’t despair and never loose hope
Cause Allah is always by your side

Insha Allah x3
Insya Allah you’ll find your way

Everytime you commit one more mistake
You feel you can’t repent
And that its way too late
Your’re so confused, wrong decisions you have made
Haunt your mind and your heart is full of shame

Don’t despair and never loose hope
Cause Allah is always by your side
Insha Allah x3
Insya Allah you’ll find your way
Insha Allah x3
Insya Allah you’ll find your way

Turn to Allah
He’s never far away
Put your trust in Him
Raise your hands and pray
OOO Ya Allah
Guide my steps don’t let me go astray
You’re the only one that showed me the way,
Showed me the way x2
Insha Allah x3
Insya Allah we’ll find the way