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...

IIF and Switch I'm sorry, no that doesn't work because, in my example, the nested IFF expression stops at the first true value and it should continue...

IFF and Switch Thank you, that will work but isn't there something more convenient like case of or something like that?

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.

Never Mind, Found Answer Below A missing reference is causing the problem. Go to that user's computer, open a form in design view and click the code button. Then Tools--->References, a list should appear. If any are marked missing, make a note of the name and uncheck those with Missing. Then...

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...

Thanks IMO, it worked perfectly! Very much appreciated and keep up the good work.

Thanks IMO, I got an error message and could not open your attached file. If is not too much trouble, could you cut and paste the code here so I can get an idea....

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...