Results 1 to 4 of 4

Upgraded to 2010 now 2033 file erros out

  1. #1
    Angel J. Moreno is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    2

    Upgraded to 2010 now 2033 file erros out

    Ok I am kinda new to access but this is my situation , this is the error that is being created now, the blue line, it starts with a message



    Run-Time error '2456':
    Microsoft Access can't find the field 'Option7' referred to in your expression


    then asked to end or debug, when I debug this is what shows up,


    Else
    While (Not (rs.EOF))
    Me("Option" & rs![ItemNumber]).Visible = True
    Me("OptionLabel" & rs![ItemNumber]).Visible = True
    Me("OptionLabel" & rs![ItemNumber]).Caption = rs![ItemText]
    rs.MoveNext
    Wend
    End If

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,257
    Might be corruption issue.

    Have you run Compact & Repair?

    Try recreating the control.

    Try creating new form and copy/paste controls and code to the new form. Delete old form. Rename new form.

    Want to provide db for analysis? Follow instructions at bottom of my post.
    Last edited by June7; 09-29-2012 at 11:39 AM.
    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.

  3. #3
    Angel J. Moreno is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    2
    I am a bit concered about changing this file and breaking it worse. This is a file that many people use and I can't have it go down for any reason
    Right now if we click "End" it will pull up most of what is needed

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,257
    That's why you make backups. Is this a split design? Did you convert the file to 2010 format (accdb)? I can still review the db if you want to provide.

    Is there actually a control on the form named 'Option7'?
    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.

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

Similar Threads

  1. Access 2010 Executable file
    By Desstro in forum Access
    Replies: 1
    Last Post: 01-22-2014, 03:59 PM
  2. Replies: 4
    Last Post: 09-19-2012, 02:07 AM
  3. Open ddb file with Access 2010
    By whittij in forum Access
    Replies: 3
    Last Post: 09-12-2012, 11:03 AM
  4. Replies: 1
    Last Post: 03-29-2012, 12:20 AM
  5. How to import a .dta file into Access 2010?
    By Louie in forum Import/Export Data
    Replies: 4
    Last Post: 07-26-2011, 06:14 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
  •  
Tech Forums: Microsoft Office Forums