Search results

I have a subform on a report. However, it is appearing in a Group footer. How can I control the printing of it (and/or its contents) so that it prints ONLY under 1 group? TIA

Perhaps. I am using a Grouping in the subquery using this: AmtCol1: Max(IIf([BudgetYear]=fnctGetStartYrB(1),[BudgetAmt],'')) How would I know if I am turning it into a string? The format #,000.00 did not work

Item A is in a table as currency. Item A also winds its way up from subqueries into a final query that is used on a form. However, the form does not show it as currency nor with commas. When I try changing the format property the drop down shows nothing and even if I type Fixed or Standard...

How do I loop through a small table plucking out the key until no more records? At each pass I want to perform an insert into another table (I think I've got that part down...just don't know how to loop through a table) TIA!!

Yep, that was it. Thanks for the education. And many more thanks for the generosity of assisting and sharing what you know! It is much appreciated. Paul

I'm using the code below in a form. Each msgbox yields a correct entry, including the Insert string. However I am getting an "Enter parameter" dialog box for each of the 3 values and don't know why. Is my syntax on the Insert statement in error? Private Sub Add_FB_Detail_Click() Dim...

Why is this not a valid construct from within a form? Specifically, when I put in the msgbox the whole operation just simply fails (no msgbox, no breakpoint). It works fine when I take out the Msgbox Dim db As Database Dim QD As QueryDef Dim RS As Recordset Set db =...

I've heard that you can't get access in the vb code to any of the fields in an OpenQuery and that you either have to do a DLookup. Yet here in some production code I found that the field [annualizedcharges] is being stuffed back into an update table. When I use "msg [annualizedcharges] the...