Search results

OK - It's a bit convoluted, but I added an invisible control to the Details, RunningSum OverGroup...and then made a visible control in the Footer referencing the invisible control. Not pretty, but it works. On to the next problem!! Thanks for your help. Jennifer

I thought so too! But I used that, and I get asked for the parameter of my subreport.hasdata. Could I have the controls in the wrong place? I have a group header and footer. Header has the Account number, and I want Footer to have the subtotals for that Account. Details has all of the items that...

I need to sum the data on the main report because it's using a different grouping level than the subreport. I have the info coming in fine from the control using the same kind of hasdata statement as above, I just need to Sum the statement. Jennifer

Did you ever get an answer for this? I also need to know how to Sum my HasData that is bringing info from a subreport. Can anyone help? Jennifer

Thanks Pat, The control is referencing another control on a subreport [srptInventoryUsage(b)] - and I initially tried NZ as the control source with no luck. I'll try again, but is there a way to use what I have (which currently works) and SUM it? Ah yes - the reason the NZ didn't work for me...

hi y'all - I have a report control whose control source is: =IIf([srptInventoryUsage(b)].[Report].[HasData]=-1,[srptInventoryUsage(b)].[Report]![SumOfUnitPrice],0) because I needed it to return a value even if empty. Now, in the group footer I need to SUM this control...and I tried...

Thank you, Pat. Jennifer

Hi all, I have a field in a query: Count: Sum((Nz([Qty],0))) and I want the equation to make the result NEGATIVE. is there a way I can do this? Thank you for your help today, and everyday Jennifer

Wouldn't it just be something like: If Me.lstBox.Listcount = 0 then msgbox "There are no records to display." exit sub end if I have something like it and that worked for me. Jennifer

Thanks Pat - The application I'm developing (or trying to) is for a fast food chain. It allows them to keep track of their recipes, vendors, invoices, inventory, and daily sales. The table problems I've been having are to do with the levels of 'ingredients' they use, and calculating the cost...

Pat - should I just make two more details tables to deal with the two extra levels of that item? it's seeming like the simplest way to go.......... Jennifer

That's the way I had it - but 'they' insist on three levels of this item ...and my queries are set up to run through each of 6 different types of items in a specific order to perform calculations. I didn't think I could apply the order if I had P1, P2, P3 all in the same items table. can i? have...

(is this awful?) because i am using one details table to hold the details from three items tables. Jennifer [This message has been edited by JCross (edited 03-27-2002).]

hi all - i can't use the 'enforce referential integrity' feature of the relationships in this case, but i need to check and see if there are 'details' for an item before allowing the user to delete it. the item info is on my mainform, the details are listed on the subform. so - if there are...

just guessing but if you have line totals on your subform shouldn't it just be... =SUM[linetotal] Jennifer

Thanks, Harry - but the whole passing in the form name thing is what I have a hard time with. OOH! I got it. yay! Thanks anyway, y'all. Jennifer [This message has been edited by JCross (edited 03-27-2002).]

hi! i have a chunk of code to set the visibility of command buttons on each of my forms. There are only 2 modes, and each line looks like me.cmdClose.visible = true all the cmdbuttons are named the same on each form, and i'd like to create a public sub to call instead of copy/pasting the...

Thanks Russ - I'm going to give it a try.... Jennifer

i noticed the problems i realized i don't need to store the result of the control so much as the calculation. how can i do this?? i can come up with the right calc. in a query....but the query is based on another query that is not updateable and so i don't think i can use it for an update...

i just can't figure it out! now the docmd runs if i have a break on it, but it doesn't run if i don't. ARGH! but thank you SO much for your help. i couldn't have gotten this far...... jennifer