Sub FindBullet()
Dim rngTarget As Word.Range
Dim oPara As Word.Paragraph
Set rngTarget = Selection.Range
With rngTarget
Call .Collapse(wdCollapseEnd).End = ActiveDocument.Range.End
For Each oPara In .Paragraphs
If oPara.Range.ListFormat.ListType = _ WdListType.wdListBullet Then
oPara.Range.Select
'Selection.Delete Unit:=wdCharacter, Count:=1
'Exit For
End If
Next
End With
End Sub
Thursday, November 22, 2007
Friday, November 16, 2007
Formating currency
With decimals
[>=10000000]#\,##\,##\,##0.00;[>=100000]#\,##\,##0.00;##,##0.0
Without decimals
[>=10000000]#\,##\,##\,##;[>=100000]#\,##\,##;#,###
[>=10000000]#\,##\,##\,##0.00;[>=100000]#\,##\,##0.00;##,##0.0
Without decimals
[>=10000000]#\,##\,##\,##;[>=100000]#\,##\,##;#,###
Monday, November 5, 2007
Displaying Crystal Report in VB6.0
Dim Report As New CrystalReport1
Public CrxApplication As New CRAXDRT.Application
Public CrxReport As New CRAXDRT.Report
Public CrxPara As New CRAXDRT.ParameterValues
Dim cpars As CRAXDRT.ParameterFieldDefinitions
Dim cpar As CRAXDRT.ParameterFieldDefinition
Private Sub Form_Activate()
Set CrxReport = CrxApplication.OpenReport(App.Path & "\payslip.rpt", 0)
CrxReport.Database.LogOnServer "p2ssql.dll", "server", "db", "userid", "Password"
CrxReport.Database.Tables(1).ConnectionProperties.Item("password") = "Password"
CrxReport.ParameterFields.GetItemByName("@employeeid").AddCurrentValue CStr(frmpayslip.str)
CrxReport.ParameterFields.GetItemByName("@month").AddCurrentValue CInt(frmpayslip.cmbMonth.ItemData(frmpayslip.cmbMonth.ListIndex))
CrxReport.ParameterFields.GetItemByName("@year").AddCurrentValue CInt(frmpayslip.cmbYear.Text)
Crppayslipdata.ReportSource = CrxReport
Crppayslipdata.ViewReport
Crppayslipdata.Visible = True
CrxReport.EnableParameterPrompting = True
End Sub
Public CrxApplication As New CRAXDRT.Application
Public CrxReport As New CRAXDRT.Report
Public CrxPara As New CRAXDRT.ParameterValues
Dim cpars As CRAXDRT.ParameterFieldDefinitions
Dim cpar As CRAXDRT.ParameterFieldDefinition
Private Sub Form_Activate()
Set CrxReport = CrxApplication.OpenReport(App.Path & "\payslip.rpt", 0)
CrxReport.Database.LogOnServer "p2ssql.dll", "server", "db", "userid", "Password"
CrxReport.Database.Tables(1).ConnectionProperties.Item("password") = "Password"
CrxReport.ParameterFields.GetItemByName("@employeeid").AddCurrentValue CStr(frmpayslip.str)
CrxReport.ParameterFields.GetItemByName("@month").AddCurrentValue CInt(frmpayslip.cmbMonth.ItemData(frmpayslip.cmbMonth.ListIndex))
CrxReport.ParameterFields.GetItemByName("@year").AddCurrentValue CInt(frmpayslip.cmbYear.Text)
Crppayslipdata.ReportSource = CrxReport
Crppayslipdata.ViewReport
Crppayslipdata.Visible = True
CrxReport.EnableParameterPrompting = True
End Sub
Subscribe to:
Posts (Atom)