Recent content by alanj

Some things to try: If the 2 fields are in the same form, try putting the code in the AfterUpdate event of the emptemp object. Be sure the employmentstatus textbox is enabled. You may also have to set focus to the employmentstatus textbox first, and specify its text property. eg...

I am distributing an Access XP application using Access Runtime. If the user has no version of access, or uses '97 or earlier, there is no problem. However, if the user has Access 2000 on the local machine, that version starts and send an error indicating that the format is not recognized. Is...

Complicating further... I am in a similar situation, developing in Access XP (2002) but distributing to users who have older versions of Access, which they use for other work. I created a run-time version which installs nicely. If the client has no version of Access, or Access 97 / earlier...

fast method to find obsolete code open any of your modules, then click "Debug, Compile". Access will give you error messages and drop you into the offending code. If you have references to controls you deleted, you can click "view object" to look at the object and verify. When you complete...

Overwright method You are importing "tableX" from database1 into database2. Instead of importing the table, open database1 and export to database 2, using the same table name. Access will ask you to confirm the overwright, and will replace the existing table in database 2.