Search results

Hi Pat, Using the qryAllResults as the record source was indeed the problem. The control source DCount expressions in all the report text boxes that reference the query work fine without the query as the record source. Now my report is down to the two pages it's supposed to be!! I need to...

Hi Pat, I didn't know how to post the record source query, so I whittled down the database to the bare bones in order to be able to attach it. I deleted most of the records, which has pared the report down to 20 pages instead of 232. Many thanks for taking a look at it! rntkid

wazz, I don't have the report sorted or grouped, and the query works fine by itself. Pat, I only have one table in the database. Thank you both for your help!

I created a database to analyze test results. There is a text field for each question number, total of 64 numbers. Each question number has a combo box with 4 choices: correct, partially correct, wrong, and blank. After entering all the test results, I created a report with text boxes for...

I don't know how to write that kind of expression. Can you help me with that?

I copied and pasted your due date expressions into the query. After running the query, it produces blank due date fields in all the query records. And on the form, the due date field is blank until I add a new record...then I get the #ERROR in the due date field. When I fill in the...

Sorry to be dense, but now I'm lost. The record source for the form is the query that has the date/time field "WorkdayRecd". The three due date fields in the query are based on that field using your PlusWorkdays module. They are: 2DayDue: PlusWorkdays([WorkdayRecd],2) 27DayDue...

On the form...

I tried putting IIf(IsError([2DayDue]), " ", [2DayDue]) but the field stays blank after I update the [WorkdayRecd] field. Any idea what I'm doing wrong?

Okay, one last thing. When I create a new record, the three due date fields in the form that use the PlusWorkdays module fields created in the query as the control source show "#ERROR in them until I fill in the [WorkdayRecd] field. Is there any way to suppress the #ERROR?

It's working now... I was able to figure it out. I needed to reference the name of the module itself rather than the name of the field expression in the query criteria. So instead of >[ModuleFieldName], it is >PlusWorkdays([WorkdayRecd],30). Thanks so much for replying... rntkid

Sorry to bother you again, but I'm not quite there yet. When I went back into the real database and tried to update all the queries that I deleted to get the Db small enough to post it as a ZIP file, I ran into a problem. There are a number of fields in my queries where the criteria includes...

OMG, it works!!! I have tried so many modules over the last year and changed the name of the holiday table date field so many times that I never even noticed that there were spaces left over. I can't believe that itty bitty brilliant module of yours works like a charm. I could kiss you...

Okay, I have pared the Db down to the bare bones. You will see two queries with similar names. One is titled "qrySIRCompliance"; the other is "qrySIRComplianceTest." The first one is the one in use now. The test one has the "PlusWorkdays" module as a field called, "2DayTest." The field...

I would love to have you take a look at it. The records in the database are confidential, so I'm going to make a copy, delete the records and make up some fake records up so you can see it in action. I'll post it then, but can you tell me how I go about posting a file?

I've checked my tblHolidays again, just to make sure, and everything appears to be correct. I hovered over the PlusWorkdays to see what the date is. It said, "PlusWorkdays = 6/6/2006" (quotation marks are mine). Since I'm pretty ignorant about VBA, I have no idea what to make of that. The...

I set it to "Break on All Errors," but I'm not sure what I'm supposed to do next. I tried running the query again and the same thing happens: The same three lines of the module are highlighted in yellow with a yellow arrow in the left margin pointing to the last line. If Weekday(PlusWorkdays...

Hi RG, Thank you so much for responding! I actually don't have the apostrophe in the field name, just a force of habit when I typed my question (sorry!). The "WeekdayRecd" field is a date/time field. I named the standard module "basFunctions", as you suggested. Thank you again, rntkid

PlusWorkdays Runtime Error Hi Rural Guy, I've tried to get the PlusWorkdays module with the holiday table to work, but I get a "Runtime Error: ‘2001’ You cancelled the previous operation" everytime, which freezes the application. I'm using this module, which I copied from another website...