thanks veena. now its work. but a problem when i input a number in text box (and press a button) for show the report a msg show.
Run time error 2147217887(80040e21) [micorsoft][ODBC microsoft access driver] optional feature not implemented.
i write code in the button: Load DataEnvironment2 With DataEnvironment2 If .rsCommand1.State <> 0 Then .rsCommand1.Close .Command1 Text2.Text End With DataReport2.Show
SELECT * FROM incomereport WHERE AccountinfoDate AND IncomeDate BETWEEN ? AND ?
1st I write this code and it work after I write for other
SELECT Student ID, Student Name, Jamat Name, Feeding Charge, Exam Fee, Roll No, Jamat Fee, Others Fee, AccountinfoDate, Father 's Name,Category,Contact No,Address,Admission Date From stdreport Where Student ID ? this code not work.
sorry dear I faced a few problem 1. here you gather 6 field in the query by 3 field. but i want the query have both 6 field of both table I write code like you but it show a msg like "The number of colums in two selected tables or queries of a union query do not match" I dont understand what I need to do. please help me.
please check this. here in form2 I add any data by textbox and addnew button. when I close this form2 I want this new data show in flexgrid (form1) without click refresh button.
>>for 1st error Private Sub chameleonButton1_Click(Index As Integer) Adodc1.Recordset.AddNew End Sub
>>for 2nd error Private Sub chameleonButton11_Click(Index As Integer) Load DataEnvironment1 With DataEnvironment1 If .rsCommand1.State <> 0 Then .rsCommand1.Close .Command1 Format(DTFr.Value, "dd-mm-yyyy"), Format(DTTo.Value, "dd-mm-yyyy") End With DataReport1.Show End Sub
thanks dear but not like it. I mean I input a data in a from by text box and then close this form. after close I run a another form where a datagird contained. I want that data show in this datagrid.
how you connect your project with database file. by adodc control? or code? if adodc or other control then it easy. select data grid and then select data source properties and select adodc1 or other. how you connect it?
I didn't write any code. I put a data control. ms flexgrid connect with data control by properties. like data source = data1 another was datagrid. it also select by properties. i write sql like select * from table1
I write like you but no field show but parametre was shown. If i write only this select * from table1 then show all fields. but when I write your past code it was worked.
Dear veena I have a problem. I write code in sql like select * from table1 so all field show. help me what I write for particular field. I write.... select Student name from table1 what I write? some time parametre not show.
I made a database project. when I run it another pc and press the Add New button (in my project) it show this msg. Run time error - 91 Object variable or with block variable not set. I connect the backend database by data sources(ODBC)> system DSN. I write code in Add New button, "adodc1.recordset.addnew" anybody help me.
another error: when I select a date from dtpicker and then press a button for show report then show this error. run-time error 713 Application-defined or object-defined error
I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like name | address | date this 3 fields in table1 Roll | Class | date this 3 fields in table2 name | date | roll | date this 4 fields in querie1 now this data show in querie1 like Taher | 17/11/2008 | 100 | 16/11/2008 but I want it show in two row with sort by date like: Taher | 17/11/2008 100 | 16/11/2008 how can I do this
I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like name | address | date this 3 fields in table1 Roll | Class | date this 3 fields in table2 name | date | roll | date this 4 fields in querie1 now this data show in querie1 like Taher | 17/11/2008 | 100 | 16/11/2008 but I want it show in two row with sort by date like: Taher | 17/11/2008 100 | 16/11/2008 how can I do this
I try it many way but I coud'nt. I connect my database with properties of adodc control. and write in recodesource like this code select * from table1 so please tell me where I write code i mean whice form and what code. please
thanks veena its work well. but I have a few question. 1. Set these properties for both Parameters: DataType = adDBDate HostDataType =Date (VT_Date) if I want to search number then what i need to change? if need to search name or string then....? please help me with this question.
Augxis you code do well. thank you. dear veena >>Change Captions accordingly.. Remove Check Box with Index=0.. this line I don't understand. >>Note : all CheckBoxes will be having same Event Procedure.... there are no other checbox. only show check1
