Hi,

I'd created a MDE under Access 2003. It is now under testing stage. Some of the users will use Access 2003 runtime and some will use Access 2007 runtime to run this MDE. I installed the Access 2007 runtime on a test machine and place the MDE in the Desktop for user's initial testing. I did not create a trust area for this MDE in the test machine as well as in my development machine.

When I tested the MDE using...

Thanks Linq and MTB for your answer. I now have the correct setting in my application.

I am quite new to the Access VBA syntax and got a bit consfued with the various syntax you suggested.

1. Why do some codes use the following syntax:
"FieldName.Prop erties("Value") = xxx" instead of directly use the syntax "FieldName.Valu e = xxx"?

2. Are there situations that...

Hi,

I encountered an error "Object not supporting this properties or method" while trying to set a checkbox value to 'True" in a loop. The VBA code I use is as follow:

Set a value to intcount (say set intcount to 2)

ME("FieldName" & intcount).Prope rties.Value = True

increment intcount by 1 and loop back to set another checkbox value to True base on some conditions....