Search results

I have about 30 more fields to place in the detail section of my report but I get the error message "the control or subform control is too large for this location". Any recommendations? Do I just need to insert page breaks? Thank you.

Hello: I'd just like to insert a 20 page Microsoft word text file into access. I've tried using reports and inserting the file in an unbound object frame but it does not seem to work and the file is not visible as a report. Any suggestions are appreciated

Hello, I am generating a report, Trying to do If box 1 equals Yes, insert "text" If box 2 equals Yess, Insert "text" The problem is that in nested if and regular iff the expression stops as soon as it finds a true value. Regular IFF creates formatting problems because say I...

Hello, Is there a function that does not stop when the expression evaluates to True? e.g. If field one equalys yes, insert X (don't stop) if field two equals yes, insert y If field three equals yes, insert z, (etc...) Thank you.

There had been no error for the last year, now suddenly today I receive the error - Undefined function 'date' in expression for the following: UPDATE Table1 SET Table1.[Days in House] =DATE()-[Mod Received Date] WHERE IsNull([Mod Resolved Date]); DATE() is simply the current date and I don't...

Hello: In a calculated control in a report, I put the following syntax: (DCount("[Mod received date]","table1","[mod received date]>=[forms]![dialog]![date1]") This isn't working, I think because I am using dates and need to put in #s? However, what I really want to do is count the mod...

Hello: I checked Limit to List Yes and placed a macro in On Not In List. However, once the user types in data that is not in the list, I get this pop-up error message - "The text you entered isn't an item on the list, Select an item from the list, or enter text that matches one of the items...

Hello: I have a table with fields Name and Contract. A person may be listed more than once with several contracts. In the query, I just want to count (records), that is the number of times the Name appears. I tried a Totals query, replaced Count in the name field but it puts a 1 as output...