Click here to Skip to main content
16,005,236 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionToolstripcomboBox Pin
Socheat.Net7-Oct-06 16:34
Socheat.Net7-Oct-06 16:34 
AnswerRe: ToolstripcomboBox Pin
nlindley77-Oct-06 18:21
nlindley77-Oct-06 18:21 
GeneralRe: ToolstripcomboBox Pin
Socheat.Net10-Oct-06 17:45
Socheat.Net10-Oct-06 17:45 
QuestionVB Cleanup Program - In (Context Menu) SendTo Pin
RickMagenta7-Oct-06 6:52
RickMagenta7-Oct-06 6:52 
AnswerRe: VB Cleanup Program - In (Context Menu) SendTo Pin
Ray Cassick7-Oct-06 16:13
Ray Cassick7-Oct-06 16:13 
GeneralRe: VB Cleanup Program - In (Context Menu) SendTo Pin
RickMagenta8-Oct-06 0:12
RickMagenta8-Oct-06 0:12 
Questionhow to make a layout designer in crystal report without using wizard Pin
vidyashankar7-Oct-06 4:58
vidyashankar7-Oct-06 4:58 
QuestionHow to solve it? Pin
aloksingh20067-Oct-06 2:07
aloksingh20067-Oct-06 2:07 
I m generating a crystal report in vb. and an error is coming. Please help me how to solve it?

Dim mystrpur As String

mystrpur = "SELECT IPurMast.`Date`, IPurMast.`Party`, IPurMast.`Amt`, " & _
"IPurTran.`Item`, IPurTran.`NetQty`, IPurTran.`Rate`, IPurTran.`Amt` " & _
" From `IPurMast` IPurMast INNER JOIN `IPurTran` IPurTran ON IPurMast.`Amt` = IPurTran.`Amt` AND IPurMast.`PurNo` = IPurTran.`PurNo` where IPurMast.`Party` = '" & txtParty.Text & "' AND IPurMast.`Date`>= #" & DTPickerS.Value & "# AND IPurMast.`Date`<= #" & DTPickerE.Value & "# "

CrystalReport1.SQLQuery = mystrpur
CrystalReport1.Formulas(0) = "Bill_no = '" & txtBill.Text & "' "
CrystalReport1.Formulas(1) = "Start_dt = '" & DTPickerS.Value & "' "
CrystalReport1.Formulas(2) = "End_dt = '" & DTPickerE.Value & "' "
CrystalReport1.Formulas(3) = "Party_name = '" & txtParty.Text & "' "

CrystalReport1.ReportFileName = "c:\PurReport.rpt"
CrystalReport1.Action = 1 '****Error is in this line
CrystalReport1.WindowWidth = 100

'Erro is *****
error run time error '20599'
can't open sql server

With Regards
Alok Singh

AnswerRe: How to solve it? Pin
User 17164927-Oct-06 2:39
professionalUser 17164927-Oct-06 2:39 
QuestionBadly need help to fill a picturebox with an ole picture from access Pin
belowzero7-Oct-06 0:28
belowzero7-Oct-06 0:28 
QuestionControl Collections Pin
Peter Stanford6-Oct-06 23:45
Peter Stanford6-Oct-06 23:45 
AnswerRe: Control Collections Pin
Christian Graus7-Oct-06 0:09
protectorChristian Graus7-Oct-06 0:09 
GeneralRe: Control Collections Pin
Peter Stanford7-Oct-06 1:43
Peter Stanford7-Oct-06 1:43 
GeneralRe: Control Collections Pin
Christian Graus7-Oct-06 12:19
protectorChristian Graus7-Oct-06 12:19 
GeneralRe: Control Collections Pin
Peter Stanford7-Oct-06 19:02
Peter Stanford7-Oct-06 19:02 
GeneralRe: Control Collections Pin
Peter Stanford7-Oct-06 19:03
Peter Stanford7-Oct-06 19:03 
QuestionHow to monitor microphone input level? Pin
re infecta6-Oct-06 21:46
re infecta6-Oct-06 21:46 
Question,net and XML question Pin
ranro20066-Oct-06 20:04
ranro20066-Oct-06 20:04 
AnswerRe: ,net and XML question Pin
Christian Graus6-Oct-06 23:36
protectorChristian Graus6-Oct-06 23:36 
QuestionDatareports Pin
Chira Chandra6-Oct-06 19:47
Chira Chandra6-Oct-06 19:47 
QuestionFTP using WININET.DLL Pin
leezardd6-Oct-06 13:13
leezardd6-Oct-06 13:13 
AnswerRe: FTP using WININET.DLL Pin
Tad McClellan8-Oct-06 3:42
professionalTad McClellan8-Oct-06 3:42 
QuestionPDF reader [modified] Pin
alexfromto6-Oct-06 10:04
alexfromto6-Oct-06 10:04 
AnswerRe: PDF reader Pin
Christian Graus6-Oct-06 23:40
protectorChristian Graus6-Oct-06 23:40 
GeneralRe: PDF reader Pin
alexfromto10-Oct-06 2:52
alexfromto10-Oct-06 2:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.