Recent content by NWTrust

Thanks for your time dhookom. I have been 'fiddling' and somehow have solved the problem (I'm not sure how but I don't feel inclined to find out!). Thanks again.

An example of the contents of gstrTester is [Parish] = "Drayton]" to list all entries where the Parish is Drayton. As I stated originally this works perfectly in a form but not a report. I'm not sure what you mean about adding a text box.

Sorry, I should have been a bit more specific. gstrTester contains: [field name] = "word(s) to search for

gstrTester is a string containing a field name and a name within the field.

Hi I need to display selected entries on a form and also a report. The selection is in a variable called gstrTester. The call to the form is: DoCmd.OpenForm FormName:="frmSelected", WhereCondition:=gstrTester. The contents of gstrTester appear in the form's Property Sheet Filter box and the form...

Hi PHV I had a subform with half-a-dozen unbound controls which I populated using the code you suggested. I hoped to do the same thing to a subreport but this didn't work so I created a table with fields corresponding to the controls in the subform which I linked to the table. Populating the...

Belated thanks, PHV, for your suggestion which, unfortuately, didn't work. However, I have solved the problem from anothing direction.

PHV kindly sorted my problem of changing a subform from a function with: Forms![frmRenewalList]![subfrmTotals].Form!PCCount = PCCountHold I would now like to do the same thing with a subreport. I've tried variations of the above with no success. Can anyone help me, please?

Yes, PHV, I did. This is it: SELECT Events.[Event Name], Events.Category, Events.[Number of children attended], Events.[Number of Adults attended], Events.Date FROM Events WHERE (((Events.Category)=[enter category]));

I have 'inherited' a database. In it is a query which looks like a simple Select query but when it is run it produces a table with a bottom line of Totals with the sum of the numbers at the foot of the numeric fields. I would like to do something similar in a database I am working on but I...

Nice one PHV, it works a treat. Thanks a lot.

I can make changes to a form from a Function using the following code: "Forms![frmSomeName].btnFirst.enabled etc". I would like to do the same to a subform but the code "Forms![subfrmSomeName].btnFirst.enabled etc" does not work. Can someone help me with this, please.

After having a flood of returned e-mails, none of which I sent, I now find that, although I can send e-mails I can't receive any. Clicking on send/receive shows something is processing - presumably locked. It also shows a 0x800CCC0F error. Any suggestions, please.

With four or five databases and half a dozen users, some of whom request changes and additions to the databases, splitting is a last ditch solution. Fortunately I have discovered a simpler answer. The databases were all created in Access 97 and latger moved to Accesss 2010, retaining the .mdb...

Thank you both! Look's like splitting the d/b is the answer. NWTRUST