Cyberiafreak

"Fortunate are those who take the first steps.” ― Paulo Coelho

My code in office – for reference

‘// FOR SALESMEET REPORT
Private Sub clt_Click()
If scope2 = "" Then
MsgBox "Select scope of the report !! ", vbExclamation, " Sales port !!"
Else
If scope2 = "B" Then
If code = "" Then
MsgBox "Please select any branch….! ", vbInformation, "Salesport!!……….Select branch… "
Else
wb.Navigate salesurl & "sales_pcl_rep_index2.asp?st=1&ac=SM&scope=" & scope & code ‘ querystring
wb.Visible = True
End If
End If

End If
End Sub

————————-
case "R"
act="sales_wo_rep.aspx"
rs.Open "select *from WORECIEPT where " & condition & " and (datepart(month,WOR_REC_DT)=datepart(month,getdate()) or datepart(month,WOR_REC_DT)=datepart(month,dateadd(month,-1,getdate())))"
head="WORK ORDER RECEIPT- LISTING REGION LEVEL "
case "A"
act="sales_wo_rep.aspx"
rs.Open "select *from WORECIEPT where datepart(month,WOR_REC_DT)=datepart(month,getdate()) or datepart(month,WOR_REC_DT)=datepart(month,dateadd(month,-1,getdate()))"
head="WORK ORDER RECEIPT – LISTING INDIA LEVEL"

—– Today lot of updation in existing salesport application. Successfully cleared 3 errors.

3-2-2005 went to dumlur for BDOTNET Seminar [ topic was asp.net caching ]

Advertisements

February 5, 2005 - Posted by | Computers and Internet

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: