Search results

I agree...I think the table field should be defined as date. If it were, woudl the date edit wotk on the form?

Being new to Access, how do you define the field as a date field? What I have now is in the properties, the format is short date, under the data tab, the control source is the table column name (which is defined as text on the table)

I have a form where I enter a date. I am using an input mask of 99/99/0000;0;_ The data type on the table is short date. It allows me to enter any numbers in this format, but I want to perform a date edit to ensure the value entered is a valid date. Is there a way to do this via form properties?

I am new to Access and trying to figure out why a form has the ">*" button disabled so that new records can not be added via the form. I would like to change the form to allow adding new records. What property do I change to activate the ">*" button? I looked and the form property data tab has...

I want to be able to execute specific queries based upon which fields in the form have data in them. Assume I have 3 fields - WR nbr, Topic, & date. If I fill in a WR nbr & date I want to look up that WR for that date. If I fill in a Topic & date, I want to look up that topic for that date. If...