How to connection to a base

Error #1501 (No active connection to a database found) occurred in a call to function ‘AllForms’

@taifatul Please provide some basic information - OS, LO version used, under what circumstance this error occurs, what DB are you using, what are you trying to do.

I just want to create a database in the Libre Office of table forms and use the controls in forms

error.jpg

Hello,

Your image shows you coding a macro. This is not the way to start. The LO Base documentation has many step-by-step examples on creating tables and controls on forms (docs located here). Look further down the post and you will find “How-tos and Tutorials”.

Much of Base does not require the use of macros (your image post). Learning SQL in addition to tables and forms will allow you to perform most tasks.

Seems where you are at is not connecting to a database but rather creating one first. Please view some of the referenced information.

Please feel free to ask specific questions on the forum in future. Someone is typically around to help with the specifics.

Thank You!!!

And how on python to write macros?

There is too much to discuss without specifics. Here are some links to start you out:

Designing & Developing Python Applications

Transfer from Basic to Python

Python and OpenOffice

If this answers your question please tick the :heavy_check_mark: (upper left area of answer). It helps others to know there was an accepted answer.