Search results for query: *

Is ACCOUNT.LETTER a date field? Looks like text. Try: WHERE ((([ACCOUNT Query].MAJCOM)=&quot;PRIMARY&quot;) AND (CDate(ACCOUNT.LETTER)<DateAdd(&quot;yyyy&quot;,-1,Date())));

Need each department's data to start on new page. Setting Department Header Force New Page to Before Section leaves first page without data. Setting Department Footer Force New Page to After Section forces Report Footer to new page (undesirable, especially when the report is limited to one...

Have you double-checked your tab order? Can you get to a new record via navigation buttons? I've added a &quot;next&quot; button at the end of a form before, but there was some other specific reason for that.

Nothing equals Null. Try IsNull([IncidentDescription]).

Look at the InStr function. You probably want something like: Right([fieldname], Len([fieldname])-InStr(&quot;>&quot;,[fieldname])) (check all syntax - I'm a little out of practice)

Are the Section's CanShrink and CanGrow properties also set to yes? Try decreasing the spacing between subreport controls until they all touch, no white space between and no overlap.

Don't know about tab controls, but your form has a Cycle property you can set to Current Record.

You can link to all your tables, and use a union query if you want to use them all together again. Why do you need to keep each year separate, and how else were you thinking of accessing them again?

Good point, Michael. I took the question literally and figured it wasn't going to be used on Monday.

Why in the world would you want to do that?

Between Date()-weekday(Date(),vbMonday) And Date()-1 should do it; got help from the immediate window.

How about Between Date()+1-weekday(Date()) And Date()-1? Or tell the weekday function that Monday is the first day of the week (don't use the function, but have heard it can be done) and skip the &quot;+1&quot;.

Have you tried something like CDate([month field]&&quot;/&quot;&[day field]&&quot;/&quot;&[year field])?

Apparently, the Retreat Sub wasn't running, so I moved the code up into the Format sub. This works now, so I'm posting in case it helps anyone else out. Option Compare Database Option Explicit Private Type CodeStatusType Branch As String CodeRt As String End Type Dim CodeStatus As...

In attempt to undo the calculations performed in the first pass of the format event, I added the following sub: Private Sub Detail_Retreat() 'back up before second formatting If StatusFlag = &quot;+&quot; Then 'If it's a duplicate, previous was the same...

Um, yeah. Concatenating would be simpler than nesting.

You would need to nest your IIfs, more like: IIf([Local School Districts]=-1,&quot;Local School Districts&quot; & IIf([Academic Educators]=-1,&quot;Academic Educators&quot;,&quot;&quot;),&quot;&quot;) IIf(condition1, truepart & IIf(condition2, truepart & IIf(condition3...

The following code marks claim numbers in a report if they are duplicates of the previous claim number printed or if there is a gap in sequence between the current and previous claim numbers. Michael Red got me to the point that this works, except that when the list goes on to a new column or...

If your LoadingCity is Not In List of a combo box, try Forms![PreviousForm]![LoadingCity].text

What in your macro is calling for the dates? Your query doesn't need to be open before the report, but the form does, otherwise Access has nowhere to look for the dates and will ask you for them.