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

How to check for MDAC version

To check the registry, follow these steps:
1.On the Start menu, click Run.
2.In the Open text box, type regedit and then click OK; this starts Registry Editor.
3.In the Navigation pane, drill-down to the following path:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess
4.In the Details pane, look in the Name column for FullInstallVer and Version. Each of these keys will have corresponding version information in the Data column.
5.When finished, click Exit on the Registry menu to close Registry Editor.