Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    15

    Unanswered: Ms access 2003 - 2010

    Hey guys i had a database in access 2003 that had code that if you clicked on a checkbox a textbox forecolor and backcolor would change, Once the update happened this functionality went away... Any idea?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Two things come to mind!

    First off, does any VBA code run? Have you declared the Folder the Database resides in as 'Trusted?' To allow Code to run in 2007/2010 declare the Folder as trusted.

    To trust your Folder, click:
    1. Office Button (top left)
    2. Access Options (bottom of dialog)
    3. Trust Center (left)
    4. Trust Center Settings (button)
    5. Trusted Locations (left)
    6. Add new location (button)


    Secondly, when apps run fine on one machine and not on another, or run fine in one version and not when run under a newer version, you also have to think about are missing references.

    If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

    Access Reference Problems

    Could be one or the other, or both of these!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •