હિમાંશુ પરભુભાઇ મિસ્ત્રી | Himanshu Mistry

જુલાઇ 5, 2012

Step by Step Guide for Aircel GPRS settings on PC

Filed under: GPRS settings,how to,Internet,Useful Links,web-technology — Himanshubhai Mistry @ 12:27 પી એમ(pm)

Step by Step Guide for Aircel GPRS settings on PC

I recently tried AIRCEL GPRS on my PC.

didn’t get any information from the Customer Care. But Google is the best friend ….

I got extensive information form below website:

 http://guideocom.blogspot.in/2011/08/how-to-connect-aircel-gprs-to-pc.html

followed the steps given in it.

How to connect Aircel GPRS to PC (Windows 7) via Bluetooth modem or mobile phone

Get connection:

Step 01: Send a request through an SMS (Send <GPRS>to 121) or call the customer care (121).

Get the settings:

Step 02: After the request they will send u the settings within 24 hours.

Activation:

Step 03: Now e-recharge with Rs 14(three days) or Rs: 98(30 days) .If you have balance, you can activate this service by sending SMS<P14> or <P98> to 57788 .This is a toll free number.

Connecting to Pc :

Step 04: Switch on Bluetooth in your phone and PC.

Step 05: In PC select Phone and Modem in Control Panel and select modems tab.

Step 06: Select Standard Modem over Bluetooth link and click Properties.

Step 07: In Generals tab click Change Settings

Step 08: Click Diagnostics tab and then Query Modem to check whether the modem is working properly.

Step 09: In Advanced tab type the following as Extra initialization command:
If yours is prepaid: AT+CGDCONT=1,”IP”,”aircelgprs.pr”
above did’t work so I changed
from
“aircelgprs.pr”  to “aircelgprs”
For post paid: AT+CGDCONT=1,”IP”,”aircelgprs.po”
And then press OK.

Step 10: Open Network and Sharing Center
Click Set up a new connection or network

Step 11: Select Set up a dial up connection and then press Next.

Step 12: Select Standard Modem over Bluetooth link

Step 13: If Aircel GPRS is the default profile type *99# in the Dial-up phone number box  and then press Connect.
If it doesn’t work try the following one after the other:

*99***1#

*99***2#

*99***3#

*99***4# and so on

1,2,3,4 is nothing but the order of Aircel
GPRS profile in your phone’s GPRS account.

 

 

મે 5, 2011

Change the Look-and-Feel (Design) of Lotus Notes 8.5

Filed under: how to,learning,Useful Links — Himanshubhai Mistry @ 2:53 પી એમ(pm)

I upgraded Lotus Notes from 7.5 to 8.5 using ISSI.

Even after upgrading to 8.5, the look-n-feel was quite similar to 7.5.. the advanced option didn’t get applied. especially the menu and online/offline status of Sametime contacts in the “To and CC” lists..

I had been searching on web for “change look and feel of lotus 8.5″… later on I got the correct keywords — that is “change design of lotus 8.5” and got some help in below given link.

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.notes85.help.doc/app_replace_design_t.html

Let’s try with the help give above and see.. else the ITHelpDesk is always there.

જુલાઇ 22, 2009

deleting all non-exclude X ALL lines in ISPF

Filed under: how to,learning,mainframe — Himanshubhai Mistry @ 6:24 પી એમ(pm)

How to delete all Un-Excluded Lines in ISPF

Generally you would have used :
x all; find all <criteria>; del x all

It deletes all lines you have excluded (and don’t need any more) in your dataset.

Here we have different scenario:

We want to exclude all lines that meets a <criteria> and then delete all lines that don’t meet the <criteria> …

steps :

[1] x all <criteria>

It will exclude all lines having the <criteria>

Now read carefully

Now you want to delete all visible lines and keep all excluded lines (which meets your <criteria>)…………..

and unwanted lines are now visible to you.

you want to delete these all visible (unwanted) lines.

the command you have to issue is :

[2] del all nx

it will keep all excluded lines and delete all visible lines.

You will see all the lines are excluded in your dataset,

Just issue reset command and view the result..

