View Single Post
  #16  
Old February 23rd, 2010, 10:32 PM posted to microsoft.public.access.tablesdbdesign
jenniferspnc
external usenet poster
 
Posts: 65
Default Slow form, again

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" wrote:

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

"jenniferspnc" wrote in message
...
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" wrote:

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

"jenniferspnc" wrote in message
...
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" wrote:

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" wrote in message
...
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!


.



.



.