<div>
I have no problems with Gustav's sample. It is call of function. May be you have not allowed module execution? What Access version is used?<br />
Can you open record source of this form? Can you run this query?
</div>


I have no problems with Gustav's sample. It is call of function. May be you have not allowed module execution? What Access version is used?
Can you open record source of this form? Can you run this query?

<div>
when I try to run the form it crashes....
</div>


when I try to run the form it crashes....

<div>
Please, open module and compile it
</div>


<div>
All the green corners indicate missing fields, so it looks like you have deleted the Flags table.<br />
<br />
/gustav
</div>


All the green corners indicate missing fields, so it looks like you have deleted the Flags table.

/gustav

<div>
Perfect!!!!! IT IS WORKING!!!!! thanks a lot!!!<br />
joao
</div>


Perfect!!!!! IT IS WORKING!!!!! thanks a lot!!!
joao

<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I had this question after viewing <a href="https://www.experts-exchange.com/questions/29050076/How-to-show-a-web-linked-image-on-a-report.html" rel="ugc">How to show a web linked image on a report</a>.<br />
<br />
In the trial database I have got the following errors:<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/08_w33/1187275/Screen-Shot-2017-08-13-at-09.39.29.png" target="_blank" title="Screen-Shot-2017-08-13-at-09.39.29.png (42 KB)"><img alt="Screen-Shot-2017-08-13-at-09.39.29.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/08_w33/800_1187275/Screen-Shot-2017-08-13-at-09.39.29.png" /></a><br />
and<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/08_w33/1187277/Screen-Shot-2017-08-13-at-09.39.21.png" target="_blank" title="Screen-Shot-2017-08-13-at-09.39.21.png (78 KB)"><img alt="Screen-Shot-2017-08-13-at-09.39.21.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/08_w33/800_1187277/Screen-Shot-2017-08-13-at-09.39.21.png" /></a><br />
can you help?
</div>
</div>


Screen-Shot-2017-08-13-at-09.39.21.png

Screen-Shot-2017-08-13-at-09.39.29.png

I had this question after viewing How to show a web linked image on a report (https://www.experts-exchange.com/questions/29050076/How-to-show-a-web-linked-image-on-a-report.html).

In the trial database I have got the following errors:




and



can you help?

compile error in query expression

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.