|
 |
access thread: BEST approach on form opening
Message #1 by "George Oro" <george@c...> on Sat, 30 Nov 2002 11:46:37 +0400
|
|
Hi Guys,
What is the best approach to increase the speed of my frmContacts on opening after filtering the required records to view from my
frmSearch?
This is my current approach:
1) On my frmSearch I have a list where user can search by first/last name etc... using a txtSearch.
2) On Click Events on my list, the selected ContactsID will automatically assigned to txtContactsID (Text Box) as the parameter.
3) On DoubleClick Events on my list I have the below code to automatically open my frmContacts and filter according to the given
parameter (txtContactsID).
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmContacts"
stLinkCriteria = "[m01ContactsID]=" & Me![txtContactsID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
The problem is, my frmContacts is opening very slow (5 secs.) which is not acceptable. Actually I know some few reason why &
solution to solved it but still doubted:
REASON:
1) My frmContacts is bound to m01TblContacts with 50,000 + records.
2) The back-end is on the network.
3) Front/Back-end is on Access2K environment.
SOLUTION:
1) Upgrade to Access Project front-end and SQL/MSDE back-end and used Stored Procedure as the form RecordSource which I don't got
much time to redo everything.
2) (Access2K) Open the form without any default RecordSource defined and populate on load/open or current but not exactly what is
the best to use.
OnLoad Event
a) SELECT * FROM m01TblContacts WHERE m01ContactsID = MyParameter or
b) Me.RecordSource=m01QryContacts (The parameter is already defined on the query) or
c) ??????????????
What is the best guys, any help and tips is highly appreciated...
TIA,
George
Message #2 by "Enzo Zaragoza" <enzaux@g...> on Sat, 30 Nov 2002 16:15:52 +0800
|
|
Try doing it using unbound forms. There is an option when opening forms wherein
you can put any data. OpenArgs to be in particular. in the opened form get the
value of the OpenArgs thrown by ur first form then make your query then fill in the
necessary fields.
For Ex.
Form1
======
DoCmd.OpenForm "Form2", acNormal,,,,,txtSearch.Text
Form2
=====
Private Sub Form_Load()
strSearch = Me.OpenArgs
.
do you search here
.
End Sub
enzo c",)
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Saturday, November 30, 2002 3:47 PM
To: Access
Subject: [access] BEST approach on form opening
Hi Guys,
What is the best approach to increase the speed of my frmContacts on opening after filtering the required records to view from my
frmSearch?
This is my current approach:
1) On my frmSearch I have a list where user can search by first/last name etc... using a txtSearch.
2) On Click Events on my list, the selected ContactsID will automatically assigned to txtContactsID (Text Box) as the parameter.
3) On DoubleClick Events on my list I have the below code to automatically open my frmContacts and filter according to the given
parameter (txtContactsID).
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmContacts"
stLinkCriteria = "[m01ContactsID]=" & Me![txtContactsID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
The problem is, my frmContacts is opening very slow (5 secs.) which is not acceptable. Actually I know some few reason why &
solution to solved it but still doubted:
REASON:
1) My frmContacts is bound to m01TblContacts with 50,000 + records.
2) The back-end is on the network.
3) Front/Back-end is on Access2K environment.
SOLUTION:
1) Upgrade to Access Project front-end and SQL/MSDE back-end and used Stored Procedure as the form RecordSource which I don't got
much time to redo everything.
2) (Access2K) Open the form without any default RecordSource defined and populate on load/open or current but not exactly what is
the best to use.
OnLoad Event
a) SELECT * FROM m01TblContacts WHERE m01ContactsID = MyParameter or
b) Me.RecordSource=m01QryContacts (The parameter is already defined on the query) or
c) ??????????????
What is the best guys, any help and tips is highly appreciated...
TIA,
George
Message #3 by "Steve Klein" <Stephen@K...> on Sat, 30 Nov 2002 09:34:03 -0000
|
|
Sorry to be dense can you take me through this in a little more detail
Steve K
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: 30 November 2002 08:16
To: Access
Subject: [access] RE: BEST approach on form opening
Try doing it using unbound forms. There is an option when opening forms
wherein
you can put any data. OpenArgs to be in particular. in the opened form get
the
value of the OpenArgs thrown by ur first form then make your query then fill
in the
necessary fields.
For Ex.
Form1
======
DoCmd.OpenForm "Form2", acNormal,,,,,txtSearch.Text
Form2
=====
Private Sub Form_Load()
strSearch = Me.OpenArgs
.
do you search here
.
End Sub
enzo c",)
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Saturday, November 30, 2002 3:47 PM
To: Access
Subject: [access] BEST approach on form opening
Hi Guys,
What is the best approach to increase the speed of my frmContacts on opening
after filtering the required records to view from my
frmSearch?
This is my current approach:
1) On my frmSearch I have a list where user can search by first/last name
etc... using a txtSearch.
2) On Click Events on my list, the selected ContactsID will automatically
assigned to txtContactsID (Text Box) as the parameter.
3) On DoubleClick Events on my list I have the below code to automatically
open my frmContacts and filter according to the given
parameter (txtContactsID).
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmContacts"
stLinkCriteria = "[m01ContactsID]=" & Me![txtContactsID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
The problem is, my frmContacts is opening very slow (5 secs.) which is not
acceptable. Actually I know some few reason why &
solution to solved it but still doubted:
REASON:
1) My frmContacts is bound to m01TblContacts with 50,000 + records.
2) The back-end is on the network.
3) Front/Back-end is on Access2K environment.
SOLUTION:
1) Upgrade to Access Project front-end and SQL/MSDE back-end and used Stored
Procedure as the form RecordSource which I don't got
much time to redo everything.
2) (Access2K) Open the form without any default RecordSource defined and
populate on load/open or current but not exactly what is
the best to use.
OnLoad Event
a) SELECT * FROM m01TblContacts WHERE m01ContactsID = MyParameter or
b) Me.RecordSource=m01QryContacts (The parameter is already defined on the
query) or
c) ??????????????
What is the best guys, any help and tips is highly appreciated...
TIA,
George
Message #4 by "bwarehouse" <bwarehouse@y...> on Sat, 30 Nov 2002 05:06:48 -0700
|
|
open the form in unbound mode and no filters, to at least get it on the
screen quickly.
that is most important to the end user (to see something happening, versus
nothing).
then load your stLinkCriteria.. if it still takes approx. 5 seconds to load
the data, then
add a popup box after form load and prior to data load with an indicator
something like (LOADING...), so the end user knows something is
happening..
later,
b.ware
-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Saturday, November 30, 2002 12:47 AM
To: Access
Subject: [access] BEST approach on form opening
Hi Guys,
What is the best approach to increase the speed of my frmContacts on opening
after filtering the required records to view from my
frmSearch?
This is my current approach:
1) On my frmSearch I have a list where user can search by first/last name
etc... using a txtSearch.
2) On Click Events on my list, the selected ContactsID will automatically
assigned to txtContactsID (Text Box) as the parameter.
3) On DoubleClick Events on my list I have the below code to automatically
open my frmContacts and filter according to the given
parameter (txtContactsID).
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmContacts"
stLinkCriteria = "[m01ContactsID]=" & Me![txtContactsID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
The problem is, my frmContacts is opening very slow (5 secs.) which is not
acceptable. Actually I know some few reason why &
solution to solved it but still doubted:
REASON:
1) My frmContacts is bound to m01TblContacts with 50,000 + records.
2) The back-end is on the network.
3) Front/Back-end is on Access2K environment.
SOLUTION:
1) Upgrade to Access Project front-end and SQL/MSDE back-end and used Stored
Procedure as the form RecordSource which I don't got
much time to redo everything.
2) (Access2K) Open the form without any default RecordSource defined and
populate on load/open or current but not exactly what is
the best to use.
OnLoad Event
a) SELECT * FROM m01TblContacts WHERE m01ContactsID = MyParameter or
b) Me.RecordSource=m01QryContacts (The parameter is already defined on the
query) or
c) ??????????????
What is the best guys, any help and tips is highly appreciated...
TIA,
George
|
|
|
View Cart
