Access Runtime & SetValue

[shuff]

I have a macro that fires from the OnActivate property of a form. The first line "initializes" a checkbox by doing a SetValue=0 before making a series of tests to turn it back on if applicable. I should add that the checkbox is unbound - it's simply used for decisioning on the form while it's open and nothing more. Simple, right?

The macro works PERFECTLY in full Access 2003, but when it runs in Access Runtime 2003, I get this message: "An error occurred while referencing the object. Tried to run a visual basic procedure that improperly references a property or method of an object."

Harumph! Any ideas about what's going on? I have checked to make sure that the same Resources available on the full Access installation are the same on the Access RT version, and they are. HELP!!!

 

[shuff]

The Answer!

I broke down and paid for an incident at Micro$oft. The solution was to convert the macro to Visusal Basic, then call it from an Event Procedure. For whatever reason, Access Runtime would not accept the setvalue from an ordinary macro, but it worked just fine as an Event Procedure. Full version Access 2003 didn't care one way or the other. Go figure...

SLH

 

[ghudson]

I broke down and paid for an incident at Micro$oft.

Out of curiosity... How much did Microsoft charge you to answer your question?

 

[shuff]

Micro$oft Charges

The charge was $245 US. Pricey, but they bent over backwards with followup calls, a second session with the rep, et al.

 

[ghudson]

The charge was $245 US. Pricey, but they bent over backwards with followup calls, a second session with the rep, et al.

Ouch! But at least you got the answer you needed.

I think that you will discover how much control you will have over your db objects once you stop using macros and only use VBA. AutoExec and AutoKeys are the only two macros I use within a db. VBA can not duplicate what those two macros can do.

Macros do not allow for error handling and that is a must especially if you are distributing the runtime version of Access for your applications!

Good luck!