Thanks for the reply. The problem in my case appears to be that the controls I'm referencing are in the report footer section of the subreports, though I'm not sure how to do the calculations otherwise (the calculations have different record sources). I'm pretty new at this.
I'm glad you...
I have been having the same problem (0 shows as #error in print preview).
Neither using Nz in the controls nor following the instructions in the link (nice and clear, thanks, Bob) worked for me. Funkbuget, have you found a solution? Or does anyone know of one?
Thanks for any help!
Re: Access-2007 Calculation on form, Not getting saved in Table
Thanks, I've wondered about that. When do you think it is best (or just on par) to use data macros instead of calculating in forms, queries, etc., if ever?
Re: Access-2007 Calculation on form, Not getting saved in Table
*Disclaimer: Listen to my fledgling ideas at your own peril and amusement. Sometimes I get it right - maybe you'll get lucky.
Data macros could accomplish this, though I think they're only available in Access 2010.
*Disclaimer: Listen to my fledgling ideas at your own peril and amusement. Sometimes I get it right - maybe you'll get lucky.
I didn't understand a good deal of your post (probably due to my noobility), but perhaps data macros to calculate totals in the tables themselves would be helpful in...
I was so happy to have found this video that I thought others would like to learn from it as well.
It demonstrates how to create data macros to calculate the "order total" for each order in an orders table (based on the correlating records in an order line items table). It also inherently...
Time to let my noobishness shine. :) My fundamental question is can a subform be placed within a subform in a web database that will be used with Access 2010, SharePoint 2010, Access Services?
For example, my goal for one of the forms is to have:
Main form = Customer information
Subform =...
Thank you for the welcome. I agree that programming (and networking) seems to become more and more accessible. No pun intended, right? ;) This seems especially the case when we consider how much easier it is to publish a database to the web. Indeed, it is extremely satisfying to create...
Some of the videos are too basic for me, though I just checked out the autoexec macro video and I hadn't known that a macro like that could be done, very good to know!
I'm also learning a thing or two about creating instructional videos from watching yours. I don't feel knowledgeable enough at...
I appreciate the videos and the new organization of the page makes it faster to find what I'm looking for. The forms section might benefit from sub-sections...though maybe not, I tend to organize to the breaking point, lol. Thanks again!
I'd been searching for a way to do this when the subform contains many records and this ended up working for me. I created a macro (here it is converted by Access to code):
'------------------------------------------------------------
' mcrTabOutOfSubQLI
'...
Thanks! Profound can be overrated, hehe. :) I'm finding it is a sink or swim type of situation which can be stressful at times (usually when a solution seems elusive), but boy am I learning a lot. It seems to be one of those dynamics that holds opposites (I am both questioning my abilities...
Thank you. So far I've found some great tips. It comes in handy with this first "real" database I'm creating. Sometimes it is hard to know where to start, but things seem to fill out eventually even if changes have to be made to some foundational issues and their cascading effects. I've been...