Results 1 to 8 of 8
  1. #1
    ppiper is offline Novice
    Windows XP Access 97
    Join Date
    Dec 2010
    Posts
    7

    My button targets a table that isnt there

    Hi
    I am having trouble with my button it is targeting a table that is not there and I cant find where to change it.(when you get to add new entry a new number should be added)
    any help welcome.
    database attatched


    Thanks
    Peter

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    The code behind the button calls a function named "NewCustID()". The non-existent table appears to be referred to there (tblPracticeEmployeeData).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    ppiper is offline Novice
    Windows XP Access 97
    Join Date
    Dec 2010
    Posts
    7
    Hi Paul,
    How do I change that to tblVisites.
    Thanks
    Peter

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Change "tblPracticeEmployeeData" to "tblVisites".
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    ppiper is offline Novice
    Windows XP Access 97
    Join Date
    Dec 2010
    Posts
    7
    Hi Paul
    I dont have that table where is it named
    thanks
    Peter

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Like I said, in the function. See attached.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    ppiper is offline Novice
    Windows XP Access 97
    Join Date
    Dec 2010
    Posts
    7

    Solved

    Hi Paul,
    Problem resolved. Thanks for your help
    Peter

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Happy to help Peter.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 10-28-2010, 07:02 AM
  2. Delete button with archive Table
    By tlyons in forum Forms
    Replies: 4
    Last Post: 07-08-2010, 12:18 PM
  3. program find button to search whole table
    By sammer021486 in forum Programming
    Replies: 2
    Last Post: 10-01-2009, 06:36 AM
  4. report to compare projects' targets
    By Arest in forum Reports
    Replies: 0
    Last Post: 07-29-2009, 09:04 AM
  5. Combo Box isnt saving
    By calisen in forum Access
    Replies: 0
    Last Post: 09-11-2008, 03:34 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