It seems that one cannot record macros in the OO database.

I am doing a project for my Church's library. In my database (library.odb) I have a button in the form portion that I linked to a macro. -- a dummy marco that has Msgbox line. I am not sure how to program VB (I program in other languages, but not VB) so that my macro does the following:

Uses current record of table library with fields Title, Author, Name, DateCheckOut Adds a new record to table history with fields Title, Author, Name, DateCheckOut, DateReturn Clears the fields Name and DateCheckOut in the current record of table library
            history.Title =  library.Title
            history.Author =  library.Author
            ....
            history.DateReturn = TODAY()
            library.Name=""
            library.DataCheckOut=""
            update both tables -- have changes accepted and written

Does any one know how I can get VB commands needed to do the above? I know how to put the lines in my macro; I just don't know what the lines should be to open the tables, fill a new record, and to close the tables with the updates taken into affect.

Thanks,

Ron



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to