Search results

Look at the options under View on your toolbar.

Here's an idea Make table with your questions in the field name, make data type Number with a Lookup wizard. In Lookup wizard assign the values your subjects should choose from such as 1,2,3,4,5 with 5 being the best rating for the questions. Make form with control source this table you just...

Email as Text Rich file sends as a Word document on the forms I have with no problem. Have you tried this option?

Still working on this and sometime back I put a msg box on no data event to pop up that says "No records to report" to try and make this look a bit more professional. As you say the query produces no data for the report because in this case the two columns being compared are the same. So...

Conditional Formatting You can also select the control(s) you wish to color and select Format on the toolbar, then Conditional Formatting and make your selections there. Thanks for the question, I did not know how to do this until I looked into this deeper in response to your question!

Would this work for you? How about using a command button on your form that activates an append query to saves your data to the table? I did this with a subform.

Compare Data You can do this type of formatting in Excel very easily. In Access one of the programmer gurus could probably tell you how. As a non-programmer I am doing this through queries that compare the two columns. Eg: BeforeAge<>AfterAge as criteria in the query. Then I have a report...

Ah, well, =Sum(IIf(IsNull([fieldname]),0,1)) does not give the syntax error I was getting previously, but I still get the #Error.

=Sum(IIf([fieldname] IsNull,0,1)) "The expression you entered contains invalid syntax. You may have entered an operand without an operator." I have looked at this many times and called over a co-worker, neither of us can see what is different in what I typed in and what you suggested.

I wish I could but it's too big and contains sensitive information. DB design is several tables each with many fields. Eg: Age, DOB, Address, etc. Most fields contain data to compare before event and after event. Other fields are identifying information, SS# etc. Queries pull information...

Ok, none of this has worked so far I have been reading the forum and trying various things but still have the #Error message occuring on my reports that have no records to report. Sorry to be a pain but if you guys have any other suggestions I really would appreciate the help

Another question about this I have a similar set up with many queries / reports and need one field in each report footer to show up on a main report. How can I do this? Or can it be done? If not does anyone have another suggestion?

Memo Field size A Memo field can store up to 65,536 characters. What is the source of your report? If table go to design view and change data type to Memo.

To clarify . . .? When you say button window do you mean button on a form? And if so, can you close this form with the second action statement in the macro? Before I told the form with the buttons on it to close at least the form would minimize when I opened the report so I have not had your...

I have similar command buttons but I do it the easy way since I am not a programmer. In design view place a command button right click to select Build Event and then right select Macro. Under the Action heading you select what you want the macro to do. In this case Open and Close-two different...

rosemere,look at Look at your the forms in design view, select the form (you'll see the left hand corner has a black square on it when form is selected). Right click, then look at the bottom of the menu that opens for Properties. You'll see the code written in this section.

Hey Mike! I am working on a similar problem. I have multiple reports with the report footer returning a count for me. Do you have any suggestions on on to do a summary report that would list all of the counts from the multiple detail reports I have. I thought about subreports but I only need...

Well, I played around with this a bit with these results. Changing the control name had no effect, if I put in the Nz part in without =Count the results returned are blank instead of #Error. I would rather have a zero "0" in the field instead of blank. My ultimate goal is a summary report...

Same thing happening I am still getting the #Error on the reports with no data. Is there any other information that I may be leaving out to solve this problem?

I need help with a Count function. =Count works fine unless there is no data in the report then I get #Error. I understand why this is happening but I can not correctly format the function to count the data but IIf IsNull then count as a zero and return total number of items in this field...