Results 1 to 2 of 2
  1. #1
    NVRensburg is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    7

    Date problem when trying to modify an entry


    HI there

    I have an Access database which was designed by someone else. Does anyone know why i wouldn't be able to change an entry if it's not in the same month. i.e. if an entry was created last month and I go to try and change it now it won't allow me, i'd have to go and change the date on my PC to any day in February and then I'd be able to change details in it.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    why? ...that would be an arbitrary management/design decision.....

    in the text box control or possibly the command button if one is involved there are Events i.e. AfterUpdate, BeforeUpdate, OnExit, OnClick - in one of those events there is VB code affecting the edit-ability of the field....it could potentially be in the overall form's event such as OnCurrent.....

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

Similar Threads

  1. Replies: 4
    Last Post: 02-11-2015, 11:53 AM
  2. Replies: 1
    Last Post: 01-18-2014, 08:33 PM
  3. create and last modify date & time for record
    By msasan1367 in forum Access
    Replies: 5
    Last Post: 04-04-2013, 01:54 AM
  4. last entry in a field(Max) problem
    By Sulaiman in forum Queries
    Replies: 5
    Last Post: 07-25-2012, 06:50 AM
  5. Replies: 2
    Last Post: 02-20-2010, 01:11 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