Results 1 to 7 of 7
  1. #1
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43

    help to input data


    Hello guys!
    How can I put in "date_to" columns, in fields that are empty, to enter current date date (), and to keep dates in other fields as I entered it.
    Attached Thumbnails Attached Thumbnails Slika access.PNG  

  2. #2
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Use an Update query , something like

    Code:
    UPDATE YourTableName  SET [date_to] = Date() WHERE [date_to] Is Null
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    I do not know why, but it does not work for me. Is this possible to resolve within the table?

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Is this possible to resolve within the table?
    Sure, if you want to edit each one manually, but I don't think that is what you are after!

    Minty's solution worked for me. It is pretty straightforward and the standard way of updating mass data in Access.

    What is the name of your table?
    Is your "date_to" of the "Date" data type, or is it really text?

    Try creating this Update Query manually.
    First, create a simple Select query where you select all records where your "date_to" field is empty (IS NULL).
    Once you get that to work, then change the Query type to "Update" and add Date() to the "Update" line of the "date_to" field in the Query Builder.
    Then run.

  5. #5
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Here it is, thank you very much

  6. #6
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    yet, whether a query will run by himself or I have to start it every day.

  7. #7
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    yet, whether a query will run by himself or I have to start it every day.
    Either or.

    You can schedule it to run at a certain time (through a Scheduler) or perhaps have it run whenever the database is opened (if there is nothing to update, no harm done).
    You can do that by calling the Query to run in Macro and name the Macro "AutoExec".

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

Similar Threads

  1. I need help with data input
    By ngluvakov in forum Database Design
    Replies: 5
    Last Post: 08-31-2017, 02:13 PM
  2. Data Input to Queries
    By Luvflt in forum Queries
    Replies: 4
    Last Post: 08-20-2015, 01:13 PM
  3. Replies: 3
    Last Post: 01-05-2015, 02:21 PM
  4. Data Type to input data number
    By TioAdjie in forum Access
    Replies: 5
    Last Post: 02-17-2014, 11:21 AM
  5. Replies: 3
    Last Post: 08-07-2013, 06: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