Calculations not processing

[Sandy]

Hello -

I have a DLookup that only calculates when I view the form in design mode,
then go back to form mode.

This database is built and saved in Access 2003 and is being viewed by some
users via Access 2007. The issue is only with the Access 2007 users.

Any help greatly appreciated.

many thanks
sandra

 

[Jeff Boyce]

How are you telling Access to do the re-calculation?

Are the fields involved bound or unbound.

Is the form bound or unbound?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Sandy]

Hello Jeff -

The form is bound to t_accounting and has several unbound fields to process
the calculations.

The DLookup calculation is in field named AmtCalc, which is unbound

Combo52 is a dropdown with control source of ChCrID, which is a bound field
to t_accounting - this selects the type of discount to be applied by
specifying the ChCrID to use in the DLookup

The event on Combo52 is On Change, and directs the focus to the AmtCalc field

The formula in the AmtCalc is as follows:

=(DLookUp(" [ChCrAmt]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))+(DLookUp(" [CourseFee]","t_Courses","[Course_ID]= " &
[CourseID]))*(DLookUp(" [ChCrperc]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))*-1

The OnFocus event for AmtCalc is to SetValue of Amt (which is bound to
t_accounting table) equal to the calculated amount in AmtCalc

On this form, the events are all Macros.

I notice that in the macro window, some lines have a yellow triangle icon
saying "This action will not be allowed if the dabase is not trusted"

In the Trust Centre, my trusted location is
C:\Program Files\Microsoft Office\Office12\ACCWIZ\

All macros are enabled.

Thanks for your help!

sandra

 

[Sandy]

Just to clarify, the calculations all compute when I go from form to design
and back to form view.

Hello Jeff -

The form is bound to t_accounting and has several unbound fields to process
the calculations.

The DLookup calculation is in field named AmtCalc, which is unbound

Combo52 is a dropdown with control source of ChCrID, which is a bound field
to t_accounting - this selects the type of discount to be applied by
specifying the ChCrID to use in the DLookup

The event on Combo52 is On Change, and directs the focus to the AmtCalc field

The formula in the AmtCalc is as follows:

=(DLookUp(" [ChCrAmt]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))+(DLookUp(" [CourseFee]","t_Courses","[Course_ID]= " &
[CourseID]))*(DLookUp(" [ChCrperc]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))*-1

The OnFocus event for AmtCalc is to SetValue of Amt (which is bound to
t_accounting table) equal to the calculated amount in AmtCalc

On this form, the events are all Macros.

I notice that in the macro window, some lines have a yellow triangle icon
saying "This action will not be allowed if the dabase is not trusted"

In the Trust Centre, my trusted location is
C:\Program Files\Microsoft Office\Office12\ACCWIZ\

All macros are enabled.

Thanks for your help!

sandra

How are you telling Access to do the re-calculation?

Are the fields involved bound or unbound.

Is the form bound or unbound?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

So, if that path that is trusted is NOT the location of the file you are
working on, Access won't trust the macros!

If you haven't done so already, open the Trust Center and add the location
(file path) where this particular Access application/db/file is located.

JOPO (just one person's opinion) -- I've created a folder under my C:\ that
holds ALL of my Access applications, then marked that folder ("+ all
subfolders") as trusted.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello Jeff -

The form is bound to t_accounting and has several unbound fields to
process
the calculations.

The DLookup calculation is in field named AmtCalc, which is unbound

Combo52 is a dropdown with control source of ChCrID, which is a bound
field
to t_accounting - this selects the type of discount to be applied by
specifying the ChCrID to use in the DLookup

The event on Combo52 is On Change, and directs the focus to the AmtCalc
field

The formula in the AmtCalc is as follows:

=(DLookUp(" [ChCrAmt]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))+(DLookUp(" [CourseFee]","t_Courses","[Course_ID]= " &
[CourseID]))*(DLookUp(" [ChCrperc]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))*-1

The OnFocus event for AmtCalc is to SetValue of Amt (which is bound to
t_accounting table) equal to the calculated amount in AmtCalc

On this form, the events are all Macros.

I notice that in the macro window, some lines have a yellow triangle icon
saying "This action will not be allowed if the dabase is not trusted"

In the Trust Centre, my trusted location is
C:\Program Files\Microsoft Office\Office12\ACCWIZ\

All macros are enabled.

Thanks for your help!

sandra

How are you telling Access to do the re-calculation?

Are the fields involved bound or unbound.

Is the form bound or unbound?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Sandy]

HI Jeff -

I added the folder to the the trusted locations but still no go on the issue.

I resolved the issue by adding a Run Command -> Refresh line to the macro.
I also asked the client to add the database location to the Trusted
Locations.

Thanks for your help, as always!
sandra

So, if that path that is trusted is NOT the location of the file you are
working on, Access won't trust the macros!

If you haven't done so already, open the Trust Center and add the location
(file path) where this particular Access application/db/file is located.

JOPO (just one person's opinion) -- I've created a folder under my C:\ that
holds ALL of my Access applications, then marked that folder ("+ all
subfolders") as trusted.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello Jeff -

The form is bound to t_accounting and has several unbound fields to
process
the calculations.

The DLookup calculation is in field named AmtCalc, which is unbound

Combo52 is a dropdown with control source of ChCrID, which is a bound
field
to t_accounting - this selects the type of discount to be applied by
specifying the ChCrID to use in the DLookup

The event on Combo52 is On Change, and directs the focus to the AmtCalc
field

The formula in the AmtCalc is as follows:

=(DLookUp(" [ChCrAmt]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))+(DLookUp(" [CourseFee]","t_Courses","[Course_ID]= " &
[CourseID]))*(DLookUp(" [ChCrperc]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))*-1

The OnFocus event for AmtCalc is to SetValue of Amt (which is bound to
t_accounting table) equal to the calculated amount in AmtCalc

On this form, the events are all Macros.

I notice that in the macro window, some lines have a yellow triangle icon
saying "This action will not be allowed if the dabase is not trusted"

In the Trust Centre, my trusted location is
C:\Program Files\Microsoft Office\Office12\ACCWIZ\

All macros are enabled.

Thanks for your help!

sandra

How are you telling Access to do the re-calculation?

Are the fields involved bound or unbound.

Is the form bound or unbound?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello -

I have a DLookup that only calculates when I view the form in design
mode,
then go back to form mode.

This database is built and saved in Access 2003 and is being viewed by
some
users via Access 2007. The issue is only with the Access 2007 users.

Any help greatly appreciated.

many thanks
sandra

 

[Jeff Boyce]

Thanks for posting your solution. Someone, sometime, will be looking for
this answer and find yours!

Regards

Jeff Boyce
Microsoft Office/Access MVP

HI Jeff -

I added the folder to the the trusted locations but still no go on the
issue.

I resolved the issue by adding a Run Command -> Refresh line to the macro.
I also asked the client to add the database location to the Trusted
Locations.

Thanks for your help, as always!
sandra

So, if that path that is trusted is NOT the location of the file you are
working on, Access won't trust the macros!

If you haven't done so already, open the Trust Center and add the
location
(file path) where this particular Access application/db/file is located.

JOPO (just one person's opinion) -- I've created a folder under my C:\
that
holds ALL of my Access applications, then marked that folder ("+ all
subfolders") as trusted.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello Jeff -

The form is bound to t_accounting and has several unbound fields to
process
the calculations.

The DLookup calculation is in field named AmtCalc, which is unbound

Combo52 is a dropdown with control source of ChCrID, which is a bound
field
to t_accounting - this selects the type of discount to be applied by
specifying the ChCrID to use in the DLookup

The event on Combo52 is On Change, and directs the focus to the AmtCalc
field

The formula in the AmtCalc is as follows:

=(DLookUp(" [ChCrAmt]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))+(DLookUp(" [CourseFee]","t_Courses","[Course_ID]= " &
[CourseID]))*(DLookUp(" [ChCrperc]","t_ChargesCredits","[ChCr_ID]= " &
[ChCrID]))*-1

The OnFocus event for AmtCalc is to SetValue of Amt (which is bound to
t_accounting table) equal to the calculated amount in AmtCalc

On this form, the events are all Macros.

I notice that in the macro window, some lines have a yellow triangle
icon
saying "This action will not be allowed if the dabase is not trusted"

In the Trust Centre, my trusted location is
C:\Program Files\Microsoft Office\Office12\ACCWIZ\

All macros are enabled.

Thanks for your help!

sandra



:

How are you telling Access to do the re-calculation?

Are the fields involved bound or unbound.

Is the form bound or unbound?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello -

I have a DLookup that only calculates when I view the form in design
mode,
then go back to form mode.

This database is built and saved in Access 2003 and is being viewed
by
some
users via Access 2007. The issue is only with the Access 2007 users.

Any help greatly appreciated.

many thanks
sandra