Results 1 to 4 of 4
  1. #1
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108

    Error opening main table with button


    Hello,
    I am working on a split database and after my last "update" I get an error when I try to open my main table using a button. there is no query or anything, it just opens the main table and I get the following error:

    Click image for larger version. 

Name:	error.jpg 
Views:	12 
Size:	11.5 KB 
ID:	24837

    The problem is, I don't have a "StartDate" field in the table.. I did find that I had a few captions called "start date" but I fixed those and I still get this error... below is how the button is coded:

    Click image for larger version. 

Name:	query.jpg 
Views:	12 
Size:	28.8 KB 
ID:	24838

    The thing that gets me is that I can go back through all my old frontends, and they are all still linked to the same backend that my last update and current update are linked to but they will open it just fine...

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Since it is linked, have you tried using the Linked Table manager to re-link it?

  3. #3
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    hummm... this is interesting... I have a copy of the current backend I use for my tests, I have tried switching between my test and the live backend and it was still erroring out. So I tried linking it to an old backend from my older updates and then linked it back to the live backend and it worked... thanks RuralGuy!!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    You're very welcome. Glad we could help.

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

Similar Threads

  1. Opening main form after viewing a report.
    By Robert2150 in forum Access
    Replies: 13
    Last Post: 05-26-2015, 10:03 AM
  2. Replies: 4
    Last Post: 08-26-2014, 09:29 AM
  3. Replies: 3
    Last Post: 07-13-2011, 02:04 PM
  4. opening a second form from main/subform
    By PJPCVP in forum Database Design
    Replies: 1
    Last Post: 10-29-2010, 09:50 PM
  5. Replies: 2
    Last Post: 12-19-2009, 09:38 AM

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