Search results

Yep. That seems to fix the problem of the disappearing people. So we know it's the code/event causing the problem. Leaves me with the problem of the oversized email addresses (the client wants them not to split onto two lines if possible).

Thanks. :) I think you are on to the problem there. There is some code in the "on print" event in one of the sub reports that shrinks the font of the email address if it is above a certain number of characters . If Len(fldEMail1) >= 29 Then fldEMail1.FontSize = 8 ElseIf Len(fldEMail1)...

I have a database which stores information about clubs and their staff. I have a report which I use for printing a directory of each club in alphabetical order and their staff, with different staff types in 3 columns (subreports). On each club form on the database, I have a button that will...

Hi, thanks for the reply. The columns have to be sub-reports (and there have to be 4) because each column is showing different information from different queries (and are also different widths), which is also why, I think, that the columns facility will not help me. I do print to PDF (because...

I am producing a report to be printed as a directory of names and addresses of clubs and their members, printed in four columns. Each column is a separate sub-report and I need every single available millimetre of space on the page, so the less I can waste on margins and padding, the better...

Ah. We're talking about the page margins on the sub-reports? I never even look at them on sub-reports. They should be set to 0, presumably?

Is that the left and right "padding" in the child container's properties?

Hi, What are the rules concerning the relative sizes of sub-reports and the "child" containers that they fit into? If I have a sub-report with a detail width of 3cm, can the "child" container on the main report be width 3cm without obscuring detail in the sub-report or does it have to be a...

Hmm. Yes. I had several O'Thises and O'Thats in my data. I had to edit the apostrophes out and then re-edit them back in again. I thought that you had to use double quotes and single quotes together? Would <<strCriterion = "[fldFirstName] = "" & strFirstName & "" AND [fldLastName] = "" &...

The parenthesis was my next guess, but the extra not seemed to do the trick ok. Not at all. You saved me a massive amount of time manually checking 2000 records :) :) :) It never would have occurred to me to create a small recordset with the search string rather then searching the larger one...

Ah. Got it. If Not RS2.EOF And NOT RS2.BOF Then And I had to zerostring strDupes for the beginning of the next loop. Many thanks. George

Thanks I can't get it to work yet, though. I had to add two Thens and an End If to get it to compile. I think I put the End If in the right place. It creates strCriteria as it should and then opens RS2 with a recordcount of 1 ok. But it then doesn't trip the "If Not RS2.EOF And RS2.BOF...

Possibly. It's not always easy to spot them, because the info is seldom exactly the same.

I have been given a spreadsheet of people who have attended past events held by the club using my db. The available information is only FirstName and LastName and the event attended. I want to add them to my tblEventAttendees table. I have written the following code that will search my...

Bad wording on my part. At the bottom of the report, it is grouped on ClubName and then sorted on ContactName, with A on top.

I'm pretty sure that's not the case.

Yes, it is. However, it's not calculated directly in this report. The report gets its data from qryBookSecretaries, which gets some of it's data from qryPeople. Contact Name is a calculated field in qryPeople.

Ok, I have worked out that the missing records are somehow caused by having a group sort on the Contact name (eg: "Bowyer, George") field in the secretaries sub-report. If I take the sort out they're all there (but in random order). If I have it in, most are there, in alphabetical order, but...

I have quite a complicated report that prints a directory for officials in clubs. There are three columns in the page and each column has one or two sub-sub-reports in a column sub-reports. Whilst proof-reading, I have observed that certain people seem to be being omitted, seemingly at random...

Well worth a look from the beginning on demand. I'm not usually greatly into US comedy, but I have loved every minute of BBT