Search results

Problem solved I realized what the problem was!! Instead of using IIF I was using IFF. Thanks for your help Sue.:)

Thank you! That clears my understanding a great deal.:)

There is a box asking for a parameter value. Hi! I tried the IIF statement. However when I do that a box pops up asking for a parameter value. Also, I should mention here that [value2] is also a calculated field. Any reason why this shld happen and any suggestions as to wht can be done...

I am creating Macros which first run queries and then run the report based on those queries. The problem is that to run the Query it seems that you have to first open it within the macro, run it and then close it after which you run the respective report. This causes the screen to flash with...

I am creating fields in Access Reports which are calculated from other fields in the Report. The problem is that if there is a division by zero, it gives an "error" listing on the report. I would like to know the code that can be put into the Expression Builder so that if there is an error it...

Thank You! That solved my problem. I was trying to write a subroutine which checked a column for duplicate entries, when a cell in that column was changed or a new one entered. Thanks again.:)

I am a very new VBA programmer for Excel. I would like to know how to do the followinG I am using a worksheet_Change event handing procedure. When a cell is changed the active cell is changed depending on which key you use. (ie if you use the right arrow key, the active cell is one cell right...