gerchi152

My process is to multiply the given points in B8, D8, F8, H8, J8, L8, and N8 to A3, B3, C3, D3, E3, F3, G3 respectively. this procedure is to be processed in C8, E8, G8, I8, K8, M8, and O8. after multiplying, the process should perform =sum(C8,E8,G8,I8,K8,M8,O8) to P8. …

I'm getting this error variable might not have been initialized on ch2 and ch3: [CODE]import javax.swing.JOptionPane; public class calculatorJava { public static void main(String[] args) { String ch, ch2, ch3, add1, add2, sub1, sub2, mul1, mul2, div1, div2, choice1, exp; int chans, chans2, chans3, addo1, addo2, subO1, subO2, mulo1, mulo2, …

will someone help me on how to solve this error? The database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF'. …

try to group the field that shows 4 times instead of one... right click the report then report>group expert then select the field you want to show once...

how can I solve this kind of error: "a number, currency amount, boolean, date, time, date-time, or string is expected here" here is my code: [CODE]Dim oDoc As New ReportDocument oDoc.Load("D:\updated 2-21-cla-12-57\WAIS SYSTEM\WAIS SYSTEM\GUIDANCE-dropRpt.rpt") Dim myDS As New DataSet oDoc.SetDataSource(myDS.Tables("drop_student")) Select Case GUIREP_drop.Search.SelectedItem Case "Date" strsql = "{drop_student.date_drop} = '" …

I'm using this code in my form load event... [CODE]Dim crptdoc As New ReportDocument crptdoc.Load("path where your rpt file is") Dim myDS As New DataSet crptdoc.SetDataSource(myDS.Tables("soruce table name")) Dim mystr As String mystr = "{tablename.EmployeeID} = '" & textboxA.text & "' and {tablename.PayrollNumber} = '" & textboxB.text & "'" CrystalReportViewer1.SelectionFormula …

what is the syntax for blank list view object... for example: [CODE]if classlistview is blank then <statement> else <statement> end if[/CODE] what is the syntax for classlistview is blank? as in no record(s) were retrieved... any help is appreciated... thanks :)

my report show this way: surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 2 firstname2 middlename2 surname 2 firstname2 middlename2 i want to display my those records this way surname 1 firstname1 middlename1 surname 2 firstname2 middlename2 …

I have this code in my form (in load event) wherein there is a crystal report viewer: [CODE]Dim oDoc As New ReportDocument oDoc.Load("D:\grading_report\grading_report\teacherLoad.rpt") Dim myDS As New DataSet oDoc.SetDataSource(myDS.Tables("grading_teacherload")) Dim mystr As String mystr = "{grading_teacherload.teacherid} = " & teacherLoadListView.teacherid & "" CrystalReportViewer1.SelectionFormula = mystr CrystalReportViewer1.ReportSource = oDoc[/CODE] there is …

I have 3 columns in my database (book title, book author, date added). for example Karen Harper has 5 books in my database and Lisa Jackson has 3. I will enter the date added in a textbox (for example 01-15-2011 since all was added on that date) and once I …

I want to delete selected column values only... I have this statement: [ICODE]strsql = "delete book1, author1, from book_Load where Book_ID_no = '" & bkIDnum.Text & "'" With sqlcmd .CommandText = strsql .Connection = sqlconn .ExecuteNonQuery() End With[/ICODE] the error is "Incorrect syntax near ','." please help me with this... …

in my combo box, I checked use data bound items and I think I properly set the necessary things... also I have retrieve button that has this statement [CODE]strsql = "select * from books where title='" & cmbTtle.SelectedValue & "'"[/CODE] and the error is type character '&' does not match …

Hi! I have this code in my program [CODE]sqlstat= "select bookNum from booktitle" sqlstat2="select bookNum, bookName from booklist where bookNum not in " & sqlstat & "and bookAuthor like '" ListBook.SelectedItem & "'"[/CODE] but it has "Incorrect syntax near the keyword 'and'" error... please help me with this... response is …

Hello! can you give me some ideas on how I can make the field values to field names?

Hi!!! I'm having hard time in manipulating a combo box with list view. For example if the selected index in the combo box is "boy" then the list view will display a database table allotted for boys and if the selected index is "girl" then the list view will display …