Recent content by daniel.winson

Here is the SQL if it helps... SELECT organisations.organisationName FROM (organisations INNER JOIN ((locations INNER JOIN organisationLocation ON locations.location = organisationLocation.location) INNER JOIN postcodes ON locations.location = postcodes.location) ON organisations.ID =...

Hi, I am trying to design a query that will ask the user for a 'postcode' and return a list of organisations that operate in that postcode. My database has two junction tables organisationPostcode and organisationLocation as some of the organisations listed operate in specific postcodes...

This is great, thanks so much for your help. It will take me some time to digest how you did it so I can use it in the future. But basically you've 1) used VB code linked to a button to clear all existing records in the subform and then add all possible records? 2) Changed it forces unique...

I found where you had added the option using a union query, I suspect that this isn't going to do what I want (and chances are neither was the VB method I was trying)... I possibly didn't expain it very clearly here, I've attempted it again under the forms help forum with hopefully better...

Sorry, this is giving me a different error now... "You cannot add or change a record because a related record is required in table 'locations'"... <All> is now showing up in the combobox though, so it looks like you get what I am trying to do. It just seems to be failing when trying to create...

Hi, I have an entry form "frmOrganisations" where a user needs to add multiple entries into a subform "subLocations" from a fixed list (in this case a list of locations serviced by an organisation). Can you add all possible unique records using an [add all] button, check box, radio button...

thanks very much for the reply, but the attached database gives me an error "The number of columns in the two selected tables or queries of a union do not match"

Hi everyone, I tried to implement an (All) option to my combo box as per this article http://msdn.microsoft.com/en-us/library/bb457185.aspx. I thought I followed it exactly but for some reason when I try to open my form or the subform it crashes Access. ! was hoping someone could test it (I...

Thanks for the help, honestly I think I might just take the easy way out and make the database for Scotland only, the rest of the UK was just future proofing it anyway.

Hi everyone, I am implementing a contacts database that will store details of organisations across the UK that provide Multiple Sclerosis support services. Some organisations service the whole UK, others just a country, others just a region. End users will search by postcode to find...

Thanks again for your help, it is really appreciated.

like it... I love it.. thanks heaps... I'll have a play with it and will hopefully be able to make it work. Cheers Dan

I have fixed up my naming convention, thanks for the advise. I've attached a new attempt at 'nesting' the forms within each other, but don't understand how to set it up in a way that will allow me to add an organisation + populate the junction table with all locations/services. Thanks for...

So is there any way, even if it includes changing my design, that I can get the entry method I am after?

OK, that kind of makes sense but I don't fully understand how to implement, I've attached a very rough attempt at what I think you mean... am I on the right track? Thanks again for your assistance, it is good to know there is a solution out there and that I just have to learn how to implement...