Help converting database

[eolson30]

I have the "students" database from the MS website. and i need it converted to access 2003. i thought i was able to do it, but absolutely none of ther buttons or OnClick stuff doesnt work. i will donate or pay if someone can do this for me. thanks
the database is to large to add to this post. so if some is willing to help please email me or contact me and ill email the database to you thanks again

 

[RuralGuy]

Do you have the db in a trusted location?

 

[eolson30]

Yeah i have it in a trusted location.

 

[RuralGuy]

The MS templates are designed to showcase many of the features of the current release. Saving this db in a previous version is not a big problem. Getting it to work in the earlier version *is*. Not only does it not look the same (which should not be a big surprise to anyone), But almost everything is driven from macros that do not seem to work in the earlier version. That is as far as I took it. I do not recommend trying this unless you just have a ton of time to kill.

 

[eolson30]

ok thanks for trying. Is there a VBA code that can be added to a subform in a table that when clicked it would open a form with specific data that would be entered on the form. example. if there was a data table that had the field EmpID and when clicked or dbl clicked would open that employee personal data on a form. i am using AC2003.

 

[RuralGuy]

This link should help:
http://www.baldyweb.com/wherecondition.htm

 

[eolson30]

Ok thanks. Now where in the table to i add the vba come. and under what event?

 

[RuralGuy]

You can put it in the Click or DoubleClick event of the control on your SubForm that displays the field.