1. open a record if it exists; otherwise add new record
2. Add new record to a log when existing records are modified?
This may be a simple thing, but I figgured I'd ask just
I have a database that I got from somewhere for managing
a DVD library. I've added a couple of things for keeping
track of what DVDs are loaned out, and who they're loaned
to. I have a special form that connects to teh main table
and allows you to check a disc out, and record the date
and who borrowed it. What I'm trying to do is, whenever I
use the 'loan a DVD' form, I want it to copy the info
that's in that record to another table (a log) and add
that info as a new record. This should be done on close
of the 'loan' form provided the "out on loan" check box
is checked (I obviously wouldn't want it to add the
record if I had opened the wrong record and never checked
the 'loaned' box). SO generaly, I think the logic I'm
looking for is some sort of 'on close, if 'Loaned'=yes,
copy the current record to new record in Log'
Any suggestions and directions MUCH appreciated. Thanks!
3. Access linked table - can add new records but can't update existing records
4. Update existing record else insert record if no record exists
5. Update Master records (swap / replace old record from new record) in two file
6. After Adding a New Record it remains the Last Record in Record
7. Trigger to update field in new record based on second field in new record.
8. Add new record from a form to a table, then record new ID
9. Default "add record" button edits current record, doesn't add new
10. Select Record in query, save as New Record then edit New Record
11. Add record but check for existing record first
12. Sharepoint linked table - can add records but can't update existing records
13. Allow new record entry but restrict editing of existing records in form controls
14. Import new records and update existing records
15. Edit Existing Records When Form Opens To A New Record