Recent content by starfailure

Lo and Behold, that was it. Thanks

I'm trying to round up a figure to the nearest tenth. My subform uses "=CInt([caseQuantity]+ 0.5)" and works fine. Why won't the same work on a report? It only generates #Error.

more of an academic question, i guess. and i wanted to preview the file in excel so it could be formatted and manipulated before it's saved. it's just kinda annoying to have to save "previews" if you know what i mean.

the OutputTo works fine, but it seems to require that you save the output before it even displays the spreadsheet. Can this be bypassed? What if I don't want to save it until I look at it? What if I don't want to save it at all?

Actually, one more thing. how would I use the same macro for every button. can I make a variable to reference the loaded subform? or do i just have to make a macro for each subform/button?

thanks audrey. that's what i was looking for.

is there an easy way to use a button that simply opens the contents of a subform as an excel sheet? i have a ton of forms and would like to do the same for each. thanks

this is probably really easy to do, but for some reason, i can't get it. i have a report field (like, a calculation of two fields in a query), but i can't get the report to sort by that field.