Thank you very much for your help! No - I want use requery on these recordsets, will see how far I get with refresh.
By the way: Do you know if it is a built-in function in Access for sending group-email? I consider using a subform or listbox to mark several email-adresses and use these to open a new email in Outlook. I haven't started to look at this subject yet - well, - looking for a shortcut to information :-)...
JonOle
Last Activity: Nov 20 '08, 09:03 AM
Joined: Oct 27 '08
Location:
-
I've tested some changes:
In the mainform I open the main recordset, use it to fill the combo and bind it to the form.recordset. It's filtered, but I see on the SQL-server trace that the whole table is transferred from the server to the client:
...Code:Private Sub Form_Open(Cancel As Integer) On Error GoTo err: Application.Echo False GjeldendePersonID = 48 Dim FormRst As New ADODB.RecordsetLeave a comment:
-
I don't think the connection is the problem here, but it can be something there that triggers Access to close the subforms when I reset the recordset in the mainform. But I would like to hear your suggestions - I think you have knowledge that could help me further on.
If I use filtering in the form, I would have to bind the form to the entire recordset, wouldn't I? Meaning that the whole table will be transferred from the sql-server...Leave a comment:
-
Yes, this makes absolutely sense to me, and I agree that this is too complicated. I suppose it has been like this because I use the tools that I knows - a rather common habit, I think.
My goal is to gain acceptable speed in communication with my sql-server when connecting via vpn. It would have been very easy to use ODBC-linked tables, but I don't want to wait 5 minutes for the form to refresh... Therefore I want to gather only the...Leave a comment:
-
I've placed the code on the click-event in the combo:
GjeldendePerson ID is the global variable that holds the primary key. SettSkjemaFamPe rsRstEr is placed in a module and goes on like this:Code:Private Sub PersonLst_Click() GjeldendePersonID = Me.ActiveControl SettSkjemaFamPersRstEr End Sub
...Code:Public Sub SettSkjemaFamPersRstEr() SettFamilierPersonerRst SettTreningsdetaljerRst SettFamilieRst
Leave a comment:
-
Binding mainform and subforms to SQL-server-view
In Access 2007 I have a main form with several subforms. All forms are unbound, and the recordsets for the forms are set during the OnOpen-event in the main-form.
I use ADO and OleDB to connect to the SQL-server and to bind the recordsets with the forms.
Everything works OK when the forms open the first time.
In the main form I have a combo that resets the recordsets for all the forms depending on the...
No activity results to display
Leave a comment: