• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

On Dirty event, Access 2000 Vs Access 2002

I want to catch a change in a form so I use On Dirty
event. It is working fine with Access 2002 but when I am
running the program in Access 2000 the On Dirty event is
triggering even when I am populating the fields using VB
code. (Not setting the control's Text property but
something like Forms!Project![Project Name] =
Muazzam Siddiqui.
1 Solution
Did you develop the database in Access 2000 or 2002. If you developed in Access 2002, I would copy and VB code you wrote, and paste it into the 2000 version, and make it your new development database. If all systems don't have the XP version of VB*.dll files, 2000 and prior won't work with the database created in 2002. Always develop on the lowest version, and tailor to it's needs.

So, try pasting the code into a notepad document from 2002, then open up 2000, and paste the code in there. Do this whenever you get a problem with the database, or, if it is not a big dbase, do all of it.

Another option with regards to your code, try:
ProjectName.Text = varProjectName.Text


ProjectName.value = varProjectName.value

Good luck

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now