Results 1 to 3 of 3
  1. #1
    apsf68 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Location
    Portugal
    Posts
    13

    Error - The expression On Open...

    Hi,

    I have a db that I'm using with MsAccess 2003, but now I need to work with it in Office 2010 too.
    When I open my db in 2010 it should display a switchboard with several menu options, but it gives me the attached error.
    If I choose another form for startup, I got the same error when click on any botton (on click expression).
    I really need to have it working with Office 2003 and 2007.

    Thanks in advanced for any help you can give me.

    Paulo Ferreira

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    * make sure your Trust Center is set up in 2010

    * you're currently using 03 - but I wonder if it was written in 03? or potentially 97?

    There is not usually any reason all buttons would not work. As a sanity check, add a new button using 03 that does something simple like open a form - and see if it works in 2010.

  3. #3
    apsf68 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Location
    Portugal
    Posts
    13
    Hi,

    Before I have your help, I have installed Access 2003 runtime, and it is working ok.
    I don't know if it is the right solution but now at least I have my db working.
    Anyway, thanks for your help.

    Paulo Ferreira

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

Similar Threads

  1. Error 3075 |1 In Query Expression '|2'
    By bishop in forum Access
    Replies: 3
    Last Post: 10-15-2011, 06:56 AM
  2. Expression Error
    By Tari in forum Forms
    Replies: 4
    Last Post: 03-08-2011, 09:18 PM
  3. syntax in query expression #ERROR help!
    By manos39 in forum Queries
    Replies: 1
    Last Post: 02-26-2011, 12:21 PM
  4. Error in query expression Date()
    By boywonder in forum Queries
    Replies: 15
    Last Post: 12-26-2010, 06:04 PM
  5. Syntax Error in Query Expression on filter
    By alaric01 in forum Forms
    Replies: 1
    Last Post: 10-14-2010, 07:23 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