Results 1 to 13 of 13
  1. #1
    Join Date
    Aug 2008
    Posts
    4

    Unanswered: Everything is greyed out, no datasheet view

    I have a problem with a database. I am a newbie to MS Access. There is a problem with the form (On Timer) but I can't get to any options (datasheet view, pivot table) since they are all greyed out. A friend wrote the database years ago and I can't get in touch with him. Any ideas?

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    Try opening the db while holding down a <SHIFT> key. Keep the <SHIFT> key down until the db is completely open.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    When I see Everything is greyed out the first thing that comes to mind is that you're dealing with an MDE file! Is the file's extension MDB or MDE?
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Aug 2008
    Posts
    4
    Awesome. Now I can see something. I can see all of the tables along the side. The one that keep failing is called "MessageTable". When I try to open the design view, I get the message that I musty open the source database to make changes. I think I am making progress though, thanks a lot!

  5. #5
    Join Date
    Aug 2008
    Posts
    4
    I have an MDE and a MDB version, they both do the same thing. The error I get is the "expression On Timer you entered as the event property setting produced the following error:Function is not available in expressions in the query expression"(((MessageTable.DATE)=Date()))"".

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by mcarpent
    The error I get is the "expression On Timer you entered as the event property setting produced the following error:Function is not available in expressions in the query expression"(((MessageTable.DATE)=Date()))"".
    Try changing the expression to MessageTable.[DATE]=Date()
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You should never, never, never give a field the name Date! It's a reserved word, and a dangerous one to mess with. HAving a control with this name almost always causes problems. Rename this field to something else and see what happens. I'm not sure that this is all of what's going on, but you absolutely must change this.
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    That's a tad overstated.

    Yes, it's a reserved word and can cause some minor errors when referenced incorrectly, but having a field called Date is not dangerous. Nor would I say you "absolutely must" change it... you just need to make sure you refer to it as [Date] rather than Date everywhere you can and you'll avoid all problems.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Cobmining Missinglinq and StarTrekker's advice, "You really should change it, but if you can't or for some reason don't want to, you need to abide by the rules that StartTrekker stated, otherwise you can spend many hours trying to troubleshoot a missing simple [] problem."

    I'd personally change it though just to avoid any future headaches (and never name it that way again.) See the MSAcess Reserved Words list.
    Last edited by pkstormy; 08-25-08 at 02:25.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  10. #10
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Starrekker is correct, you don't need to change it (or any other reserved words), especaily if you want an excitign life tryong to resolve subtle errors, if you want to have problems in code between MDB & MDE, and you want to have problems beween Access and the default data store JET.

    look up a copy of the Access reserved words on t'net and make sure you don't use any of them.
    I'd rather be riding on the Tiger 800 or the Norton

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Star "Rekker"?? ^_^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  12. #12
    Join Date
    Aug 2008
    Posts
    4
    Thanks guys. You have all been a big help.

  13. #13
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're welcome
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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