Ask Your Question

how to connection to a base

asked 2018-03-03 09:55:50 +0200

taifatul gravatar image

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

edit retag flag offensive close merge delete



@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.

Ratslinger gravatar imageRatslinger ( 2018-03-03 14:40:09 +0200 )edit

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

taifatul gravatar imagetaifatul ( 2018-03-04 20:20:29 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-03-04 21:14:49 +0200

Ratslinger gravatar image


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.

edit flag offensive delete link more


Thank You!!!

And how on python to write macros?

taifatul gravatar imagetaifatul ( 2018-03-06 17:14:23 +0200 )edit

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 ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Ratslinger gravatar imageRatslinger ( 2018-03-06 20:53:37 +0200 )edit

answered 2018-03-04 20:18:07 +0200

taifatul gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-03 09:55:50 +0200

Seen: 188 times

Last updated: Mar 04 '18