How To Create Search Form With Two Criteria In Microsoft Access With VB Code

Rujukan : Search Criteria/Dynamic Search Form


Dynamic search form means user can choose/enter a value between 2 boxes or choose only 1 box and leave other box null/empty. (A flexible search form provides several boxes where a user can enter criteria. An efficient search form creates the criteria from only those boxes where the user enters a value.
- by allenbrowne)




Step by step

1. Create a blank form

2. Under property sheet for ur empty form, select tableClient(your table/query) as a Record Source. This table/query will be ur data for ur form.

3. Under design view, add Id,Corporate,Companay name, City, Level fields.(Example field)



4. Then insert 6 textbox or combo box to be ur search box.(Type, Name Contains, City, Level, Entered Date) and 2 button for filter and unfilter function.(Can be search button and show all button)


5.  Then put code below under the On Click Event Producure on the property sheet for filter/search button.



link rujukan : http://www.iaccessworld.com/create-search-form-using-vba-ms-access/
&  http://allenbrowne.com/ser-62.html

PRINT A REPORT FROM A FORM MICROSOFT ACCESS WITH WHERE CONDITION

Table name : Personnel_details (name_id,personnel_name dob, position)
                   : Section ( name_id ,personnel_name, section)

Query name : section_query (position_name, position, section)

Form name : Form1


First, I create  a new blank form and create a combo box contains personnel name from personnel table. Then create command button named Report.

 After that  edit property sheet of the button. Choose menu event then choose macro builder for on click.  Add new action OpenReport. This action can restrict the records that are printed in the report by using Where Condition. Where conditions  is a valid SQL WHERE clause (without the word WHERE) or expression that Access uses to select records from the report's underlying table or query.

To open a report and restrict its records to those specified by the value of a control on a form, use the following expression :

[fieldname] = Forms![formname]![controlname on form]

Ex: [sectionquery]![personnelname] = Forms![Form1][Command0]

Insert data from datepicker in database using php

I'm using datepicker in my php form to my database..
credit to  : http://stackoverflow.com/a/32893854

Tutorial Php Project Using Wamp Server And Netbeans IDE

Honestly I just read and follow this 1 blog and I manage to use my netbeans with wamp server.

Credit to : https://hassoon3.wordpress.com/2011/12/18/developing-php-with-netbeans-7-0-1-and-wamp2-2-server/

Fatal error: Call to undefined function mb_detect_encoding() in C:\wamp\apps\phpmyadmin4.0.4\libraries\php-gettext\gettext.inc on line 177

I did follow too many post about this problem.. Finally I follow the following link :  http://stackoverflow.com/a/18694767  and able to open my phpmyadmin .. :)

How to fix the “api-ms-win-crt-runtime-l1-1.0.dll is missing” error when installing Apache Wen Server

Having this little problem when trying to install Apache on my new office PC.
What i do is, getting help from Mr. Google.

Credit to : http://blog.spreendigital.de/2015/09/01/how-to-fix-the-api-ms-win-crt-runtime-l1-1-0-dll-is-missing-error-for-delphi-10-seattle/  by Dennis D.Spreen

What i need to do is installing Visual C++ Redistributable for Visual Studio 2015 (32-bit)
 for Windows  32-bit

IIF Statement With Wildcard Condition In Access

Criteria :  All records where unit price is 0.99 or 1.99 or 2.99 or 3.99

Besides using the = operator in the expression for exact matches, we can also use other operators.
For example, for partial matches of text strings/numbers, we can use LIKE "*".

Credit to : http://www.access-programmers.co.uk/forums/showthread.php?p=471291#post471291


Example : Total2: IIf([Total] Like "*.99", True, False)


Criteria  : Multiple IIF in Access

Example : SWITCH (Criteria, TrueResult, Criteria2, TrueResult2, Criteria3, TrueResult3, Criteria4, TrueResult4)

 or by using Nested IIF

Example  : IIF( Criteria, TrueResult, IIF(Criteria, TrueResult, IIF(Criteria,
TrueResult, FalseResult)))
Credit to  : http://www.pcreview.co.uk/threads/multiple-if-else-in-ms-access.2789488/ 

Specifying Textual Criteria That Comes from a Field on a Form:

=DLookUp("[EMAIL]","penyelia","[NAMA PEGAWAI] = '" & [Forms]![borang]![NAMA PENYELIA] & "'")

Email – specific field

Penyelia – table

Nama penyelia – field yg berkaitan

Forms – berdasarkn borang

Borang – form name

Nama penyelia – field ygdiisi

=[nmPenyelia] & IIf(Nz([penyelia.EMAIL])<>""," [" & [penyelia.EMAIL] & "]")

TIMEDIFFERENCE IN ACCESS

Start time 01:10:53
Stop time 01:20:05
Duration IJAM, 40MINIT

USING DATEDIFF

EXAMPLE : Minutes: DateDiff("n",[STARTTIME],[STOPTIME])

DURATION: [Minutes]\60 & Format([Minutes] Mod 60,"""JAM,  ""00""MINIT""")

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.