Search results

Yeah, I didn't cut'n paste the code, but i had i.e. "Set" the recordset of the form, as you mentioned. I've tried not closing the connections and retaining the variables in the more global scope, however I'm not nearer a solution. I think I have to redo it some way so that I'm only displaying...

Thanks, I've tried changing the recordset-query, but to no avail. It seems as if Access doesn't know how to create the update/delete statements when I'm doing it this way, could this be correct? I do this programatically because I'm not able to query the underlying SQL Server using the special...

Maybe I should rephrase things: I have this function defined: Public Function DoQueryReturnRecordset(TAGNum As String) As ADODB.Recordset Dim cnn As New ADODB.Connection Dim strSQL As String Dim i As Integer Set DoQueryReturnRecordset = New ADODB.Recordset...

Hi! I have bound a form's recordset to a recordset i've created through some VB code. However, the form has "allow inserts" and "allow updates" properties set, and I wonder how I'm supposed to go about implementing these functions. I'm not an experienced Microsoft Access user, and I'm not...

I've found a solution to this part. I have created a function that returns a recordset, and then I bind this recordset to the recordset of the form.

Hi! We have an old application (as an Access Front-end to a sql-server) that I need to make changes to. I have set up a pass-through query to the SQL-server and it works flawlessly, and I have also tied it up to the sub-form, which again is attached to the main form. When I execute the...