How to Validate Date Entry on Form

[wilderfan]

I have uploaded a small db to illustrate what I am trying to do – track the history of corporate name changes.

In the sample db, there are only 2 corps, but they have each undergone several name changes.

The “Effective Date” field on the form uses Stephen Lebans’ Month Calendar control.

When entering the date of the latest name change, I believe it would be a good idea to compare the new date being entered to the date of the last (previous) name change. The date of the current name change should presumably be later than the date of the last name change.

I’m not very proficient at VBA code. So if anyone out there has any suggestions for this VBA-challenged user, I’d appreciate hearing from you.

FYI - The db was built using ACCESS 2003.


By the way, if anyone has any suggestions for an introductory book on the subject of VBA programming for ACCESS 2003, pls let me know.

 

[dkinley]

Here is a link for some VBA primer ...

http://www.functionx.com/vbaccess/


I would recommend taking a look at this, more specifically for your problem look at #6 Conditional Statements. It also has some sample coding and can speak much better to it then I can type here.

Per your request, here are some other sites that may be of some use:

http://www.techonthenet.com/access/index.php
http://www.sienaheights.edu/personal/csstrain/Access2007.htm


Hope that helps.

-dK