Add New Record between two existing records

Add New Record between two existing records

Post by bGl6d » Wed, 16 Jan 2008 09:22:00

Hi, I am new to this Discussion Group. I am in need of some instructions and
hope that someone can help solve my problem/s.

1) I would like to add a record into my datasheet between two existing
2) How do you keep the ID #s in sequence?

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
the same...

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