Write Recordset to MSAccess(mdb) using VB6.0
How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance. Software/Hardware used: VB6.0, MS Access 2003
How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance. Software/Hardware used: VB6.0, MS Access 2003
35 pts.
Change Event Example
I copied the Change Event Example from Help: Private Sub Worksheet_Change(ByVal Target As Range) Target.Font.ColorIndex = 5 End Sub into a module, but when I change the worksheet, it doesn't run. Do I have to enable it in some way? Thanks in advance, Mike
I copied the Change Event Example from Help: Private Sub Worksheet_Change(ByVal Target As Range) Target.Font.ColorIndex = 5 End Sub into a module, but when I change the worksheet, it doesn't run. Do I have to enable it in some way? Thanks in advance, Mike
Connection of Crystal Report 2008 with VB6.
Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..
View Answer
| Jul 13 2009 9:28 AM GMT
Crystal Reports 2008 controls, Visual Basic 6, SQL Server 2000
Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..
View Answer
| Jul 13 2009 9:28 AM GMTCrystal Reports 2008 controls, Visual Basic 6, SQL Server 2000
Disconnecting a Crystal 8.5 report while report is open in VB6
Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which...
Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which...
update query
in vb 6.0 and accesswhat is the problem in this query = "update Technician_time_trn set tech=" & num & " , hrs=" & hrs & " , min=" & mins & " , sec=" & sec & " where task_cd='" & task_cd & "'"
in vb 6.0 and accesswhat is the problem in this query = "update Technician_time_trn set tech=" & num & " , hrs=" & hrs & " , min=" & mins & " , sec=" & sec & " where task_cd='" & task_cd & "'"
Regarding DataGrid (Not MShFlexGrid) in Vb 6.0
i need to select a row in a Datagrid. I tried Datagrid.Row it is Not Working, any one help on this Code - For nlRo = 1 To DataGrid.ApproxCount DataGrid.Refresh DataGrid.Ro =nlRo DataGrid.Col=1 DataGrid.Text = nlRo Next nlRo '' Row is not selecting.....
i need to select a row in a Datagrid. I tried Datagrid.Row it is Not Working, any one help on this Code - For nlRo = 1 To DataGrid.ApproxCount DataGrid.Refresh DataGrid.Ro =nlRo DataGrid.Col=1 DataGrid.Text = nlRo Next nlRo '' Row is not selecting.....
Biometrics with Visual Basic 6
How i can use biometrics in V.B 6.0? any sample code.... Plz help me.......
How i can use biometrics in V.B 6.0? any sample code.... Plz help me.......
Update Microsoft Access database from VB6
Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and the new version there? I...
Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and the new version there? I...
How to get data from a Web-installed Microsoft Access database from VB6
I have an Access 2003 database installed in the database folder on our web site. How can I best modify my VB6 program to obtain the data from this file instead of from C:/ drive?
I have an Access 2003 database installed in the database folder on our web site. How can I best modify my VB6 program to obtain the data from this file instead of from C:/ drive?
VB6 PROGRAM CALLING / CREATING WORD 2007 DOCUMENT
I currently have a VB6 program that is calling WORD2003 and creating documents. Going forward we will be upgrading to WORD 2007. I have tested this but on the opening of word my VB6 program craps out. Any ideas why? Is it not compatiable?
I currently have a VB6 program that is calling WORD2003 and creating documents. Going forward we will be upgrading to WORD 2007. I have tested this but on the opening of word my VB6 program craps out. Any ideas why? Is it not compatiable?
Getting error in this VB 6 code
Sr No Crop Varity Psize Pkts 1 Fodder NG-1788 1 kg 180 2 Sf SN-85 2 Kg 100 3 Beet B-885 1 kg 100 4 Beet B-885 1 kg 150 5 Beet B-885 1 kg 200 6 Beet B-885 1 kg 250 7 Beet B-885 1 kg 300 8 Beet B-885 1 kg 350 9 Beet B-885 1 kg 400 10 Beet B-885 1 kg 500 New Modify Delete Close View I...
Sr No Crop Varity Psize Pkts 1 Fodder NG-1788 1 kg 180 2 Sf SN-85 2 Kg 100 3 Beet B-885 1 kg 100 4 Beet B-885 1 kg 150 5 Beet B-885 1 kg 200 6 Beet B-885 1 kg 250 7 Beet B-885 1 kg 300 8 Beet B-885 1 kg 350 9 Beet B-885 1 kg 400 10 Beet B-885 1 kg 500 New Modify Delete Close View I...
Recordset not Updated as per query and not giving any error
Dear Sir, thanks for your reply for my earlier query, What I am trying to do is i am editing RM item rate in RM master file.. my code doing it correctly, secondly i am updating bill_detail file for rate where that RM code is used in bill this also my code doing correctly, but third one where i am...
Dear Sir, thanks for your reply for my earlier query, What I am trying to do is i am editing RM item rate in RM master file.. my code doing it correctly, secondly i am updating bill_detail file for rate where that RM code is used in bill this also my code doing correctly, but third one where i am...
How to make VB6 and SQL Server 2000 multiuser and client-server?
how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx
how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx
Runtime Error 3001 - Arguments are of the Wrong Type or out of acceptable range or are in conflict with one another
Dear Sir, Thanks for your answer for my earlier questing. It solved my problem I am using VB6 as frontend and Acess as backend. I am edit my table for particular field. I am editing rate of one item in RMmaster file. its doing, but i want to edit rate of same field which is in another file. i am...
Dear Sir, Thanks for your answer for my earlier questing. It solved my problem I am using VB6 as frontend and Acess as backend. I am edit my table for particular field. I am editing rate of one item in RMmaster file. its doing, but i want to edit rate of same field which is in another file. i am...
Application with VSFlexGrid1 in VB6
Dear Sir, Sorry for again with same question, before I say anything I will submitt to you my Command what I use I think its a better way to solve my problem. MySql = "select * from _ Location where ItemNo" If MyItem.state = 1 Then _ MyItem.Close MyiTem.Open MySql, Data, asOpenKeyset,...
Dear Sir, Sorry for again with same question, before I say anything I will submitt to you my Command what I use I think its a better way to solve my problem. MySql = "select * from _ Location where ItemNo" If MyItem.state = 1 Then _ MyItem.Close MyiTem.Open MySql, Data, asOpenKeyset,...
Runtime Error 2147217900 (80040e14) - Syntex Error (Missing Operator) in query expression
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as "Runtime Error 2147217900 (80040e14) - Syntex Error (missing Operator)in query expression " ...
View Answer
| May 26 2009 10:09 AM GMT
Visual Basic 6, Microsoft Access, Visual Basic runtime errors
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as "Runtime Error 2147217900 (80040e14) - Syntex Error (missing Operator)in query expression " ...
View Answer
| May 26 2009 10:09 AM GMTVisual Basic 6, Microsoft Access, Visual Basic runtime errors
Application using VSFLEXGRID1 in VB6
Dear Sir, I make a simple Inventory programme, I have a form name "Location Details" with vsflexgrid, where is user find the Item Quantity of each location by Item No. my problem is I want to add my data to grid sorting by location for example one Item has in 4 location and some Item has a 1...
Dear Sir, I make a simple Inventory programme, I have a form name "Location Details" with vsflexgrid, where is user find the Item Quantity of each location by Item No. my problem is I want to add my data to grid sorting by location for example one Item has in 4 location and some Item has a 1...
How to make a Visual Basic 6 setup file
Hi all I want to make set up for vb 6.0 which has Application folder, data folder, Report folder Plz help me in this.
Hi all I want to make set up for vb 6.0 which has Application folder, data folder, Report folder Plz help me in this.
How to remove tmp files in Crystal Reports 8.5
Hi, I develop an application in vb6 + crystal report 8.5. whenever i run a report application generate tmp file with 0k. how can i remove these files. Regards.
Hi, I develop an application in vb6 + crystal report 8.5. whenever i run a report application generate tmp file with 0k. how can i remove these files. Regards.
