I am trying to use base... I am pretty new to OpenOffice, so I know that there is a lot that I need to learn but at this point I don't think I am looking for material at the right place so if anyone could shine a light on the following:
1. I am creating a database, and my goal was to have my form able to recall information from the previous record and also able to overwrite information by prompting an input box (through a push button)...
Since base is kinda straight forward it was easy to use wizard to set up my table and getting to view mode to edit stuff. My first step was to create the push button and set the execute event to a macro which so far is
Code: Select all
option explicit
sub changeemployee
dim operator$
operator = inputbox ("Insert your initials","") 'creating dialog box so employee can change initials
Code: Select all
sub learning_how ()
dim oDoc as object
dim oDrawpage as object
dim oform as object
oDoc = thisComponent
oDrawpage = oDoc.drawpage
oform = oDoc.forms.getByName("SCAN UDI")
oform.table("initials").value=operator.value 'where initials is the name of my column in the table
end sub
I also realized that if I want to copy or recall information from my previous record I will need to know how to call that information in particular, but I am not familiar with all the inputs and weird line calls (aka sun.bean.whatever whatever or $c10 for jumping lines). I don't mind have to learn all this material, but so far I can't find a lot of information that can be related to base specifically. I found a bible regarding macros by Andrew Pitonyak which did teach me a few things, but I think at this point my problem might be the language itself, so if anyone has a good tutorial on basic that is not for calc please send it my way
I believe I absolutely need to use macro for this but if I am wrong I will take the easier way
2. I have a serial number that is a autofil field, and I was wondering if instead of displaying "autofill" I could have it display the actual number?
Either way, I appreciate any help.