Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Denver, Colorado, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shortcut key for date (2000)

    I have a database that I have put together. I loaded the database on two different computers. One of the computers does not allow the cntl-; shortcut key for entering today's date in a date field. The other allows it. Both computers allow this shortcut key in Excel, but the one refuses to acknowledge it in Access. I get a box that says" The expression you entered has a function name that Microsoft Access can't find" when it refuses to allow the shortcut. Is there some kind of global setting on the computer itself that is jamming me up? All help is gratefully accepted.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shortcut key for date (2000)

    Maybe the computers have different versions of some library. You can try the following on the computer where Ctrl+; doesn't work:

    <UL><LI>If the database contains modules, open any of them. If not, activate the Visual Basic Editor (Alt+F11) and select Insert/Module (you can close this module later without saving).
    <LI>Select Tools/References...
    <LI>If there is a reference starting with MISSING, uncheck the box to the left of it and click OK. Close the module (without saving), and switch back to Access. Then try Ctrl+; again in a table, query or form.
    <LI>If there is no reference starting with MISSING, select each of the checked references in turn and write down the name of the reference and the path+filename that appears below the list. Do the same on the computer where Ctrl+; works and see if there are differences. If you find any, post the details here.[/list]HTH,
    Hans

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut key for date (2000)

    Input masks can also prevent from entering the date with ctrl+; if the international settings of windows have different settings of the input mask
    Francois

  4. #4
    New Lounger
    Join Date
    Aug 2002
    Location
    Denver, Colorado, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut key for date (2000)

    Thanks so much for the reply. Sure enough there was a MISSING reference. Once I removed the check the date shortcut key worked perfectly.

    Appreciate the help.
    Marc in the dark

Posting Permissions

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