Recent content by byujakedmb

Can someone help me create a macro to put on a report that runs a saved export? (2007)

I dont necessarily need it in excel, but I need to send just the report in an email. So I figured the easiest way would be to export it so it becomes its own file and then I could send it. Is there another way that would make more sense?

just the information in the columns the way it is organized in the form. I dont need the format or borders or anything like that. Just the column headings and data

yeah and I am fairly new to it :)

anyone know what to do?

Hey y'all I need help creating a macro button to put in the header of my form. I need the button to export the form to excel. Can anyone help me do this?

How do you do it the second way and what are the advantages of doing it that way as opposed to the first way?

The fields did not change, but after re-entering the same field names it worked. Do you know why that could be? Also, how do I get the calculated value to show as a percentage in a query?

I figured out the problem. Thanks for your help! Also, sometimes i go to open up a query and a box pops up that asks me to enter parameter value for all of the attributes.. what is this and why does my query come up blank when I dont enter a parameter?

Ok so I added the interval into the datediff functions and now i get a #error. TotalAnnualizedReturnDollars...

got it thanks! I have a new problem now. The following formula returns the error "wrong number of arguments." Does that mean there is too much going on or does it mean I haven't structured the code right? TotalAnnualizedReturnDollars...

When I run the query the result is #ERROR. How do I use the Nz() function

I've tried the following and none of them work.. 1) LCHTotalInvestment: CCur((1.025*[ACPurchasePrice])+[WAI2]+[WAI3]+[WAI4]) 2) [ACPurchasePrice])+[WAI2]+[WAI3]+[WAI4] The values in the referenced columns are set as currency. What am I doing wrong?

When creating an attribute with a validation rule such as "lch" Or "ls" is it possible for the cell to display the two options when the cell is selected (with the ability to click on one)? Thanks for the help