• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 448
  • Last Modified:

MSaccess input form question

Hi. I have an input form that asks for a date input. I want to make sure the date entered is a Monday always. What would be the best approach to this. Can I do this in the table as a check or in a form where the date is entered or in a vba function returning back to the form if there is an error? I assume I could use the following function?

DatePart ("w", StartDate)
0
PawloA
Asked:
PawloA
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
or use the weekday() function, or Format() and ask for the day spelled out, so you can check for "Mon" or "Monday"

Jim.
0
 
PawloAAuthor Commented:
Thanks. Weekday() worked for me.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now