Fora

MS-Office 2010: Access without Events?

Error on starting VBA-Scripts via Event-Handler

Autor Odpowiedzi
newbumblebee Saturday 11 March 2023 at 1:17
newbumblebeeAnonymous

Hallo everybody,

please help me, I cannot get MS-Access to run a script scheduled via event manager.

I have installed MS-Excel, -Word & -Access according to the procedures given on https://isolution.pro/de/q/au13972902/wie-installiere-ich-ms-office-2016-unter-playonlinux. They use Wine 3.4, Windows 7 and the 32kb-version.
What I couldn't do is their step 8: copy AppvIsvSubsystems32.dll and C2R32.dll from
drive_c/Program Files/Common Files/Microsoft Shared/ClickToRun/ to
drive_c/Program Files/Microsoft Office/root/Office16/.
This should not be a problem as I have a full version?

All three programs start.
In Excel I could run a simple VBA-script, also in Access.
In Excel & Word I could activate the developer tools ("Entwickler-Tools"). Not in Access, there it is no displayed.

My main problem: In Access I cannot use VBA-scripts started by the event handler. There is a script called on opening of a form; instead of the form, I get the error:  
"Sie haben als Einstellung der Ereigniseigenschaft den Ausdruck Beim Öffnen eingegeben. Dieser Ausdruck hat einen Fehler verursacht: ."
"You have entered the expression on opening as the event property setting. This expression has caused an error: ."

Interestingly the error is not stated.
When I disable all code inside the on opening-script, then the form is displayed.

I got that error while opening a form in an existing Acces 2007-database (.mda).
So I created a mini dummy database with 1table & 1form; that was saved autmatically as *.accdb. On opening, a simple VBA script has to go to the last dataset.
I set a debugging stop on that single line of code. It is not reached, afore the same error is displayed.

My operating system is Tuxedo, a derivate of Ubuntu (up-to-date).

Has anybody an idea what I should do?
Thank you.