G
Guest
I am convering a Access 2K project that will now be using SQL tables for
storing the back end data.
I just read info about the upsizing wizard which had some info on how to
design new queiries using "Where" so that this runs on the sql server.
I have a query that is slow. (See Below) I could use help with the syntax
to change this so that it is more effecient.
Private Sub Combo90_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Company] = '" & Me![Combo90] & "'"
Me.Bookmark = rs.Bookmark
Me.Filter = "[Company] = '" & Me![Combo90] & "'"
Me.FilterOn = True
Me.Refresh
Set rs = Nothing
End Sub
Can I use the query wizard in Access 2 K to write this query with the Where
Clause?
Thanks in advance.
storing the back end data.
I just read info about the upsizing wizard which had some info on how to
design new queiries using "Where" so that this runs on the sql server.
I have a query that is slow. (See Below) I could use help with the syntax
to change this so that it is more effecient.
Private Sub Combo90_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Company] = '" & Me![Combo90] & "'"
Me.Bookmark = rs.Bookmark
Me.Filter = "[Company] = '" & Me![Combo90] & "'"
Me.FilterOn = True
Me.Refresh
Set rs = Nothing
End Sub
Can I use the query wizard in Access 2 K to write this query with the Where
Clause?
Thanks in advance.