Search results

Thanks Tess, that's a much better (and less destructive) way of doing it. Thanks again, Mark

It's OK, I think I've sorted it. I just deleted the querys one at a time (having backed up!) until I found the right one.

OK guys, that sounds more than feasible. Now Access for benginners time! How can I track down which one(s) (of a lot) of queries the form in question is linked to and when I've done that, can I just remove the offending fields from said query? Many thanks...

Hi all, I've just been trying to delete fields from a legacy database (not one I created). No problems there however, now whenever I open a related form (not containing aforementioned fields) it asks me to locate them. How do I break the link to these old fields? I've tried searching the...

I've managed to sort it by using multiple primary keys. All the important stuff from the form was in 1 table so I made them all primary keys. Cheers mate!:D

I don't think you can do that in 2000. Also its a form I've got the problem with, not 1 table. The entries are drawn from a couple of different tables.....

Well, assuming I knew how to do that I'm using only Access 2000. D'oh.

I have a form with 7 combo boxes. None of them are unique keys but I don't want the same comination of info put in twice. How do I do it!? Basically I have: Manufacturer Equipment Name Document Number Document Section and a couple of numerical ratings. I don't want the same Manufacturer...

Thats OK. As for Bristol I've only worked here a couple of weeks so I don't know the area that well. Just off the M32 by Filton. Its not bad though. Apart from the traffic that is!:rolleyes:

Thanks but I've got round another way (having been trying all day!) I put a 'like' statement in the second field's query criteria so that it only shows items that are 'like' the previous item. Then I had to add a requery line to the first box and it seems to work now. And I am vey pleased...

Basically, all I need is a bit of code to say, ' after selecting an option from ComboBox 1, change row source of ComboBox 2 to table A ro B depending on whether ComboBox 1 says X or Y.' Simple. :rolleyes:

I've found Hayley's Post and I've downloaded the sample Db but I still don't really get what they've done. This is definately what I'm trying to acheive. I've start by creating two seperate tables with the two list of data I want to chose from. I think the sample Db uses a query to pick from...

Thanks, that sounds about right however, having no knowledge of Visual Basic whatsoever I'm a bit stuck as to how to change the Rowsource of the second combo box. Is there anywhere I could download suitable code?

I want to select an option from a lookup table and, depending on what I select automatically, modify what options are available in the next lookup field. Any ideas?:confused: