Slow form, again

  • Thread starter Thread starter jenniferspnc
  • Start date Start date
J

jenniferspnc

Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID, Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this database.

Thanks!
 
Hello Jennifer,

I provide help with Access, Excel and Word applications for a very nominal
fee. I would like to offer to take a look at your database and see what is
needed to fix it. If it can be fixed, my fee would be very modest. There
would be no charge if it can not be fixed. Give me a chance to try to get it
downto couple of seconds. Contact me.

Steve
(e-mail address removed)
 
jenniferspnc,

So far nothing you have shown explains the slowness... What version of
Access? On a *copy* of the database have you tried removing the subforms
and adding them back one at a time while checking the load time to see if
one of those subforms is the issue?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
 
Come on Steve! Does it never end. People come here for free help, not a
sale pitch!

If you have constructive advice to give on how they can try to resolve their
given problem, then give it. Otherwise, just don't answer.
--
Daniel Pineault




Steve said:
Hello Jennifer,

I provide help with Access, Excel and Word applications for a very nominal
fee. I would like to offer to take a look at your database and see what is
needed to fix it. If it can be fixed, my fee would be very modest. There
would be no charge if it can not be fixed. Give me a chance to try to get it
downto couple of seconds. Contact me.

Steve
(e-mail address removed)


jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...


.
Click to expand...
 
I know one issue I have had was entirely related to network/server
performance. What is the path to your db? How many sub-directories deep is
it place on the server?

If you can, try placing the back-end on the very top level (no
sub-directories) and see if speed improves.

Each user has their own copy of the Front-End?
Each user has their copy placed on their own PC, not on the server?
The database is maintained (compacted and repair from time to time)?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID, Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this database.

Thanks!
Click to expand...
 
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Steve said:
Hello Jennifer,

I provide help with Access, Excel and Word applications for a very nominal
fee. I would like to offer to take a look at your database and see what is
needed to fix it. If it can be fixed, my fee would be very modest. There
would be no charge if it can not be fixed. Give me a chance to try to get
it downto couple of seconds. Contact me.

Steve
Click to expand...


Please do not feed the trolls!


Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP
 
RESUBMITTING because I can't see my own post...

jenniferspnc,

So far nothing you have shown explains the slowness... What version of
Access? On a *copy* of the database have you tried removing the subforms
and adding them back one at a time while checking the load time to see if
one of those subforms is the issue?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
 
Thanks everyone for the posts. I'll try to answer all the questions here.

It is over a LAN and the form is bound to a query.

I put the BE two folders down (the closest I can get) and the name is short
(Oppt_be). Each user has their own FE installed on their desktop. Yes, I do
compact and repair often.

Using Access 2007
Yes I actually thought of it and did take off one subform at a time trying
to isolate the "problem."
Removing all subforms gets the form to load in about 15 seconds. But
removing only one at a time may only save me like 5 seconds (so with 3 that's
about 15 seconds).

Not sure if it is server related but this afternoon it was only taking 30
seconds to load vs this morning 40 seconds, and I hadn't made any changes to
the original.

If it's not my database I'm not sure what to tell my co-workers and boss for
a solution. But it's taking too much time to enter information.

Thanks for the FREE advice. Truly helps me learn instead of having someone
else do it for me.



Jeff Boyce said:
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...


.
Click to expand...
 
jenniferspnc,

Is the below query what the Parent form is based on?

SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

ANd I could have missed it but I didn't see where you mentioned what version
of Access...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks everyone for the posts. I'll try to answer all the questions here.

It is over a LAN and the form is bound to a query.

I put the BE two folders down (the closest I can get) and the name is short
(Oppt_be). Each user has their own FE installed on their desktop. Yes, I
do
compact and repair often.

Using Access 2007
Yes I actually thought of it and did take off one subform at a time trying
to isolate the "problem."
Removing all subforms gets the form to load in about 15 seconds. But
removing only one at a time may only save me like 5 seconds (so with 3
that's
about 15 seconds).

Not sure if it is server related but this afternoon it was only taking 30
seconds to load vs this morning 40 seconds, and I hadn't made any changes to
the original.

If it's not my database I'm not sure what to tell my co-workers and boss for
a solution. But it's taking too much time to enter information.

Thanks for the FREE advice. Truly helps me learn instead of having someone
else do it for me.



Jeff Boyce said:
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...


.
Click to expand...
 
Oops, guess I missed that question...I am running Access 2007.

Yes, that is the query for the parent form. I can post the code of the
subforms if you think the problem might lie there.

Thanks again :)

Gina Whipp said:
jenniferspnc,

Is the below query what the Parent form is based on?

SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

ANd I could have missed it but I didn't see where you mentioned what version
of Access...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks everyone for the posts. I'll try to answer all the questions here.

It is over a LAN and the form is bound to a query.

I put the BE two folders down (the closest I can get) and the name is short
(Oppt_be). Each user has their own FE installed on their desktop. Yes, I
do
compact and repair often.

Using Access 2007
Yes I actually thought of it and did take off one subform at a time trying
to isolate the "problem."
Removing all subforms gets the form to load in about 15 seconds. But
removing only one at a time may only save me like 5 seconds (so with 3
that's
about 15 seconds).

Not sure if it is server related but this afternoon it was only taking 30
seconds to load vs this morning 40 seconds, and I hadn't made any changes to
the original.

If it's not my database I'm not sure what to tell my co-workers and boss for
a solution. But it's taking too much time to enter information.

Thanks for the FREE advice. Truly helps me learn instead of having someone
else do it for me.



Jeff Boyce said:
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...


.
Click to expand...


.
Click to expand...
 
jenniferspnc,

How big is this table... how many records? Seems a little slow at 15
seconds. Do you have any combo boxes on the Parent form any DLookups? And
while you're at it can you post the code to the subforms?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Oops, guess I missed that question...I am running Access 2007.

Yes, that is the query for the parent form. I can post the code of the
subforms if you think the problem might lie there.

Thanks again :)

Gina Whipp said:
jenniferspnc,

Is the below query what the Parent form is based on?

SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

ANd I could have missed it but I didn't see where you mentioned what
version
of Access...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks everyone for the posts. I'll try to answer all the questions here.

It is over a LAN and the form is bound to a query.

I put the BE two folders down (the closest I can get) and the name is
short
(Oppt_be). Each user has their own FE installed on their desktop. Yes, I
do
compact and repair often.

Using Access 2007
Yes I actually thought of it and did take off one subform at a time trying
to isolate the "problem."
Removing all subforms gets the form to load in about 15 seconds. But
removing only one at a time may only save me like 5 seconds (so with 3
that's
about 15 seconds).

Not sure if it is server related but this afternoon it was only taking 30
seconds to load vs this morning 40 seconds, and I hadn't made any changes
to
the original.

If it's not my database I'm not sure what to tell my co-workers and boss
for
a solution. But it's taking too much time to enter information.

Thanks for the FREE advice. Truly helps me learn instead of having
someone
else do it for me.



Jeff Boyce said:
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how
many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards
of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute
to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about
10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load
event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am
confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the
Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source
Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...


.
Click to expand...


.
Click to expand...
 
Jennifer:

One thing you can try is to make a copy of the BackEnd onto your local
machine and see if that speeds things up. If it does then you know that it is
the network that is slowing you down.

Are you running SQL Server or Oracle on the BackEnd? I had a similar problem
on a project that had Oracle on the BE and it was terrible slow. I converted
all my Access SQL to pass-through SQL and the it sped up the application
tremendously. The form load went from approximately 1-2 minutes down to a few
seconds.

HTH
 
?... and the number of rows/records you are trying to 'load'?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

jenniferspnc said:
Thanks everyone for the posts. I'll try to answer all the questions here.

It is over a LAN and the form is bound to a query.

I put the BE two folders down (the closest I can get) and the name is
short
(Oppt_be). Each user has their own FE installed on their desktop. Yes, I
do
compact and repair often.

Using Access 2007
Yes I actually thought of it and did take off one subform at a time trying
to isolate the "problem."
Removing all subforms gets the form to load in about 15 seconds. But
removing only one at a time may only save me like 5 seconds (so with 3
that's
about 15 seconds).

Not sure if it is server related but this afternoon it was only taking 30
seconds to load vs this morning 40 seconds, and I hadn't made any changes
to
the original.

If it's not my database I'm not sure what to tell my co-workers and boss
for
a solution. But it's taking too much time to enter information.

Thanks for the FREE advice. Truly helps me learn instead of having
someone
else do it for me.



Jeff Boyce said:
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute
to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about
10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load
event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the
Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source
Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...


.
Click to expand...
Click to expand...
 
It has 19 records.

Subform1:
SELECT tbl_countrybridge.CountryUniqueID, tbl_countrybridge.Country_ID,
tbl_countrybridge.Opportunity_ID
FROM tbl_countrybridge;

Subform2:
SELECT tbl_manufacturer.Manufacturer, Order_Parts.Opportunity_ID,
Order_Parts.Unique_ID, Order_Parts.Country_ID, Order_Parts.Manufacturer_ID
FROM Order_Parts LEFT JOIN tbl_manufacturer ON Order_Parts.Manufacturer_ID =
tbl_manufacturer.Manufacturer_ID;

Subform3:
SELECT Opportunity_Type_List.Unqiue_Type_ID, Opportunity_Type_List.Type_ID,
Opportunity_Type_List.Opportunity_ID
FROM Opportunity_Type_List;

ComboBox Details:
Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source
Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Gina Whipp said:
jenniferspnc,

How big is this table... how many records? Seems a little slow at 15
seconds. Do you have any combo boxes on the Parent form any DLookups? And
while you're at it can you post the code to the subforms?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Oops, guess I missed that question...I am running Access 2007.

Yes, that is the query for the parent form. I can post the code of the
subforms if you think the problem might lie there.

Thanks again :)

Gina Whipp said:
jenniferspnc,

Is the below query what the Parent form is based on?

SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

ANd I could have missed it but I didn't see where you mentioned what
version
of Access...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks everyone for the posts. I'll try to answer all the questions here.

It is over a LAN and the form is bound to a query.

I put the BE two folders down (the closest I can get) and the name is
short
(Oppt_be). Each user has their own FE installed on their desktop. Yes, I
do
compact and repair often.

Using Access 2007
Yes I actually thought of it and did take off one subform at a time trying
to isolate the "problem."
Removing all subforms gets the form to load in about 15 seconds. But
removing only one at a time may only save me like 5 seconds (so with 3
that's
about 15 seconds).

Not sure if it is server related but this afternoon it was only taking 30
seconds to load vs this morning 40 seconds, and I hadn't made any changes
to
the original.

If it's not my database I'm not sure what to tell my co-workers and boss
for
a solution. But it's taking too much time to enter information.

Thanks for the FREE advice. Truly helps me learn instead of having
someone
else do it for me.



Jeff Boyce said:
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how
many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards
of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute
to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about
10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load
event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am
confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the
Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source
Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!


.
Click to expand...


.
Click to expand...


.
Click to expand...
 
Yes, when I put the BE on my desktop it will open the form in about 3
seconds.

So perhaps it's all network related? I'm not too sure about it being SQL or
Oracle...not my area of knowledge. What do you suggest and how do I go about
doing it?

Thanks.

DrGUI said:
Jennifer:

One thing you can try is to make a copy of the BackEnd onto your local
machine and see if that speeds things up. If it does then you know that it is
the network that is slowing you down.

Are you running SQL Server or Oracle on the BackEnd? I had a similar problem
on a project that had Oracle on the BE and it was terrible slow. I converted
all my Access SQL to pass-through SQL and the it sped up the application
tremendously. The form load went from approximately 1-2 minutes down to a few
seconds.

HTH

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID, Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this database.

Thanks!
Click to expand...
Click to expand...
 
.... from your original post, about 20 records.

Loading a form with 20 records via a query, especially when that query has
no calculated values or selection criteria or sort order, should appear
instantaneous.

If it still takes "3 seconds" when you have the data local on your PC, I'd
be suspecting something else.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


Jeff Boyce said:
?... and the number of rows/records you are trying to 'load'?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

jenniferspnc said:
Thanks everyone for the posts. I'll try to answer all the questions
here.

It is over a LAN and the form is bound to a query.

I put the BE two folders down (the closest I can get) and the name is
short
(Oppt_be). Each user has their own FE installed on their desktop. Yes,
I do
compact and repair often.

Using Access 2007
Yes I actually thought of it and did take off one subform at a time
trying
to isolate the "problem."
Removing all subforms gets the form to load in about 15 seconds. But
removing only one at a time may only save me like 5 seconds (so with 3
that's
about 15 seconds).

Not sure if it is server related but this afternoon it was only taking 30
seconds to load vs this morning 40 seconds, and I hadn't made any changes
to
the original.

If it's not my database I'm not sure what to tell my co-workers and boss
for
a solution. But it's taking too much time to enter information.

Thanks for the FREE advice. Truly helps me learn instead of having
someone
else do it for me.



Jeff Boyce said:
Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how
many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards
of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute
to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about
10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load
event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am
confused on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the
Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source
Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!


.
Click to expand...
Click to expand...
Click to expand...
 
Exactly what kind of network? (I am assuming the back end is an MDB, so
don't even concern yourself with Oracle or SQL Server.)

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes, when I put the BE on my desktop it will open the form in about 3
seconds.

So perhaps it's all network related? I'm not too sure about it being SQL or
Oracle...not my area of knowledge. What do you suggest and how do I go
about
doing it?

Thanks.

DrGUI said:
Jennifer:

One thing you can try is to make a copy of the BackEnd onto your local
machine and see if that speeds things up. If it does then you know that it
is
the network that is slowing you down.

Are you running SQL Server or Oracle on the BackEnd? I had a similar
problem
on a project that had Oracle on the BE and it was terrible slow. I
converted
all my Access SQL to pass-through SQL and the it sped up the application
tremendously. The form load went from approximately 1-2 minutes down to a
few
seconds.

HTH

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...
Click to expand...
 
The back-end is a .accdb (using Office 2007).

Does that help?? Sorry IT is not my area :(

Gina Whipp said:
Exactly what kind of network? (I am assuming the back end is an MDB, so
don't even concern yourself with Oracle or SQL Server.)

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes, when I put the BE on my desktop it will open the form in about 3
seconds.

So perhaps it's all network related? I'm not too sure about it being SQL or
Oracle...not my area of knowledge. What do you suggest and how do I go
about
doing it?

Thanks.

DrGUI said:
Jennifer:

One thing you can try is to make a copy of the BackEnd onto your local
machine and see if that speeds things up. If it does then you know that it
is
the network that is slowing you down.

Are you running SQL Server or Oracle on the BackEnd? I had a similar
problem
on a project that had Oracle on the BE and it was terrible slow. I
converted
all my Access SQL to pass-through SQL and the it sped up the application
tremendously. The form load went from approximately 1-2 minutes down to a
few
seconds.

HTH

jenniferspnc said:
Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!
Click to expand...
Click to expand...


.
Click to expand...
 
Yes, it is a LAN (not wirless), and excuse my earlier ignorance.

I do have a form that is bound to a dummy table in the BE to keep a
persistent connection (it opens with the welcome screen).

It's truly frustrating because I want to believe that it is the network and
not my database design, although I am not an expert on databases (read and
learn is how I get by).


BruceM via AccessMonster.com said:
I didn't see this in the performance FAQ link (although I could have missed
it), and I don't think you mentioned it: when the database BE is on the LAN
(not wireless, I hope), open a form bound to a BE table (or a query that uses
a BE table). Minimize it if you like, but leave it open. Now try to run the
problem query, or load the form. Any change?
The back-end is a .accdb (using Office 2007).

Does that help?? Sorry IT is not my area :(
Exactly what kind of network? (I am assuming the back end is an MDB, so
don't even concern yourself with Oracle or SQL Server.)
Click to expand...
[quoted text clipped - 94 lines]
.
Click to expand...
Click to expand...

--
Message posted via AccessMonster.com


.
Click to expand...
 
Back
Top