Search results

Hi all, I would like to populate the age of a person in an unbound control in an access form (also a query) by comparing Now to dob. I can calculate full years or full + partial years in decimal format. I'm wondering if anyone has a tip on how I could produce a result of a full year if over 2...

Hi all, I apologize if this has been asked and answered but I have put an honest effort in to find an answer with no luck. I'm trying to run a query and return records for all "incidents", even when some fields I am interested in are blank (actually a record does not exist). In this specific...

Hi all, I am trying, and failing, to think of a good way of ensuring that an entry is made into a subform before the user is allowed to move to another record, create a new record, or save the existing record. I've tried simply adding some code to the on click event of a Save/Refresh Control...

Hi all, I am trying to automatically populate the first part of an Incident_ID field with the date of the incident. The kicker is that the date is entered DD/MM/YYYY, and I'd like the ID to start with YYYYDDMM_ (reversed and no slashes with underscore added) and then have the user add a...

Hi all, I'm not a power user of Access but I'm trying to accomplish something that seems easy in my mind but can't quite get it done. I have a main form that has all of the main particulars of an 'enforcement incident'. I also have a subform that shows all of the incidents at once that I've...