<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I would like to save the name of a variable within a string saved in a field. &nbsp;I would then like to retrieve the string value within a procedure and use the string/variable concatenation as if written in the procedure itself.<br />
<br />
So for example...<br />
<br />
Value saved in field = &quot;There are &quot;&nbsp;&amp; varNumber &amp;&nbsp;&quot; days to go&quot;<br />
<br />
The procedure where used has a variable varNumber which has a value (eg 3)<br />
<br />
The field value is then retrieved (via DLookup for example) and thus the string them reads...<br />
<br />
There are 3 days to go<br />
<br />
<br />
Is this possible and if so what is the correct syntax?<br />
<br />
Many thanks
</div>
</div>


Hi

I would like to save the name of a variable within a string saved in a field.  I would then like to retrieve the string value within a procedure and use the string/variable concatenation as if written in the procedure itself.

So for example...

Value saved in field = "There are " & varNumber & " days to go"

The procedure where used has a variable varNumber which has a value (eg 3)

The field value is then retrieved (via DLookup for example) and thus the string them reads...

There are 3 days to go


Is this possible and if so what is the correct syntax?

Many thanks

MS Access saving a variable name within a string in a field

Web browsers are applications used primarily to display documents, files and media from the Internet, identified by a Uniform Resource Identifier (URI) that can be a page, image, video or other file. Some browsers require the use of add-ons or extensions to safely render the information they receive; others have systems built into them to perform the same functions.

Web Browsers

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.