Access updating records
Issue Book – To enter the details about the books issued.This form has a lookup field “Book Name” which imports the Books from the above form.Today we’re going to take the next logical step and show you how you can add records to an Access database.And then, just for the heck of it, we’ll take step and show you how to modify existing records as well.The record fetched is stored in the collection variable named my Book.You can now access any field in this record, from the my Book variable and update the value.
We’ll post new tips every Thursday; to see an archive of previous tips, visit the Office Space Archive.And if you have particular questions about Microsoft Office scripting, feel free to send them to [email protected](in English, if possible).We can’t promise to answer all the questions we receive, but we’ll do our best.We’ve decided to let you in on a little secret: the Scripting Guys (unlike the rest of you, of course) have their good days and their bad days.
Some days we come in excited and ready to work; other days (well, OK, column, supposed to know whether you’ve hit the Scripting Guys on a good day or a bad day?When a Book is issued, the status of the Book is updated from “Available” to “Issued” in the Books form. In the Books form, the Status of these books will be set to “Issued”.