Access2Base in Calc - Open a form
Posted: Thu Dec 31, 2015 6:58 pm
I have developped nice and sophisticated macros in Excel VBA to select lists, make lists of e-mails, and create labels for mailing - creating directly a RTF file, making it much easiar to use that any kind of mail merge procedure.
I would like to have them working in calc using the Access2Base extension. On of the persons using such a system cannot operate the macros herself because Microsoft manage to sell a version of Office for Mac without VBA...
Access2base looks promising, and much of my VBA code works pretty well with very little adjustment, but I am stuck on the problem of opening the dialogs (forms).
I tried using the OpenForm (DoCmd.OpenForm) method found on the Access2Base documentation. But this method systematically returns the error message «Erreur d'exécution BASIC. '91' Variable d'objet non définie.» (Basic exectuion error. '91' Object variable not defined).
The forms do open from the macro editor interface, but I do not find a way to open them with a macro assigned to a button.
Any solution for this problem?
I would like to have them working in calc using the Access2Base extension. On of the persons using such a system cannot operate the macros herself because Microsoft manage to sell a version of Office for Mac without VBA...
Access2base looks promising, and much of my VBA code works pretty well with very little adjustment, but I am stuck on the problem of opening the dialogs (forms).
I tried using the OpenForm (DoCmd.OpenForm) method found on the Access2Base documentation. But this method systematically returns the error message «Erreur d'exécution BASIC. '91' Variable d'objet non définie.» (Basic exectuion error. '91' Object variable not defined).
The forms do open from the macro editor interface, but I do not find a way to open them with a macro assigned to a button.
Any solution for this problem?