AboutJulie Misson Expertise My area of expertise is Microsoft Access 2000. I have been building microsoft databases for the past three years. I would be competent in answering questions from novice Access 2000 users. I have some experience SQL and normalisation.
Experience I have built database for the health industry. These are usually one off designs to collect data, which there is no off the shelf software avaliable. I also teach Microsft Access to beginners.
Question I've been told that ACCESS 2003 can be programmed to pop up a reminder when a certain deadline is coming. How would I tell ACCESS to display two fields (First and Last names) for records that are "No" in a certain "Yes/No" field?
Answer Paul,
Many thanks for the question.
Not sure if I have enough information, but I will give it a go.
Create a report based on a query with the required fields, i.e. LastName, FirstName and YesNoField (and any others), in the criteria row for the YesNoFiled type 0
Create a new Macro called AutoExec, this Macro because of the name will run automatically when the database is opened. Under the Action section, choose 'Open report' from the drop down list. Then at the bottom of the Macro complete the properties as needed, including the name of the report you wish to open.
Not sure if this is what you are looking for, but it may help to point you in the right direction.
