<div>
It would seem to me that &quot;Me.texbox1= &quot;&nbsp;should should provide the value for (M)<br />
<br />
Biggles1
</div>


It would seem to me that "Me.texbox1= " should should provide the value for (M)

Biggles1

<div>
<div class="content wysiwyg-content">
Derived from <a href="https://www.experts-exchange.com/questions/29096144/Anyone-can-help-me-perfect-this-function.html" rel="ugc">Here</a><br />
Anyone can help me perfect the Y?<br />
<br />
Dim Y As Integer<br />
Dim M As Date<br />
Y = 2018<br />
M = #4/22/ &amp;Y#<br />
<br />
Me.txtbox1 = DLookup(&quot;[dNum]&quot;, &quot;tblDate&quot;, &quot;[NewDate] = #&quot; &amp;&nbsp;format(M,&quot;YYYY-MM-DD&quot;) &amp;&nbsp;&quot;# and [Ename] = '&quot; &amp;&nbsp;[Ename] &amp;&nbsp;&quot;'&quot;)<br />
Me.txtbox2 = Weekday(M)<br />
<br />
txtbox1 should show the value of dNum .<br />
txtbox2 should show 1 since 4/22/2018 is a sunday.
</div>
</div>


Derived from Here (https://www.experts-exchange.com/questions/29096144/Anyone-can-help-me-perfect-this-function.html)
Anyone can help me perfect the Y?

Dim Y As Integer
Dim M As Date
Y = 2018
M = #4/22/ &Y#

Me.txtbox1 = DLookup("[dNum]", "tblDate", "[NewDate] = #" & format(M,"YYYY-MM-DD") & "# and [Ename] = '" & [Ename] & "'")
Me.txtbox2 = Weekday(M)

txtbox1 should show the value of dNum .
txtbox2 should show 1 since 4/22/2018 is a sunday.

Anyone can help me perfect this function?

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.