Sunday, 20 January 2013
Samsung Galaxy S3 Useful Codes to Test Your Handset Hardware
*#1234# (View SW Version PDA, CSC, MODEM)
*#0*# (General Test Mode)
*#12580369# (SW & HW Info)
*#197328640# (Service Mode)
*#0228# (ADC Reading)
*#32489# (Ciphering Info)
*#232337# (Bluetooth Address)
*#232331# (Bluetooth Test Mode)
*#232338# (WLAN MAC Address)
*#232339# (WLAN Test Mode)
*#0842# (Vibra Motor Test Mode)
*#0782# (Real Time Clock Test)
*#0673# (Audio Test Mode)
*#2263# (RF Band Selection)
*#9090# (Diagnostic ConfiguratioN)
*#7284# (USB I2C Mode Control)
*#872564# (USB Logging Control)
*#4238378# (GCF Configuration)
*#0283# (Audio Loopback Control)
*#1575# (GPS Control Menu)
*#3214789650# (LBS Test Mode)
*#745# (RIL Dump Menu)
*#746# (Debug Dump Menu)
*#9900# (System Dump Mode)
*#44336# (Sofware Version Info)
*#7780# (Factory Reset)
*27673855# (Full Factory Reset)
*#0289# (Melody Test Mode)
*#2663# (TSP / TSK firmware update)
*#03# (NAND Flash S/N)
*#0589# (Light Sensor Test Mode)
*#0588# (Proximity Sensor Test Mode)
*#2732832553282*# (Data Create Menu)
*#273283255663282*# (Data Create SD Card)
*#3282727336*# (Data Usage Status)
*#7594# (Remap Shutdown to End Call TSK)
*#34971539# (Camera Firmware Update)
*#526# (WLAN Engineering Mode)
*#528# (WLAN Engineering Mode)
*#7412365# (Camera Firmware Menu)
*#80# (Unknown)
*#07# (Test History)
*#3214789# (GCF Mode Status)
*#272886# (Auto Answer Selection)
*#8736364# (OTA Update Menu)
*#301279# (HSDPA/HSUPA Control Menu)
*#7353# (Quick Test Menu)
*27674387264636# (Sellout SMS / PCODE view)
*#7465625# (View Phone Lock Status)
*7465625638*# (Configure Network Lock MCC/MNC)
#7465625638*# (Insert Network Lock Keycode)
*7465625782*# (Configure Network Lock NSP)
#7465625782*# (Insert Partitial Network Lock Keycode)
*746562577*# (Insert Network Lock Keycode SP)
#746562577*# (Insert Operator Lock Keycode)
*746562527*# (Insert Network Lock Keycode NSP/CP)
#746562527*# (Insert Content Provider Keycode)
*#272imei#* Product code
Among all those 58 key codes, there is one which is very important for every new owners of SGS3. That key is *#0*# which is a general test to find out basic current state of phone’s LCD. We knew that LCD is the most important aspect of a touch-based smartphone. Anyway, just give it a try..
Thursday, 17 January 2013
How To Transfer Word Form Data to an Excel Spreadsheet
Takeaway: When you need to transfer a data record to Excel, a Word form — and a little VBA — makes the process a snap.
Analyze your needs
- The data you’re transferring
- The source file that contains the data
- The destination file to which you’re transferring the data
- The transfer medium used to make the switch; usually, it’s code
Determine the destination format
Figure A
Our example sheet is simple on purpose. Transferring the data is the job; the number of fields is usually irrelevant.
Identify the destination data types
Note the destination file’s location
Create the source form
Figure B
Use Word’s form fields to collect data.
- Click the Developer tab and then choose the ab field from the Legacy Tools drop-down in the Controls group (circled in Figure B). In Word 2003, choose Toolbars from the View menu and select Forms, where you’ll find the Text Form Field control.
- Click Properties in the Controls group or double-click the field to display its properties.
- Enter txtCompanyName in the Bookmark property, as shown in Figure C.
- Click OK.
- Repeat steps 1 through 4, entering txtPhone in step 3.
- Save the form.
Figure C
The text form field is a legacy tool in the Ribbon versions.
Add the basic code
- With the Word form open, press [Alt]+[F11] to launch the Visual Basic Editor (VBE).
- From the Insert menu, choose Module.
- Enter the code in Listing A.
- Save the module and return to the Word form.
Listing A: The transferring macro
Sub TransferToExcel()
'Transfer a single record from the form fields to an Excel workbook.
Dim doc As Document
Dim strCompanyName As String
Dim strPhone As String
Dim strSQL As String
Dim cnn As ADODB.Connection
'Get data.
Set doc = ThisDocument
On Error GoTo ErrHandler
strCompanyName = Chr(39) & doc.FormFields("txtCompanyName").Result & Chr(39)
strPhone = Chr(39) & doc.FormFields("txtPhone").Result & Chr(39)
'Define sql string used to insert each record in the destination workbook.
'Don't omit the $ in the sheet identifier.
strSQL = "INSERT INTO [PhoneList$]" _
& " (CompanyName, Phone)" _
& " VALUES (" _
& strCompanyName & ", " _
& strPhone _
& ")"
Debug.Print strSQL
'Define connection string and open connection to destination workbook file.
Set cnn = New ADODB.Connection
With cnn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "Data Source=E:\Examples\Sales.xlsx;" & _
"Extended Properties=Excel 8.0;"
.Open
'Transfer data.
.Execute strSQL
End With
Set doc = Nothing
Set cnn = Nothing
Exit Sub
ErrHandler:
MsgBox Err.Number & ": " & Err.Description, _
vbOKOnly, "Error"
On Error GoTo 0
On Error Resume Next
cnn.Close
Set doc = Nothing
Set cnn = Nothing
End Sub
Add a way to execute the macro
- Double-click the phone field (txtPhone) to open its property sheet.
- From the Exit drop-down, select the transfer macro from Listing A, TransferToExcel, as shown in Figure D.
- Click OK.
Figure D
Select the transfer macro from the Exit drop-down.
Protect the Word document
- Click the Developer tab and then click Restrict Editing in the Protect group. In Word 2003, click Protect on the Form toolbar.
- In the resulting task pane, click Allow Only This Type Of Editing In This Document.
- From the drop-down, select Filling In Forms, as shown in Figure E.
- Click Yes, Start Enforcing Protection.
- Enter a password twice. Or leave both password entries blank if you don’t need password protection.
- Click OK.
Figure E
Enable protection to restrict data entry to the form fields.
Use the form
Figure F
Using form fields to collect data is easy.
Figure G
Our macro code copied the data from the Word form to an Excel sheet.
The rest of the story
Just Hit The Share Button It Doesn't Bite Your Finger
Subscribe to:
Posts (Atom)
-
Working with Groups of Worksheets Grouping your worksheets can help improve consistency and save time. Once sheets are grouped, you can...
-
A mobile phone is a wireless electronic device used for telephone and multimedia communications. The term "mobile phone" does n...
-
Challenge: The customer – a Fortune 500 organization, who is in the business of theme parks, with thousands of acres of plants, g...