databaseDocumenter.PNG

<div>
Tested both and they work fine<br />
Thank You!<br />
<br />
(Selected chaau's as there is no need to purchase 3rd party software)
</div>


Tested both and they work fine
Thank You!

(Selected chaau's as there is no need to purchase 3rd party software)

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am wondering how can I find where a particular SQL is programmed in my Access App?<br />
<br />
This is linked to SQL BE and its executing the following sql statement<br />
<br />

<pre><code id="code-10-28694493-1">SELECT &quot;ID&quot; ,&quot;EmployeeID&quot; ,&quot;Day&quot; ,&quot;ReplacedEmployeeID&quot; ,&quot;EmployeesNotes&quot; 
 FROM &quot;dbo&quot;.&quot;PatientsEmployeesSchedule&quot; WHERE NOT((&quot;EmployeesNotes&quot; IS NULL ) ) </code></pre>
<br />
I thought of an idea, if its possible to convert the entire app to text file (like its possible for a particular form) and then just do a text search?
</div>
</div>


Hi Experts,

I am wondering how can I find where a particular SQL is programmed in my Access App?

This is linked to SQL BE and its executing the following sql statement

(CODE)

I thought of an idea, if its possible to convert the entire app to text file (like its possible for a particular form) and then just do a text search?

Find a SQL statement in an Access app

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.