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.