Got it ??? !!!!

એપ્રિલ 23, 2009

How to save pictures from orkut album

Filed under: how to — Himanshubhai Mistry @ 4:24 પી એમ(pm)

Orkut has disabled the right-click feature on the photo album pages.

As a result you are currently being unable to download photos from friend’s orkut album.

If you try Right Click >> Save Picture As………………. Sorry to say it won’t work.

You can’t save your friend’s picture on your computer….. 

But a very simple trick is available:

Logon to Orkut. Open your friend’s album. Choose the photo you like the most.

Resize the browser window in such a way that it will not occupy full screen of your monitor, still you are able to see a part of your friend’s photo.

 Drag that photo to your desktop’s empty area.

The photo will be saved on your desktop.

You are saving 3  mouse click efforts !!!

Just count 

[1] Right click

[2] click on “save picture as”

[3] choose location (say desktop)

[4] click the “ok” or “save” button

Now your friend doesn’t need to send the same pitures attaching them into a mail.

જુલાઇ 30, 2008

How to lock a column/row/cell in MS Excel

Filed under: how to,Useful Links — Himanshubhai Mistry @ 9:31 પી એમ(pm)

How to Lock a column MS Excel

some time we need to lock a column from the end user protecting from accidental changes.

scenario:

   A           B 
1 data1      =fun(A1)
2 data2      =fun(A2)
3 data3      =fun(A3)

We want the user to allow key in data in column ‘A’
Function given in column ‘B’ will produce result and user will be able to view the result.
we don’t want the user to select/edit the cells of column ‘B’

steps how to achieve this:
[1] Select the columns (or rows/cells) the user should be able to to TYPE data into.
[2] Format menu / Cells / protection tab
[3] Remove the tick-mark from ‘locked’
[4] Tools menu / protection / protect sheet and apply protection

You will find that you can only type data in the cells that you selected and then removed the ‘locked’ tick-mark from.

This is applicable for cells, columns or rows..

મે 23, 2008

One trick in MS OFFICE for Find and Replace

Filed under: how to,learning — Himanshubhai Mistry @ 9:48 પી એમ(pm)

 

One trick in MS OFFICE for Find and Replace

MS Office 2003 allows find and replacing dependent vowel symbols like hrswa i deergha ee hrswa u deergha oo etc.
I had discovered this trick at the time when I was doing all data corrections after converting the lexicon-data to Unicode.
For example if you want to convert a document typed in SARTH to UNZA…
You can replace all hrswa i to deergha ee as well as all deergha oo to hrswa u

We have to type the dependant i vowel symbol in a notepad and then copy and paste to find and replace window like shown below

find-and-replace-i

Then only the buttons (replace/replace all and find next) will be activated.
If you click replace all, it will replace all hrswa I with deergha ee…..
Similarly for hrswa u and deergha oo
See the picture below
find-and-replace-u.jpg

 all the best

નવેમ્બર 19, 2007

how to change-or-set default font in MS Word

Filed under: how to — Himanshubhai Mistry @ 11:50 એ એમ (am)
Tags: , , , , ,

तुण्डे तुण्डे मतिर्भिन्ना । (tunde tunde martirbhinna ) : —
Every one has their own choice(/mind-set/opinion/thought process).

“Times New Roman” is the default font in Microsoft word.

everyone may not like that font and they want to use another font each time they open msword for creating a new document.

Being a Gujarati, and habituated typing in Gujarati using Vijaya-Kalapi-Gurjari font on a PC; I would like to set “Vijaya” Font in MS Word.

steps:

  1. Open Microsoft word
  2. Click Tools menu >> Fonts
    It will open below shown window:how to change default font in MS Word
  3. Select font of your choice from “Font:”
  4. Then click on Default button given at bottom left corner

save that document and close ms word.

Now whenever you open ms word; your favourite font will be set for typing.

If you type documents in Multiple languages in Unicode encoding then You might want to set “Arial Unicode MS” font as default.. it supports almost all languages of the world.
at the same time your system becomes slow as the Arial Unicode font is around 21MB in size.

Please feel free to comment.

Blog at WordPress.com.