<div>
thank u very much helicopter!<br />
&nbsp;<br />
u gave a perfect solution to the problem!<br />
<br />
after all the process u described, there is also a need to register the new references (Tools\ActivX Controls ...)<br />
<br />
thanx again<br />
efratk<br />
<br />

</div>


thank u very much helicopter!
 
u gave a perfect solution to the problem!

after all the process u described, there is also a need to register the new references (Tools\ActivX Controls ...)

thanx again
efratk



<div>
<div class="content wysiwyg-content">
I run 2 different mdb's on one computer, and found a strange behavior of the MID function:<br />
the first mdb recocgnizes the function MID, while the second does'nt.<br />
i thought that maybe there is a problem in the second mdb, but i realise that on other computer it works correctly.<br />
<br />
Do someone have a logic explenation and solution to this strange problem ??? <br />
<br />
thanx in advance <br />
efratk<br />

</div>
</div>


I run 2 different mdb's on one computer, and found a strange behavior of the MID function:
the first mdb recocgnizes the function MID, while the second does'nt.
i thought that maybe there is a problem in the second mdb, but i realise that on other computer it works correctly.

Do someone have a logic explenation and solution to this strange problem ??? 

thanx in advance 
efratk


MID functions acts strangely ?!?

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.