In need of an update, but, take a look at this
http://www.pitonyak.org/database/AndrewBase.odt
On 08/08/2010 01:48 AM, R C wrote:
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]
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
