Chief Operations Manager

Eirman

<div>
If you can share a database, (without data), and just the single form you are converting, which can reproduce the problem, I can forward it to the access team, and log a bug on it.
</div>


If you can share a database, (without data), and just the single form you are converting, which can reproduce the problem, I can forward it to the access team, and log a bug on it.

<div>
That works - Well spotted! <br />
Thank You Anders
</div>


That works - Well spotted!
Thank You Anders

<div>
I'm using Access 2013 so the bug may be fixed in later versions.<br />
<br />
I'll recreate the wizard / macro and post some relevant screenshots tomorrow.
</div>


I'm using Access 2013 so the bug may be fixed in later versions.

I'll recreate the wizard / macro and post some relevant screenshots tomorrow.

<div>
<h2>As promised ....</h2>
<hr />
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417878/Access-2013a.jpg" target="_blank" title="Access-2013a.jpg (30 KB)"><img alt="Access-2013a.jpg" class="file-block lazyload" style="max-width: 591px;" data-src="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417878/Access-2013a.jpg" /></a>
<hr />
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417879/Access-2013b.jpg" target="_blank" title="Access-2013b.jpg (16 KB)"><img alt="Access-2013b.jpg" class="file-block lazyload" style="max-width: 629px;" data-src="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417879/Access-2013b.jpg" /></a>
<hr />
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417880/Access-2013c.jpg" target="_blank" title="Access-2013c.jpg (12 KB)"><img alt="Access-2013c.jpg" class="file-block lazyload" style="max-width: 379px;" data-src="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417880/Access-2013c.jpg" /></a>
<hr />
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417881/Access-2013d.jpg" target="_blank" title="Access-2013d.jpg (15 KB)"><img alt="Access-2013d.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2019/04_w15/800_1417881/Access-2013d.jpg" /></a>
<hr />
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417882/access-2013e.jpg" target="_blank" title="access-2013e.jpg (17 KB)"><img alt="access-2013e.jpg" class="file-block lazyload" style="max-width: 415px;" data-src="https://filedb.experts-exchange.com/incoming/2019/04_w15/1417882/access-2013e.jpg" /></a>
</div>


AS PROMISED ....

----------------------------------------

Access-2013a.jpghttps://filedb.experts-exchange.com/incoming/2019/04_w15/1417878/Access-2013a.jpg

----------------------------------------

Access-2013b.jpghttps://filedb.experts-exchange.com/incoming/2019/04_w15/1417879/Access-2013b.jpg

----------------------------------------

Access-2013c.jpghttps://filedb.experts-exchange.com/incoming/2019/04_w15/1417880/Access-2013c.jpg

----------------------------------------

Access-2013d.jpghttps://filedb.experts-exchange.com/incoming/2019/04_w15/1417881/Access-2013d.jpg

----------------------------------------

access-2013e.jpghttps://filedb.experts-exchange.com/incoming/2019/04_w15/1417882/access-2013e.jpg

access-2013e.jpg

Access-2013b.jpg

Access-2013c.jpg

Access-2013a.jpg

Access-2013d.jpg

<div>
I was able to reproduce this in my own version (Office 2019). I will forward to the dev team.
</div>


I was able to reproduce this in my own version (Office 2019). I will forward to the dev team.

<div>
<div class="content wysiwyg-content">
I created a Button in Access to open another form with the same record selected.<br />
(The wizard created a Macro which worked fine).<br />
<br />
I then &quot;converted the Form's Macro to VBA &quot;<br />
The conversion produced faulty VBA (Expected end of statemend of statement Error)<br />

<pre><code id="code-10-29142698-1">Docmd.OpenForm &quot;VOCAB ENTRY&quot;, acNormal, &quot;&quot;, &quot;[THEWORD]=&quot; &amp;&quot; '&quot; [&amp;TextTHEWORD] &amp; &quot;'&quot;, , acNormal</code></pre>
</div>
</div>


I created a Button in Access to open another form with the same record selected.
(The wizard created a Macro which worked fine).

I then "converted the Form's Macro to VBA "
The conversion produced faulty VBA (Expected end of statemend of statement Error)
(CODE)

What's The Syntax Error Generated By Access Macro Conversion

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.