Wednesday, October 31, 2007

Miscellaneous Tips

Visual Basic
1. project level variable
#if database =1 then
Msgbox “project level variable”
#end if

# means project level variable

2 vb error recordset.close error operation not allowed in this context it can be because
You’re trying to close the recordset with a pending transaction on it. Like
Updates or Addnew. Review your code if it has a pending transaction then try to finish it first then close the recordset.


HTML
1.
If there is margin in your page then margin can be set to zero by following
Property of body tag
','< %=gfmm %>','< %=gfyy %>')">

2. if there is margin in any cell then use


Crystal Reports
1. iif({prc_RPT_InTransit;1.t_Received}=1,'Y','N') if condition in crystal report

Photoshop
1.to move an image select it , and move it using move tool , which is at right top most on the tool box

Excel
1. round (number, digit) rounds the number , upto specified digits

No comments: