Results 1 to 2 of 2
  1. #1
    sneuberg is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2014
    Posts
    23

    Access 2013 Form TextBoxes with functions not calculating

    Our textboxes which have functions such as Count, Dcount, CurrentUser stop working from time to time. When they don’t’ work, none of them work; they don't work on any of the forms in the system. Clicking on the textbox or pressing F9 will cause the data to be shown for the current record. This issue was discussed on the Stackoverflow forum about a year ago and was left with the suggested workaround:

    Private Sub Form_Activate()

    Me.SetFocus
    SendKeys "{F9}"



    End Sub


    This seems to work, but somehow this just doesn't look robust to me. Is this workaround ok? Can anyone suggest a better fix? Anyone know why this is happening?

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    This problem has been recognized for quite a while, now, and the cause, amazingly, has been found to be PCs that are left up and running for extended periods of time! Doing a cold reboot always seems to solve the problem, but there reportedly has been a hotfix issued by Microsoft. Running v2007, I have no need for it ans so don't have a download link.

    An no, the workaround really isn't 'OK;' using SendKeys has always been problematic, and even more so with later versions! Since Access 2007, unless a previous version of Access is also installed on a machine, the use of Sendkeys may fail, with the important word being may; sometimes it works and sometimes it doesn't!

    Linq ;0)>

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

Similar Threads

  1. Replies: 6
    Last Post: 11-05-2015, 06:14 AM
  2. PDF File content display on Access 2013 form
    By saleemsadique in forum Access
    Replies: 7
    Last Post: 02-07-2014, 06:36 PM
  3. Outlook 2013 + Access 2013 + HTML
    By Yann63 in forum Programming
    Replies: 2
    Last Post: 11-26-2013, 02:39 PM
  4. Access 2013 display of Form View
    By iball1113 in forum Access
    Replies: 9
    Last Post: 11-08-2013, 03:30 PM
  5. Access 2013 Web App with Sharepoint 2013
    By miguel.escobar in forum Access
    Replies: 7
    Last Post: 06-17-2013, 09:03 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