Search results for query: *

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

With Access 97 on a network server several users could access a database at the same time. Now, with Access 2010, this facility is no longer present. Is there any way of restoring it, please?

.db should, of course, read .mdb

I have written an Access database in 2010 to be run on a 2003 system. The database (.accdb)ran with no problems on my machine. I converted it to 2003 (.db) and it ran with no problems on my machine. However, on installing it on the machine it was intended for (2003) although it ran with no...

Thanks MajP - I based the form on a query and the problem has disappeared.

Despite the table being in the correct order DoCmd.GoToRecord , , acFirst does not display the first record. Can anyone tell me how to make the command work correctly, please? I'm using Access 2010.