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]