Ask Your Question

Missing macros

asked 2019-06-25 18:24:59 +0100

dougmn gravatar image

On some of the forms in my database, I have a macro which causes the form to go to a new record when opened, and now I am getting error messages that the script could not be found.

I had not opened the database for a few months. Why is this happening when I open it now? How can I fix it?

image description

edit retag flag offensive close merge delete


Version: Build ID: libreoffice- CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded

dougmn gravatar imagedougmn ( 2019-06-25 18:25:48 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-06-25 19:59:52 +0100

Ratslinger gravatar image


The macros you are pointing to reside in the User Profile (see-> LibreOffice user profile). They should be located in the basic sub-folder.

If not there hopefully you have a backup of the user profile. Don't have any other recovery options.

edit flag offensive delete link more


Also just noticed you are using a Snap version. I don't use this but may have something to do with a new user profile for each version.

Ratslinger gravatar imageRatslinger ( 2019-06-25 20:10:07 +0100 )edit

It was one macro, so I just replaced it. There is one other issue, in one of my forms, the date format in a pattern field displays the date incorrectly. I have two other forms (for different tables) with a pattern field for the date set up in exactly the same way. Any ideas why the date format is messed up on only one of the forms?

dougmn gravatar imagedougmn ( 2019-06-25 23:42:34 +0100 )edit

In regard to the Snap version, at the time I installed it, it was the only version I could get in which everything worked properly for me.

dougmn gravatar imagedougmn ( 2019-06-25 23:43:48 +0100 )edit

In regard to the incorrect date display, I just found that the format example for the date field was not set in the table underlying the form. So now it's fixed. Why it got messed up now, when it used to work right, remains a mystery.

dougmn gravatar imagedougmn ( 2019-06-26 00:39:28 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-25 18:24:59 +0100

Seen: 257 times

Last updated: Jun 25 '19