VBA code do not get executed

  • Thread starter Thread starter Jim Pan
  • Start date Start date
J

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.
 
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.
 
Alex,

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

Alex Dybenko said:
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

Jim Pan said:
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.
Click to expand...
Click to expand...
 
Back
Top