Solved

Add date/time not working how to fix

Posted on 2014-02-06
2
359 Views
Last Modified: 2014-02-19
Seems like the most simple thing but its not working in this database.  I need to be able for access to add the date and the time when I add the date to a field.  See the attached database.

It is on the notes table.  But it is added from the Contact Form under notes.  I need to add the date and have it add the time the date was added in that same field.   I know this is simple but for some reason it is not working.
1.accdb
0
Comment
Question by:lehi52
2 Comments
 
LVL 10

Accepted Solution

by:
Gozreh earned 500 total points
ID: 39839744
if you are looking for default current date and time, you can set the default to Now()
or if the user can edit the date field, you should add a new field "CreateDate" and set the default to Now()
0
 

Author Closing Comment

by:lehi52
ID: 39839789
Simple solution and it worked.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question