VBA code do not get executed

[Jim Pan]

On the report, I have a textbox that is reference the property on the code
section.

For example, textbox: Name = Header_1.
Control Source = [GetCategory]

On the code:
Public Property Get GetCategory() As String
Select Case [MyCategoryData]
Case 1
GetCategory = "A Category"
Case 2
GetCategory = "B Category"
................
End Property

When I ran the report, I got #Name?

Does anyone has the same issues?
How can I debug a report?

This is for Access 2007 (Access 2003 is working perfectly).


Thanks.

 

[Alex Dybenko]

Hi,
check that all references in place (menu tools-references), remove unused
references and compile project

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Tom van Stiphout]

On Tue, 4 Mar 2008 10:22:47 +0300, "Alex Dybenko"

Another option is that the db is not in a Trusted Location (see help
file on how to set it), or that Service Pack 1 is not applied.

-Tom.

 

[Jim Pan]

Tom,

That is what I did the first place. I will apply the SP1 soon.
Thanks.

 

[Jim Pan]

Alex,

I will recompile this morning and post the results back.
Thanks for the help.

Hi,
check that all references in place (menu tools-references), remove unused
references and compile project

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

On the report, I have a textbox that is reference the property on the code
section.

For example, textbox: Name = Header_1.
Control Source = [GetCategory]

On the code:
Public Property Get GetCategory() As String
Select Case [MyCategoryData]
Case 1
GetCategory = "A Category"
Case 2
GetCategory = "B Category"
................
End Property

When I ran the report, I got #Name?

Does anyone has the same issues?
How can I debug a report?

This is for Access 2007 (Access 2003 is working perfectly).


Thanks.