Search results for query: *

I know that I cannot perform the SUM function on a control text box, but here is my problem. I want to perform a sum on a text box with a control source of =[EPMonth]-[BPMonth]. The [EPMonth] and [BPMonth] are other control text boxes on the report, but their numberic values change based on...

I am having the same problem, and I tried the fix, but I am still getting the same error msg. Any suggestions?

Paul, Thanks for the help - that fixed it.

I have a field on one of an Access Form that I have the default value in the properties field set to today's date. I use =Date() to do this. That has worked just fine for quite a while, but I must have changed something somewhere in the form or database because now instead of displaying...

MacCaillean , The OnFormat was the key. I just put my code there, and it worked! Thanks for the help.

I have been working on this off and on for quite a while. I have a report that takes it's detail fields from a subform. I have 6 of each of the following fields: quantity , unit of measure, and price (quantity1,unitofmeasure1,price1,quantity2,unitofmeasure2,price2, ...all the way up to...

That worked - Thanks, Rick

I currently export an Access report in pdf format to a file, so that I can email the report as a pdf attachment. That part works just fine, but I would like to delete the pdf file automatically after I am done emailing it. How do I do this?

I have a couple of Access reports that are weekly sales reports and they run just fine, but, call me lazy, I would like to know if there is a way to have a macro automatically feed a date range to the date parameters in the report. Basically, I want the macro to insert that week's Monday date...