<div>
i hope this will help you....<br />
<br />
<a href="http://chentiangemalc.wordpress.com/2011/03/24/upgrading-access-97-application-to-access-2010/" rel="ugc">http://chentiangemalc.wordpress.com/2011/03/24/upgrading-access-97-application-to-access-2010/</a>&nbsp;<br />
<br />
--<br />
Aman Vijay
</div>


<div>
Yes, frmTicketsTest2 is the name of the form and is open.
</div>


<div>
I will scratch this one and try again, I don't remember anything about it asking me either of them. I will try converting first and it that does not work i will try new again and import.<br />
<br />
Thank you,,<br />
<br />
Jamie
</div>


<div>
<div class="content wysiwyg-content">
I am finally moving some of my last databases that are huge from Access 97 to Access 2010. Which have worked wonderful all of these years, but it is time to move forward. I have a form that has 6 fields that use the dlookup function in Access 97. <br />
<br />
One of the fields looks like this: <br />
<br />
=IIf(DateDiff(&quot;d&quot;,[DateIss<wbr />ued],Now()<wbr />)&gt;14,DLook<wbr />Up(&quot;[Fine3<wbr />]&quot;,&quot;qryVio<wbr />lationCode<wbr />s&quot;,&quot;[ViolD<wbr />esc]=[Form<wbr />s]![frmTic<wbr />ketsTest2]<wbr />![cViolati<wbr />onDesc]&quot;),<wbr />0)<br />
<br />
I am not understanding on how to write it to work in Access 2010. Can someone tell me how to write this in Access 2010<br />
<br />
I might add that I am getting an invalid control error.
</div>
</div>


I am finally moving some of my last databases that are huge from Access 97 to Access 2010. Which have worked wonderful all of these years, but it is time to move forward. I have a form that has 6 fields that use the dlookup function in Access 97. 

One of the fields looks like this: 

=IIf(DateDiff("d",[DateIssued],Now())>14,DLookUp("[Fine3]","qryViolationCodes","[ViolDesc]=[Forms]![frmTicketsTest2]![cViolationDesc]"),0)

I am not understanding on how to write it to work in Access 2010. Can someone tell me how to write this in Access 2010

I might add that I am getting an invalid control error.

i hope this will help you....

http://chentiangemalc.wordpress.com/2011/03/24/upgrading-access-97-application-to-access-2010/ 

--
Aman Vijay

Yes, frmTicketsTest2 is the name of the form and is open.

I will scratch this one and try again, I don&#39;t remember anything about it asking me either of them. I will try converting first and it that does not work i will try new again and import.

Thank you,,

Jamie

Microsoft Access 2010 Database

I am finally moving some of my last databases that are huge from Access 97 to Access 2010. Which have worked wonderful all of these years, but it is time to move forward. I have a form that has 6 fields that use the dlookup function in Access 97. 

One of the fields looks like this: 

=IIf(DateDiff(&quot;d&quot;,[DateIssued],Now())&gt;14,DLookUp(&quot;[Fine3]&quot;,&quot;qryViolationCodes&quot;,&quot;[ViolDesc]=[Forms]![frmTicketsTest2]![cViolationDesc]&quot;),0)

I am not understanding on how to write it to work in Access 2010. Can someone tell me how to write this in Access 2010

I might add that I am getting an invalid control error.

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.