and then create a new record if one doesn't already exist. Or open the existing record if one already exists.
Hello. I would like to create a daily log database. It will be used by multiple people who work independently. I need to prevent them from creating multiple records for each day, one per user and/or per entry. There can only be one record per day, that everyone uses.
Ideally, I would like the command button that they click to enter the data to be able to check to see if a record in the table that holds this data already has a record with the current date in it. If the current date exists in the date field of that table. If a record that matches this exists, it will open the record and data can be entered. If not it will create a new record, and the current date will populate the field for that. And data will then be entered. It will also be available for additional entries throughout the day.
Is this possible in access?
I would like the most efficient way possible. The best I can come up with is a command that takes the current date and does a search through the table holding the data. If it finds a record with today's date you see it in the results. Then the result would be clicked on to open it and data would be entered. If nothing comes up, click on another command button to create a new record. But that would have to only be able to be executed if there is not a duplicate record.
Does this sound like a good way of doing it? Is there a better, more efficient way of doing it?
Thanks in advance!