Search results for query: *

A better practice when your want to share code across forms would be to create/use a module and place the code there.

Try this: MsgBox "My count is " & trim(dcount("[NoBuy]","qryResults")) & "."

This is correct assuming the [emd_id] is numeric: TrainerName: DLookUp("[Name]","Active Employee Query","[trn_emp2class].[trainer]=" & [emp_id]) If it's a string, this is correct: TrainerName: DLookUp("[Name]","Active Employee...

Regarding the report layout, all pages are two-columns of even width except for the first page, as is the case for many NLs. The first page has a horizontal header and possibly a vertical 1/4 pg width TOC on the left. There are variations on this layout, but the rest of the pages are all...

I have three detail sections in my test report. The first is text. The second is a chart sub-report (charts can't go in detail sections, why I don't know). The third is text again. The chart starts immediately after section 1 as desired, but the third section writes over the chart. Is this...

Ido, Your tip almost worked, but the section containing the sub-report the chart was overwritten. The two other sections flowed as desired. Could I trick CR into leaving room my placing a hidden field? Is there another way? Thanks again.

I am trying to create a 'newsletter' report with a two-column page layout. The report pulls data from 25-30 different tables, displayed in charts or tables, mixed with text. The report needs to be printed as hard copy, requiring an 8 or 12 page format. We'll also be generating PDF files, and...