locked
Hold date in frontend of database RRS feed

  • Question

  • Is it possible that when I click on my control todays date (and stays that date) is entered somewhere in my frontend, not my backend, so I can access it without it being stored in the backend, a security issue , Thanks for any help.......Bob
    Wednesday, October 8, 2014 1:18 AM

Answers

  • Create table with 2 fields -- RecCount (Number) and MyDate (DateTime).  In a form put text box with record source query with criteria for RecCount = 1.  Use double click event to set MyDate = Date().

    Build a little, test a little


    Wednesday, October 8, 2014 1:45 AM
  • The Date() function will always return today's date and can be used anywhere. Why would you need to store it somewhere just to access it?
    Wednesday, October 8, 2014 12:43 PM

All replies

  • Create table with 2 fields -- RecCount (Number) and MyDate (DateTime).  In a form put text box with record source query with criteria for RecCount = 1.  Use double click event to set MyDate = Date().

    Build a little, test a little


    Wednesday, October 8, 2014 1:45 AM
  • The Date() function will always return today's date and can be used anywhere. Why would you need to store it somewhere just to access it?
    Wednesday, October 8, 2014 12:43 PM