UPPER Case MS Access

Private Sub DHM_AfterUpdate()
' Semua Huruf Jadi Besar
Me!DHM = StrConv(Me!DHM, vbUpperCase)
End Sub

Mengira Umur Mengguna No IC menggunakan MS Access

=DateDiff("yyyy", [TarikhLahir], Date())

expr1: Mid$([textdate],2,6)

expr2: DateSerial(Left([expr1],2),Mid([expr1],3,2),Right([expr1],2))

expr3: Format([expr2],"yyyy\.mm\.dd")

Melayu to Jawi

http://www.kauthar.net/e-jawi-transliterasi/

Excel - MID Function - Mengeluarkan Huruf Terpilih Dalam Cell Excel

DESCRIPTION

The Microsoft Excel MID function extracts a substring from a string (starting at any position).

SYNTAX

The syntax for the Microsoft Excel MID function is:

MID( text, start_position, number_of_characters )

PARAMETERS OR ARGUMENTS

text is the string that you wish to extract from.
start_position indicates the position in the string that you will begin extracting from. The first position in the string is 1.
number_of_characters indicates the number of characters that you wish to extract.

Membina Kuiz menggunakan Proprofs dan PDF Flipsnack

Layari http://www.proprofs.com/quiz-school/

http://www.flipsnack.com/

DLookup MsAccess

Getting a value from a table: DLookup()

Sooner or later, you will need to retrieve a value stored in a table. If you regularly make write invoices to companies, you will have a Company table that contains all the company's details including a CompanyID field, and aContract table that stores just the CompanyID to look up those details. Sometimes you can base your form or report on a query that contains all the additional tables. Other times, DLookup() will be a life-saver.

DLookup() expects you to give it three things inside the brackets. Think of them as:

   Look up the _____ field, from the _____ table, where the record is _____

Each of these must go in quotes, separated by commas.

You must also use square brackets around the table or field names if the names contain odd characters (spaces, #, etc) or start with a number.

This is probably easiest to follow with some examples:

1. you have a CompanyID such as 874, and want to print the company name on a report;
2. you have Category such as "C", and need to show what this category means.
3. you have StudentID such as "JoneFr", and need the student?s full name on a form.

Example 1:

Look up the CompanyName field from table Company, where CompanyID = 874. This translates to:

   =DLookup("CompanyName", "Company", "CompanyID = 874")

You don't want Company 874 printed for every record! Use an ampersand (&) to concatenate the current value in the CompanyID field of your report to the "Company = " criteria:

   =DLookup("CompanyName", "Company", "CompanyID = " & [CompanyID])

If the CompanyID is null (as it might be at a new record), the 3rd agumenent will be incomplete, so the entire expression yields #Error. To avoid that use Nz() to supply a value for when the field is null:

   =DLookup("CompanyName", "Company", "CompanyID = " & Nz([CompanyID],0))

Example 2:

The example above is correct if CompanyID is a number. But if the field is text, Access expects quote marks around it. In our second example, we look up the CategoryName field in table Cat, where Category = 'C'. This means the DLookup becomes:

   =DLookup("CategoryName", "Cat", "Category = 'C'")

Single quotes within the double quotes is one way to do quotes within quotes. But again, we don't want Categoy 'C' for all records: we need the current value from our Category field patched into the quote. To do this, we close the quotation after the first single quote, add the contents of Category, and then add the trailing single quote. This becomes:

   =DLookup("CategoryName", "Cat", "Category = '" & [Category] & "'")

Example 3:

In our third example, we need the full name from a Student table. But the student table has the name split into FirstName and Surname fields, so we need to refer to them both and add a space between. To show this information on your form, add a textbox with ControlSource:

   =DLookup("[FirstName] & ' ' & [Surname]", "Student", "StudentID = '" & [StudentID] & "'")

Quotes inside quotes

Now you know how to supply the 3 parts for DLookup(), you are using quotes inside quotes. The single quote character fails if the text contains an apostrophe, so it is better to use the double-quote character. But you must double-up the double-quote character when it is inside quotes.

See Quotation marks within quotes for details.

ELookup()

If you are interested in an extended DLookup() that operates faster, handles nulls correctly, and lets you to specify which of several possible matches you want returned, see: ELookup(). Suits Access 95 and later.

Merging Many .VCF Files In One File & Convert To CSV

Merging Many .VCF Files In One File & Convert To CSV

Phonebook or a contact information is the most important part of every mobile user. Most of us have forgotten to keep a written backup of any mobile number and when we do not have our mobile along, we are helpless. This is also true when you want to change mobile phone or want to transfer complete mobile contact information or phone book. 
These are the days of faster upgrade of mobile devices and we are changing mobile handsets more frequently. now when you want to transfer your contact numbers from old mobile to new one, there are many problems we come across, like different mobile manufacturing companies use different file formats, different type of backups and various computer sync software. 

Most of the mobiles do have an option to backup your mobile phonebook but they all save the backup file in a proprietary format. Eg. Nokia saves a backup file in .nbf format. You can use that backup file only for other Nokia mobile. (Read How to extract and Read Nokia Backup File like .nbf and .noki) But if you have changed the handset manufacturer this phonebook backup does not come to your help and you have to transfer all these addresses manually. 

The other way is to save all your phone-book as a vcf file. All the phones have this function but the problem is each and every entry is saved as a separate file. So if you have say 500 contacts, there will be 500 .vcf files. 

VCF

This is the most commonly used contact format. It's called "Visiting Card File / format". You will find this type of contact files when you try to backup your entire contacts from your mobile to memory card. Your mobile will save every contact in one .vcf file. If you want to transfer all your contact from mobile to any other software you have to manually transfer each and every file. So What is the solution to transfer all these contacts at once?

Yes - you need to concatenate or merge all the VCFs into a single file 

1. If you're using windows: 

GOTO Command prompt. (Windows_Key + R)

Run: cmd

2. Change to the directory where all your VCFs are stored

            d:

     cd   \my_vcfs

3. Run this command

                  
copy   /B   *.vcf   all_in_one.vcf

Then just upload the "all_in_one.vcf" file to your software and it will grab all your contacts in one go

CSV

CSC is the most commonly used data management format. Its Comma Separated Value file. You can use simple office excel to edit the file.

Convert .vcf File into .CSV file easily.

Just go here LINK

http://labs.brotherli.ch/vcfconvert/

pastu upload ke dalam contacts google lah.