Search results

Update, I just had a look on Allen Browne's website - the field list/property sheet issue is becuase you can add fields from other tables, not just the current record source. Anyone know how to disable this?

Morning all, I wondered if nayone else had experienced this - I'm using Access 2007 at the moment. I'm getting huge delays when doing the following (in the order of 30 seconds - 1 min): Switching between form/design/pivotchart view Switching between property sheet and field list in design view...

Blind they must be! I would take this image and post it back on that forum.... but they wouldn't be able to see it anyway

Hmm a quick google revealed a post that said Chr wasn't in the expression builder of Access 2010... Bob? (I use 07)....

There's a reason you've got a great big star in your signature :)

Whoops I thought we were talking about a control source for a field... lesson 1 - read the bloody original post :D

Right then. Have a look at the query in this DB, and also a look at the relationships. You'll see there aren't any criteria in the query so it brings everything back. You can specify a course name, or use a parameter by putting something like[Enter Course Name] in the criteria for course name

You should be able to use the same query, but without putting any criteria in. Let me have a quick look after lunch and I'll upload something for you to have a look at and understand how it works.

I still think the subform idea is the way to go, bound to a table of volunteer numbers and specialty numbers.....

It's not - I'm just struggling to se how a subform based on a table would check ALL the records when you just click the one. Is the checkbox bound to the field in the underlying table? that might be the problem. You're going about this the right way, by having separate tables for volunteers...

Hi Clare - just had a quick look at this and your database structure seems OK, except the relationships look a bit complicated - they're all automatically created around the primary keys but there looks to be a few many to me, might be worth having a think about. Anyway the PE Classes problem...

Can you upload it? I can't see how that can happen off the top of my head...

Didn't know that! Nice one Stopher!

Dude, it sucked - everything I touched revealed more bodged stuff underneath it.... Still - all finished, and so far no fires or leaks....

Doing good fella - just finished renovating a flat so I've got me evenings back! You?

The other option would be to have your fields as text boxes seprately on the report, then setting the canshrink property to true. This way, if you position the controls on your report so there's a gap in between, you'll be left with the gap if the field is null.

Just beat me trevor G :)

TryAddressfield=[clientname] & iif([address1] is null, vbcrlf, vbcrlf & [address1]) & iif([address2] is null, vbcrlf, vbcrlf & [address2])

So you've got a subform based on a temporary table, and when you tick one record, they all get ticked? I'm assuming each record is different? How is the temporary table created?

Ah I understand - I have a small amount of brain fail today, but my first thought would be this: 1. Create a query based on your merge table, selecting and grouping by zip code. Run it and copy the results. 2. Create a table with an autonumber fields, and a zip code field. Paste results from 1...