asked on

access report and macro issue

I have a dbse which i intend to use in a small network.
There is some code behind a report and when it is opened on my computer (access 2007) the code does not operate and the rport doesnt function properly.

But when the report is opened on other client computers it works fine and the code works.

The dbse is in a shared folder. The dbse is written in access 2002.

Access 2007 is on my computer which doesnt open it properly and
access 2002 in on the other computer which is fine.

I have Symantec anti virus on all computers and all are up to date with definitions.

all running xp

Helen Feddema

What is the code? In what way does it not work? Could this be because macro security is too high on the computer with the problem?

Richard

ASKER

Hi, see for the probem

https://www.experts-exchange.com/questions/26844766/access-query-and-report.html

access 2007 does not appear to have the same user defined security "buttons" as previous versions, apparently, tho, that said I have never had this problem before or anything like it.

code to follow

Richard

ASKER

code in report detail

the dbse is in a "Trusted location"

so should be OK.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ctl As Control
For Each ctl In Me.Section(0).Controls
    ctl.Visible = Not IsNull(ctl)
Next
End Sub

Open in new window

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Richard

ASKER

yay, boag

spot on my friend,

thanks for the code tip as well

Jeffrey Coachman

;-)