Results 1 to 6 of 6
  1. #1
    keen1598 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2013
    Posts
    2

    Action Failed: Error Number: 2950

    Hi all,


    I recently inherited some bad files from a previous DBA. I had a similar DB with the same error and managed to find the solution to that one, but this one is giving me fits.
    We have a welcome page that asks for a date range for the specification range. When entered the user click the Button selector to run a a report. Upon clicking the button I get error 2950 (that SOB) that first states "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables." then after clicking "OK" brings me to the Action Failed Message which states that Macro Name: "DATE ENTRY PAGE" : COMMAND1 : ONCLICK : EMBEDDED MACRO" Condition "TRUE" Action Name: "OPENREPORT" Arguments: "REPORT PAGE, 2, , , NORMAL" Error Number: 2950.

    I'm pulling out my hair here...please help


    .Click image for larger version. 

Name:	ACCESS1.JPG 
Views:	23 
Size:	57.8 KB 
ID:	11630
    Click image for larger version. 

Name:	ACCESS2.JPG 
Views:	21 
Size:	53.2 KB 
ID:	11631

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    How about converting the macro to code and see if it is any different? http://www.btabdevelopment.com/ts/de...aspx?PageId=91
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,836
    I agree, VBA is easier to debug.

    However, if you must stay with macro, want to provide db for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    tanvi is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    100
    In my case, this error occurred while I was trying to use a macro in the "on click" button. One of my friend suggested me to convert the macro to vba code then I tried macro design ribbon in access 2010 which has a option convert to vba button. I did this and copied the code into my program and it worked!!

    Hope it will work for you also!!

  5. #5
    keen1598 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2013
    Posts
    2
    I figured it out...Somewhere in the Sharepoint List, there was a cell with a #Value Error. The cell was a formula calculated cell, and set to NotNull. Why it threw a 2950 I'll never know but once I corrected the cell the script worked.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    Thanks for posting back with your success and solution.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Replies: 4
    Last Post: 03-07-2013, 12:27 AM
  2. Access Error 2950! Help!
    By qwerty1 in forum Access
    Replies: 3
    Last Post: 09-06-2012, 11:35 AM
  3. Action Failed 2950
    By TracyBell in forum Access
    Replies: 1
    Last Post: 05-02-2011, 11:00 AM
  4. error 2950 out of the blue
    By kroenc17 in forum Access
    Replies: 1
    Last Post: 10-08-2010, 10:00 AM
  5. Action Failed -Error Number: 2950
    By Cindy in forum Access
    Replies: 5
    Last Post: 07-07-2010, 11:51 AM

Tags for this Thread

Posting Permissions

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