Connell
Last Activity: Dec 6 '08, 08:44 PM
Joined: Jun 19 '07
Location:
-
The value I need for the subform is the result of multiple expressions from the report, some of which include DSum functions. I only need the 'final result', so was hoping for an easy fix. If it was a form value, a simple 'SetValue' macro would do the trick. I was looking for something like that using a report field. -
Set Report Values to Table
I have an Access 2003 report that has multiple calculated values.
Now I need to use one of those values in a subform. Is there a technique in
Access similar to SetValue so a
calculated report value can be transferred to a table field? -
QBF in Access 2007
Are there new guidelines for using Query by Form in Access 2007? I have not been able to construct such a QBF using the techniques that worked in prior versions. For example it won't accept date fields provided by my QBF_Form (an unbound form using an unbound text box.) When I execute the code to open a report whose query uses a criteria such as "Between Form![QBF_Form]![1st date] And Form![QBF_Form]![2nd Date], Access doesn't appear to look... -
List Database Objects
I am using Access 2002.
Is there a technique to produce a report listing all the tables, forms, queries, reports, etc.? -
Report/Subreport Problem
I am using a command button from a form (Access 2000) to produce a report. The form and the report each have a subform (subreport). Here is the expression that produces a total for one field on the report.
=nz([Tech Assist Subreport]![Total Service Hours])+nz([CaseLaw Updates Hours])+nz([DefenseNET Newsletter Hours])+nz([Defense Magazine Hours])+nz([Brief Bank Hours])+nz([Other Publication Hours])+nz([Amicus Hours])+nz([Training Performed...
No activity results to display
Leave a comment: