Thank you! I've spent days, googling, reading documentation, experimenting, all to no avail. I was at the edge of giving up and coding the thing in Java or Scala instead. Your video is very clear, and makes it look easy. Thank you very much!
I have not seen the tabbed feature on Libreoffice Base. I too would like to see this. If you are talking about styling the a sub form box I would say head in to the general property settings and take a look at the first boxes then match the sub form text boxes with the same settings.
Sorry Ian, the videos I post on here are for a hobby, I have other commitments at the moment, like decorating my house and scaling a large project at work for redevelopment of an ordering process. I will take some time out this evening to look at your query. Aplogises for the delay in answering your query.
For the Second question you can write a filter to work with your button to only pull in data for the selected member. Make sure that you use the ID - primary key associated with the member for an accurate filter to work.
Yes it can be done. You need to read up on the One to Many rule. There are many ways about going about your database design. The simplest design would be to have an extra field in your company table which links back to the main company of the sub branch. You can use the same table more than once in a form, sub form. To make it easier to understand I will do a video.
Awesome i now can add all the subforms and their text boxes. Have a few questions though can you make the subforms into a tabbed setup so you have pages IE first page would have name next page would have addresses and last would have job titles? also how do you make the text boxes match what the first boxes look like? Love your videos make it verry ease for the novice
Thanks Shane I understand it's a busy time of the year!! My LO Base is 3.6.2.2; MySQL is 5.1.55; My OpSys is PCLinuxOS 2012 and my eMail Client is Thunderbird. Regarding the second question can you just tell me how to get the SQL to read the content of a given Text Box on my Form. After that I think I will be OK.
First, I did not find the icon 'form navigator'. I found it in the Customize Toolbars menu option. Once this icon's there, it works very well. Thanks a lot ! :):):)
thank you very interesting and informative, I'm trying to create an invoice database, and I have companies that are used on multipul invoices and they have different branches. I want to create a form with sub forms that work as (drop down selecting company, then dropdown selecting branch) that getis saved in the invoice details table. Can it be done and does my question make sense? kindest regards David
Hi Shane Thanks for the great help via your videos on LO Base. But I do have a couple of questions. What is the best way to contact you - eMail, FB, Skype etc?? (I live in South Africa)
What if you wanted the subforms to show as grids such that you could have the customer information as the main form and then two grids as the subforms where you could scroll to the entries in each subform that is relevant for the customer?
Hehe Fred Flinstone is an IT manager; he's moving up in the world from a rock crusher LOL Thanks for another "great but simple" tutorial! I was wondering if you might be able to clear something up for me. What's the difference between "setting a relationship" & "linking" between two or more tables?
You will need to write some basic code (macro) and apply it to the button, I am currently working on another project at the moment, but I wlll take a look this evening and get back to you. To open another form using a button the code would be something like this; ThisDatabaseDocument.NewForm.getByName("MyForm").open I will so a short demostration of how to apply a filter to a button this evening.
Hi Shane, do you know where one can find a decent LO Basic reference? Had one hell of a time trying to get the macro buttons to work. Also, have you perhaps any experience using LO Base with Postgres? I'm having difficulty getting forms to work. Thanks again fro your great videos.
I use references from the openoffice forum to get my LO Base basic knowledge. It would be nice if someone had written a reference book for all this stuff. As for Postgresql check out ask libreoffice ask.libreoffice.org/en/question/18554/how-to-connect-base-to-to-postgresql/
Thanks for this tutorial. I am new to Base, I have used Access years ago but I am finding Base daunting to deal with. I have set up all the tables, which was straight forward but I can't do anything with the forms module, It certainly doesn't look like yours. Everything is grayed out and there is no way to add table fields to the blank form. Even if I start with form wizard and one table, I still have no way of adding table fields from a linked table. If I start form creation again and select to include a sub form, it doesn't allow me to use the relationships I have already set up, grayed out. I may go back to Access, where form creation is simple.
@@shanepiper Thanks for your reply, I am using Version: 6.4.5.2 (x64). I have managed to find these tools now and have got a bit further in to it. I just have a bit to learn with it I guess and will persevere.
HI Shane, How can I create a document (receipt) database where I can view all my collected receipts from different merchants and more importantly, multiple receipts from the same merchant? For example, if I buy many items from one store at different times, how can I make an effective record of such without having to enter a new table row each time I obtain a new receipt? I'm new to this and for years now have not had any success in anyone being able to explain this .
You can do this but designing a One to Many database. Example of this is here in the above video. Everytime you get a new receipt first select merchant, then add receipt details in a new record in a linked sub form.
hey how to create a form a with subform using the invoice,iteminvoice and product,the subform will use invoice ID,product ID and Quantity from Iteminvoice and Unitprice from the products table.
Hi, I would like to have two or more subforms in a Main form and subforms would be hidden or visible based on button ....so. If I click on ADDRESS Button then Subform shows to input address info if I Click on NOTES Button then subform shows to input all notes ...Hope you get the idea.....Can you please tell me where to find Macro code to Hide/Show form or fields Thanks in advance
Thank you! I've spent days, googling, reading documentation, experimenting, all to no avail. I was at the edge of giving up and coding the thing in Java or Scala instead.
Your video is very clear, and makes it look easy. Thank you very much!
This tutorial is over a decade old.
after 2 weeks of searching, this gave me the solution.
So glad this relic is still helping people today 😊
Email is the best way. I am glad you like the video. I will be happy to assist you.
I have not seen the tabbed feature on Libreoffice Base. I too would like to see this.
If you are talking about styling the a sub form box I would say head in to the general property settings and take a look at the first boxes then match the sub form text boxes with the same settings.
I am using OpenOffice, and this was very helpful! Thank you!
Sorry Ian, the videos I post on here are for a hobby, I have other commitments at the moment, like decorating my house and scaling a large project at work for redevelopment of an ordering process. I will take some time out this evening to look at your query.
Aplogises for the delay in answering your query.
For the Second question you can write a filter to work with your button to only pull in data for the selected member. Make sure that you use the ID - primary key associated with the member for an accurate filter to work.
Yes it can be done. You need to read up on the One to Many rule. There are many ways about going about your database design. The simplest design would be to have an extra field in your company table which links back to the main company of the sub branch. You can use the same table more than once in a form, sub form. To make it easier to understand I will do a video.
Awesome i now can add all the subforms and their text boxes. Have a few questions though can you make the subforms into a tabbed setup so you have pages IE first page would have name next page would have addresses and last would have job titles? also how do you make the text boxes match what the first boxes look like?
Love your videos make it verry ease for the novice
Thanks Shane
I understand it's a busy time of the year!!
My LO Base is 3.6.2.2; MySQL is 5.1.55; My OpSys is PCLinuxOS 2012 and my eMail Client is Thunderbird.
Regarding the second question can you just tell me how to get the SQL to read the content of a given Text Box on my Form. After that I think I will be OK.
Really appreciate your work, Many Thanks!
First, I did not find the icon 'form navigator'. I found it in the
Customize Toolbars menu option.
Once this icon's there, it works very well.
Thanks a lot ! :):):)
What operating system do you have, which email client do you use and what is the version of mySQL?
thank you very interesting and informative,
I'm trying to create an invoice database, and I have companies that are used on multipul invoices and they have different branches. I want to create a form with sub forms that work as (drop down selecting company, then dropdown selecting branch) that getis saved in the invoice details table.
Can it be done and does my question make sense?
kindest regards
David
Thanks for the video - very helpful. Really!
Your welcome, so glad a video I did years ago is still helping 😁
Hi Shane
Thanks for the great help via your videos on LO Base. But I do have a couple of questions. What is the best way to contact you - eMail, FB, Skype etc??
(I live in South Africa)
What if you wanted the subforms to show as grids such that you could have the customer information as the main form and then two grids as the subforms where you could scroll to the entries in each subform that is relevant for the customer?
Hehe Fred Flinstone is an IT manager; he's moving up in the world from a rock crusher LOL Thanks for another "great but simple" tutorial!
I was wondering if you might be able to clear something up for me. What's the difference between "setting a relationship" & "linking" between two or more tables?
can you do a lesson on how to link fields or tables in relationships?
You will need to write some basic code (macro) and apply it to the button, I am currently working on another project at the moment, but I wlll take a look this evening and get back to you.
To open another form using a button the code would be something like this;
ThisDatabaseDocument.NewForm.getByName("MyForm").open
I will so a short demostration of how to apply a filter to a button this evening.
Depois dele pronto como faço para torná-lo o base em executável ?
Hi Shane, do you know where one can find a decent LO Basic reference? Had one hell of a time trying to get the macro buttons to work.
Also, have you perhaps any experience using LO Base with Postgres? I'm having difficulty getting forms to work.
Thanks again fro your great videos.
I use references from the openoffice forum to get my LO Base basic knowledge. It would be nice if someone had written a reference book for all this stuff.
As for Postgresql check out ask libreoffice ask.libreoffice.org/en/question/18554/how-to-connect-base-to-to-postgresql/
Thanks, Shane!
Thanks for this tutorial. I am new to Base, I have used Access years ago but I am finding Base daunting to deal with. I have set up all the tables, which was straight forward but I can't do anything with the forms module, It certainly doesn't look like yours. Everything is grayed out and there is no way to add table fields to the blank form. Even if I start with form wizard and one table, I still have no way of adding table fields from a linked table. If I start form creation again and select to include a sub form, it doesn't allow me to use the relationships I have already set up, grayed out. I may go back to Access, where form creation is simple.
Please bear in mind that in order to use base you need to have Java installed... Which version of libreoffice do you have and on what OS?
@@shanepiper Thanks for your reply, I am using Version: 6.4.5.2 (x64). I have managed to find these tools now and have got a bit further in to it. I just have a bit to learn with it I guess and will persevere.
@@ckelin13 you just need to start with a clear mind and do assume Base is like Access.
HI Shane, How can I create a document (receipt) database where I can view all my collected receipts from different merchants and more importantly, multiple receipts from the same merchant? For example, if I buy many items from one store at different times, how can I make an effective record of such without having to enter a new table row each time I obtain a new receipt? I'm new to this and for years now have not had any success in anyone being able to explain this .
You can do this but designing a One to Many database. Example of this is here in the above video. Everytime you get a new receipt first select merchant, then add receipt details in a new record in a linked sub form.
How would you create multiple job positions for a single custID?
I would suggest setting up a one to many list to allow for multiple job selections
hey how to create a form a with subform using the invoice,iteminvoice and product,the subform will use invoice ID,product ID and Quantity from Iteminvoice and Unitprice from the products table.
Yes I can do a lesson on relationships
Thanks man!!
great! thanks a lot.
how could i do this in access? is it opssible?
Thank you a lot!!!!!!!!!!!!!!!!!!!!!!
Hi,
I would like to have two or more subforms in a Main form and subforms would be hidden or visible based on button ....so.
If I click on ADDRESS Button then Subform shows to input address info
if I Click on NOTES Button then subform shows to input all notes
...Hope you get the idea.....Can you please tell me where to find Macro code to Hide/Show form or fields
Thanks in advance
Mohammed Quayyum You will be good to find this information on the openoffice forums there is a lot of marco information there to assist your request.
Shane
Are you available or away?? I posted back to you some days ago (see below) and would like to get your reply ASAP!!
Thanks
Thank you
please use a noise filter next time. That only takes about 5 minutes and improves audio quality immensely.