Results 1 to 4 of 4
  1. #1
    farhanahmed is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    9

    Aslways show Current Date even in Old records

    How show current date even in old records daily.

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    705
    You could use Date()
    Boyd Trimmell aka Hitechcoach
    Database Architect and Problem Solver
    Microsoft MVP - Access Expert
    25+ years specializing in Accounting, Inventory, and CRM systems
    "If technology doesn't work for people, then it doesn't work."

  3. #3
    farhanahmed is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    9

    but not in old record work in this fuction

    this function work in new records but not in old records

  4. #4
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    705
    How show current date even in old records daily.
    Placing an unbound text box control onm a form with teh countsurec set to = Date() will show the current date for all records.

    If that is not what you want then please be very detailed in exactly with you want.

    Note: Unfortunately my crystal ball is offline.

    PS: You will get better response if you don't make it a guessing game.
    Boyd Trimmell aka Hitechcoach
    Database Architect and Problem Solver
    Microsoft MVP - Access Expert
    25+ years specializing in Accounting, Inventory, and CRM systems
    "If technology doesn't work for people, then it doesn't work."

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

Similar Threads

  1. Show current Time
    By dada in forum Programming
    Replies: 5
    Last Post: 05-03-2012, 04:32 AM
  2. Show only current record in report from form/subform
    By stelioshania in forum Reports
    Replies: 0
    Last Post: 03-02-2011, 02:19 PM
  3. SQL Inner Join where date = current date
    By Tyork in forum Queries
    Replies: 2
    Last Post: 11-07-2010, 02:07 PM
  4. Replies: 9
    Last Post: 03-19-2010, 10:37 AM
  5. VB coding to show current date n time in access form
    By cwwaicw311 in forum Programming
    Replies: 6
    Last Post: 02-10-2010, 09:53 PM

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