Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60

    About "Control Quantity"

    Hello,



    You know, if forms are including 25pcs. control, then the performance test giving warning message for about "reduce control quantity". My main form is including 16pcs control and 1 unit subform. The subform is including 15pcs. control. So totaly, main form is including 32pcs control. But in this situation, performance test is not giving any warning message. But;

    When I attached 1 more control to the main form, it's giving warning message. I didn't understand this control quantities. Would you explain it please?

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Are you getting this message when you use the performance analyzer?
    Click image for larger version. 

Name:	Capture.JPG 
Views:	38 
Size:	26.9 KB 
ID:	35868

    if so, it is advisory - the more controls you have on a form, the slower it will be. I've never really used it but suspect it is based on how access/computers performed many years ago. With modern computers performance is not really affected by number of controls, although there is a lifetime limit of (I think) 750 controls per form.

  3. #3
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60
    Hi Ajax,

    Yes, I getting this message from performance analyzer. But the topic is not computer performance, it is form performance.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    But the topic is not computer performance, it is form performance.
    I know - but form performance is improved with better computer performance - to the extent that with modern computers it is not an issue.

    That is not to say a form can't be a poor performer for other reasons - inefficient recordsource, combo or listbox rowsources, over use of domain functions, lack of indexing etc, but may be picked up when analysing tables and queries

  6. #6
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60
    Hello,
    Yes I asked this question a lot of forms..What is wrong, I didn't understand.
    Not every forum is responsible for itself? Not every forum has its own earnings through advertisements? If not, why take your time and answer?I'm sorry, I don't know why people are willing to volunteer.
    I'm an only user. So I'm searching answere for my question. Some forums giving more effective solutions, some ones are not. It is normal. Isn't it?

  7. #7
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I don't use the analyzer. Found this via Google. It may offer you a starting point for some research.

    Bir Microsoft Access masaüstü veritabanının performansını en iyi duruma getirmek için Performans Çözümleyicisi'ni kullanabilirsiniz. Performans Çözümleyicisi, bir Access projesinde veya Access web uygulamalarında mevcut değildir. Performans Analizörü, veritabanının yapısını ve verilerini inceler ve performansı artırmanıza ve veri hatalarını karıştırmanıza yardımcı olacak önerilerde bulunur.

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Quote Originally Posted by notrino View Post
    Hello,
    Yes I asked this question a lot of forms..What is wrong, I didn't understand.
    Not every forum is responsible for itself? Not every forum has its own earnings through advertisements? If not, why take your time and answer?I'm sorry, I don't know why people are willing to volunteer.
    I'm an only user. So I'm searching answere for my question. Some forums giving more effective solutions, some ones are not. It is normal. Isn't it?
    Absolutely not normal. Unfortunately it is all too common.
    We all have different reasons for volunteering. Mine is because years ago, someone here helped me, plus the more I post, the more I keep what little I know from getting tangled up in the cobwebs of my brain. BUT every time I get involved in a post where there is no acknowledgement when cross posting is called out, that person gets on my list. I don't get paid, so I have zero interest in helping out anyone who does what you do and doesn't seem to care - advertising or no. It's easy to spend a significant amount of time answering a post only to discover later that a solution has been accepted elsewhere. What you're doing is just plain inconsiderate.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  9. #9
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    I don't know why people are willing to volunteer.
    I'm with Micron on this - we are all volunteers but are not obligated to answer your questions. There are perhaps 4 or 5 forums with a large global membership specialising in Access. Many of the regular responders can be found on some or all of these. Almost by definition, regular responders have an in depth knowledge of Access and have the time to respond with an informed response, often promptly. All we ask in return is some consideration that you don't waste our time. There is no objection to cross posting, just let us know that you have done so and provide the links so we can see if what we would have suggested has already been done. It's not difficult, you typically copy/paste the text from one forum to another, just copy/paste the URL as well.

    If you feel this is not your problem and persist, then we all (including yourself) have the opportunity to add you to an ignore list. Then we won't see your posts so will not respond, so no longer a problem for us. But you will have cut yourself off from a group of volunteers who have that in depth knowledge you are seeking.

    FYI I have a number of users on my ignore list, they may have reformed, but I won't know about it.

  10. #10
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    So, that Analyzer may be handy for something but not in this case. Forget about it! I got way more Controls on Forms. Now that said, Forms have a lifetime Control limit of 754... never had THAT many so not a big deal. What really determines the performance for the Form is the Record Source.

    Now, that said, cross-posting... I am on several Forums off and on all day long when I have time. I am not paid to do so, I do it because this is where I got help and now I want to pay it forward. I do not like to *waste my time* and that is what I am doing if I am answering someone who already got the answer. AND, the the person who is still waiting for an answer is STILL waiting because I'm answering that said person who already got an answer.

    There are only a finite group of us volunteers that do this and you cross-posting are taking away resources from those still waiting for answers. So while you don't think it's a big deal you could be caught in the group still waiting for answers because we are busy answering someone who cross-posted.

  11. #11
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    I see you have also crossposted here http://www.utteraccess.com/forum/ind...pic=2051155&hl=

    They have a cross posting discussion going on there having provided the same answer as here, however they do not have a problem with cross posting so suggest you confine your questions to that forum.

  12. #12
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60
    Hello everybody,
    Thanks for your answeres. Who is the BOSS (for example for this forum?)? I guess, the boss is earning money (via advertisements) but the others are just volunteer right? Am I understand true? I'm a user, and I can ask a question. I'm asking only question for Access. I'm not swearing, I'm not kidding.... But you're saying that my messages will be ignored right? I can ask same question to the multiple forums and this is my most natural right. If you see me at the other forums, this is not my problem, this is your problem. I can change my nickname and I can ask same question with different words on the multiple forums? What will you do?Will you hurt me? It is funny..

  13. #13
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    What will you do?Will you hurt me?
    of course not, just ignore you. Since you don't accept that cross posting without advising that is what you are doing wastes peoples time and I know it does we have two different points of view which would appear to be irreconcilable. Since I don't want to waste any more of my time I'm putting you on my ignore list now. Good luck with your project.

  14. #14
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Notrino
    Several people at more than one forum have been trying to assist you and to answer you in an adult way.
    Meanwhile your responses have become utterly juvenile.
    I will also ignore all your future posts and expect many others will do the same..
    If you rejoin under a different name and behave in the same way, you will get the same treatment or get banned.
    I wish you well when you do grow up
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  15. #15
    notrino is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Location
    Izmir,Turkey
    Posts
    60
    Your ideas belong to you and they don't interest me. Who is the majority?3-4 people?I don't know what you think of yourself but the world is a little more crowded than 3-4 people. People in this mindset ,don't answer my questions, please.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 12-21-2016, 04:27 AM
  2. Replies: 3
    Last Post: 02-19-2016, 04:34 PM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Replies: 5
    Last Post: 09-05-2014, 12:59 PM
  5. Replies: 6
    Last Post: 09-04-2014, 02:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums