I just noticed that the order date has not been filled in on forms or reports. I've been checking all the tables connected to them all and I cannot seem to find a reason for it happening. I thought that if it is not showing up in the forms or reports then it has to be a problem with a table. Can this be corrected now without the need to delete forms and reports that are made? Thanks, Ken
Sami Shamma
@Reply 2 years ago
Ken
Does this happen in the downloaded database of this lesson? Or it is on the database working on?
Kenneth WykoffOP
@Reply 2 years ago
It happens when I make a new order where it doesn't fill in. However, I may have overlooked that I need to manually add the order date in when creating it. After I just now added it in manually, it does now show up on the reports. I may have just assumed that by having the format in the table for Date/Time as =Date(), may not add that automatically.
Sami Shamma
@Reply 2 years ago
If you want today's date to show for new records, you need to put Date() in the Default Value, not Format.
Kenneth WykoffOP
@Reply 2 years ago
Thanks Sami and that is on the OrderT if I am correct?
Sami Shamma
@Reply 2 years ago
Yes
Kenneth WykoffOP
@Reply 2 years ago
Thanks, Sami, It worked on a new record.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 9.
