Recent content by SPDurie

Please help... I need to be able to lock-out/disable most of the fields on my form if one field has "APPROVED" entered into it. If "DISAPPROVED" -OR- "PENDING" is entered into it, all fields remain unlocked/useable. Thanks.

I have a budget management report for the 1st Quarter. It has 5 subreports, reflecting annual info, some linked, some not. The rest of the three qtrs of the year reports are identical without this problem. MY PROBLEM: When I run the 1st Qtr report it says in the bar right above the start bar...

Ok. I'm new at this expression stuff. The expression below figures out the percentage of what they have left to spend out of the budget. It works fine if they're on the plus side of their budget, the problem is that once the percentage figures out negative. What should I add to the...

Thanks that worked great! But it caused a new problem...the problem of -0-. How do you get rid of "#Error" when there's no data to work with?

I know this must be an easy one, but I can't figure it out for the life of me. I need to subtract the total from a field in the subreport from a field in the main report. Any thoughts?

I don't know if I did what those links suggested correctly. On one, it only listed what was in the query. But it didn't differentiate or list the categories I needed. I'm sure it'd would work if I knew what I was doing. It would list everything! What am I doing wrong? Thanks.

I'm not skilled in the ways of VB so I hope the answer involves a query and/or macro. On my form I have two combo boxes one has a list of offices in my company. The other has 42 categories the company can spend from. The problem is that I would like to limit the choices a person has in the 42...