No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
College Teacher in Govt. Degree College Tral kashmir(India)
- Interests
- dataBase programing with vb
16 Posted Topics
 | [B] I use vb with Access. I have 2 tables table1 & table2 i create a data report showing the data from table1. My aim is to display the data from table2 on the same report in its next page(s). any kind of help, suggestions will be highly appreciated. with …  |
| | U may use the following line ADODC1.RECORDSET!RESULT=a+b+c+d where adodc1 is the ado datacontrol to which grid1 is bound Bashir  |
| | U may use the following [CODE]adodc1.recordsource="select * from table1 where id=" & txtid & " and date=#" & txtdate & "#" adodc1.refresh if adodc1.recordset.recordcount>0 then adodc1.recordset.delete end if[/CODE] hope it will help |
| | sir U have two parameters and while preparing the dataebvironment, U have to use a statement like " select * from salary where date=? and unit=? and thenin the click event of a button u enter the code as follows: <code> dataenvironment.rssalary mydate,myunit </code> where mydate and myunit are the … |
| | Dear sir with my little experience of Vb I m pleased to inform U that the "str" is actually function and can not be used as U have done in line 3. Instead of str u can use any other word like st, srt, mystr etc... Surely this will help … |
| | the "formated table" is not clear to me. however, regaridn report on multiple tables, U prepare the required SQL statement and in the report, instead of a table, set the data from sql statement. hope it will help. |
| | i submitted a reply earlier but it is not seen here. let me again do. open the database and under users option add as many users as u want and assign permissions . then in connection string u can use any user other name admin. |
| | dear Mr. khalid assalamu alikum U need to create a setup program using package & deployment wizard of VB and then install it on other computer. hope it will help U Bashir Ahmad  |
| | [B]sir I design a small application in vb (Windows-xp system) which displays the records from the sql database tables. Entering a table name in the text box and clicking the Button, its records are displayed in the data grid. The code for the button is[CODE]adodc1.recordsource="select * from " & txttable.text … |
| | Dear sir i use the code [CODE]Printer.print "Bashir ahmad" printer.endDoc[/CODE]on the click event of a command Button. If the printer is turned on, printing starts, but if the printer is turned off, is there a method of informing the user to turn on the printer before printing. In programs like … |
| | last in wt sense, date, position ???. every record in the table has an identification and u can select only this record in the sql statement like select * from table_name where key=....This query selects only one record at a time. |
| | i enter 3 identical records in an sql database table. Normally this should not have happened and the dbms is to check for identical records. Now when i try to delete or update any record, an error message is displayed and the record is neither deleted nor updated. any help … |
| | [B]in my vb project i have a number of data reports each using a different papersize. each time, b4 opening the report, the paper size has to be set in the printer dialogue box and then the report shows correctly. otherwise the messages like "report width larger than paper width" … |
| | i use vb with Access. I have 2 tables table1 & table2 i create a data report showing the data from table1. [B]My aim is to display the data from table2 on the same report in its next page(s). [/B]any kind of help, suggestions will be highly appreciated. with regards … |
| | [B]I enter 3 identical records in an sql database table. Normally this should not have happened as the DBMS must check for identical records. Now when I try to delete or update these records, an error message is shown. What to do?[/B] |
| | Dear sir I m using vb and access from many years. If U please clarify wt U need,I m sure to help u. U may aslo send ur project for necessary modifications Bashir Ahmad Bhat Govt.College Tral Kashmir |
The End.