Results 1 to 4 of 4
  1. #1
    amd711 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    28

    Run-time error '2101'

    "Run-time error '2101' The setting you entered isn't valid for this property"



    i am getting this error message when i try to change the "value" property of activex progress bar added in the form
    for example:

    on command click event:

    me.probar3.value = me.probar3.value + 10

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    That would be because an ActiveX Progress Bar does not have a Value Property!

    What, exactly, are you trying to do?

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    amd711 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    28
    That would be because an ActiveX Progress Bar does not have a Value Property!

    What, exactly, are you trying to do?

    Linq ;0)>
    what do you mean it dosn't has a value property !!!!!!!!!!!!!!!!

    Click image for larger version. 

Name:	probar-value.JPG 
Views:	8 
Size:	23.5 KB 
ID:	10050
    Click image for larger version. 

Name:	probar-value2.jpg 
Views:	11 
Size:	14.7 KB 
ID:	10052

    it dose has a value property
    (basic property in a progress bar) !!!

  4. #4
    amd711 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    28
    i found the solution

    http://support.softwarefx.com/ShowAr.../190/1/015.htm

    Since "Value" is a reserved in Microsoft Access, you will get an error message when trying to pass data as follows:

    Chart1.Value(1, 2) = 40

    "Run-time error '2101': The setting you entered isn't valid for this property"

    This problem can be easily solved by accessing the "Object" property first:

    chart.Object.Value(1,2) = 40

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error: Run-time error '13' Type mismatch
    By uronmapu in forum Access
    Replies: 1
    Last Post: 09-07-2012, 05:38 AM
  2. Replies: 0
    Last Post: 07-16-2012, 05:42 AM
  3. Replies: 6
    Last Post: 05-30-2012, 12:32 PM
  4. Replies: 5
    Last Post: 03-27-2012, 01:40 PM
  5. Subform Change - Run-time error 2101
    By Cheshire101 in forum Forms
    Replies: 3
    Last Post: 12-21-2009, 12:37 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