Search results

It's sorted!! Thanks Demicay2669! I deleted the old combo box and created a new one and that solved it. Still find it quite bizarre because none of the previous settings (for multiple values) were stored anywwhere either in the table or the form. I wonder if anyone could comment on this...

Dunno why it never occurred to me to just remove the combo box and put a new one in D'OH! Let's see what happens :)

Sorry just realised that my reply to demicay2669 "Did you create your data type using a lookup wizard at table level? If so the lookup wizard gives you an option to select "Allow Multiple Values" which will give your combobox the checkboxes in your dropdown list. I'm not sure about other...

Thanks for your reply. The data type is 'Text' in the table. At some point a lot of my fields had multiple values allowed at a table level, but I changed this when it was pointed out to me that this was bad practice. I wonder if there is a glitch that is causing the previous setting to...

Hi there, I hope the title isn't too confusing. Hopefully I can encapsulate better here. I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to...

Thanks Gina. That fixed it. While I was digging around in exasperation today I found the object dependencies tab and tblSiteInfo was dependent upon a randomly named field that didn't seem to exist, it was deleted from the dependencies tab after the compact and repair operation that you...

Hi everyone, The Problem: When I try and open one of my tables tblSiteInfo in datasheet view I receive the following error: 'The Microsoft Access Database engine could not find the object ". Make sure the object exists and that you spell its name and the path name correctly' This only happens...

Thanks again. I got it to work today after a few niggles (something about not being able to find objects). Anyway currently it's working (i.e. I can select different countries from the locations table as participants in a conflict) although when I open the Conflict form I do get the following...

I mean I can't find all the properties. I'm using access 2007.

Thanks for the explanation. Definitely a steep learning curve, but I feel more on the right track now. Hit a minor obstacle, I can't find the properties specified here in my property sheet. You can see that in the image I attached to post #5

Just wondering, is the creation of this new tblLocations to enable a many-to-many relationship between countries and conflicts?

Cheers CJ. That's a lot to take in, but I'm sure it'll be worth it once I've processed it all. As for the CountryID in Conflict table I put that there because I thought it was necessary as part of the relationship between the two tables. I did it through the Relationships diagram by dragging...

Much appreciated. Great site too, really lays things out in basic terms.

By 'Target field' I mean the field in the Conflict table that will be the repository for the data retrieved from the Country information table. Is this the control source or the row source? I hope terminology isn't getting the better of me. With regard to storing multiple values, it's because...

Thanks CJ_London, I've started revising the way the database/tables/forms are set up. I'm going to use the Conflict table and the Country Information table as an experiment as they're the simplest and then hopefully implement similar forms for the other tables once I've got the hang of it in...

Hello there, I've designed a database at work to collate information about locations around the world that are contaminated by conflict and military activities. I'm struggling with the use of the lookup wizard to populate some fields in one table from another table. The database is ultimately...

correction: Apologies there's no link to the project. I had to remove it and forgot to correct the reference. If anyone is interested then google 'Toxic Remnants of War' we're the first result

Hi everyone, Just thought I'd say hello before posting my query. I'm an atmospheric chemist working on a research project (see link at end if interested) gathering information on contamination and public health problems caused by conflict with a view to creating better protection from the...