Search results for query: *

sorry, i misunderstood. this is a good method. :)

hameed, your idea is good. but about the efficiency, i'm not sure. tabindex is used to step thru the controls using tab key, isn't it. so, if you you assign the tabindexes of the controls according to your need in the datagrid, you will have to place the controls in the same order as you have...

do you use the loop and text boxes to fill the grid fully or just one row while inserting records and updating? for filling the entire grid there is set flex1.datasource = rs1 where rs1 is the recordset into which you selected records from database. for adding, you can just give...

you can use control arrays for creating textboxes with index. suppose you have one textbox text1. select it and copy and paste it in the same form. vb will ask you whether you want to create a control array. say yes. now. you will have 2 textboxes with the same name but different indexes. like...

if you keep all the fields in the grid, then there is no need of even using the primary key. as you said, it's better for navigation in the detail section. and the method you have used for next and previous is fine as far as i can see. by the way, i have a doubt. do you keep the grid and the...

did you mean to say that you have 2-3 fields alone shown in the flex and you need to show more fields of the clicked row in the detailed page? i also do the same thing. what i do is that i keep the primary key of the table in the flex and when the flex's row is clicked, i retrieve just the...

i do a similar thing with mshflexgrid but the textboxes and comboboxes in the detail section are not navigable, ie, it is independent of the database(not bound). in your case, are the textboxes or whatever you use in detail page connected to the database directly? i don't know whether that...

i'm connecting to oracle and everything is working fine with the following code. try it. "myservername", "myusername" and "mypassword" and "mytable" needs to be changed Set conn = New adodb.Connection Let conn.ConnectionString = "Driver={Microsoft...

did you close the connection in the terminate event of the data report? you need to load the dataenvironment as "load dataenvironment1" before you give "report1.show" and you need to unload it in the terminate event of the data report as Private Sub DataReport_Terminate()...

do you mean datareports in vb6? do you use dataenvironment to connect to the database. if you do, then in the terminate event of the datareport, you need to unload or close the dataenvironment according to whether you loaded or opened it for the reporting purpose. in the form from which you...

i had the same problem with datacombo that billybobk had. i tried all the solutions suggested here but as billybobk said,only the 1st record is being retrieved with these methods. why is that so? finally i connected it thru adodc 's coding and it worked. the code was adodc1.ConnectionString =...

isn't it better to connect to the database manually using adodb?

won't the dialog box control do for asking the printing options? thru project/components add microsoft common dialog contol 6.0 to your project. now, from the toolbox, add it to your form. and put a command control also on your form. in the click event of your command button, add this code...

yeah, as petevick said, why not retrieve the fields in a concatenated form thru the sql itself

set the "On Error GoTo GetConn_Fail" line as a comment and see which line exaclty is creating the error. after you close connection as conn1.close, as far as i know, there is no need to set conn1 as nothing. is your code working fine the first time it's run?

can you show the code in the form_unload event?

try changing the form_unload code to Private Sub Form_Unload(Cancel As Integer) 'cierro la tabla grs.close set grs = nothing gconn.Close End Sub it should work

why don't you retrieve the records using data control or just recordsets instead of going for dataenvironment. to the project add components Microsoft ado data control 6. add the data grid and the adodc to your form. connect the adodc to your database by setting the connectionstring...

yes, as far as i know, it's faster. when we deal with a lot of records, i've seen it to work more efficiently and faster than data controls.

which "sql command" do we use to commit a transaction in foxpro? is there any specific thing? if there is.... try to give it in the execute statement conn.Execute "..(here)...." just guessing.