Search results

Thanks for that Boyd but I dont see how the example database shows a solution to my problem. Or am I missing something ? Al

I wont even try to explain this problem... If you open the Shopping List form you will see what I mean when you click in the Food Sub Type column Thanks Allan

still sounds like you have a problem with your form though.... err Mr Yank God Bless America

is the database small enough to upload ? If so, attach it and I'll take a look

I do actually have 3 tables... tbl_FOOD_TYPE Food_Type_ID Food_Type (Meat, Fruit, Vegetable) tbl_FOOD_SUB_TYPE Food_Type_ID (from table above) Food_SubType_ID Food_SubType (Beef, Pork, Apple, Banana) tbl_FOOD_VARIETIES Food_Type_ID (from table above) Food_SubType_ID (from table above)...

sorry, my formatting got a bit messed up there so I hope you got the idea

The first table in the Hierarchy is FOOD TYPE and this is indeed taken from a table. COMBO_FOOD_TYPE (Meat, Fruit, Vegetables) COMBO_SUB_FOOD_TYPE (Pork, Beef, Lamb, Apple, Orange, Banana) So, if in the top combo box someone selects FRUIT, the Query will return many rows relating to fruit...

I have a query where one of the fileds might return Food_Sub_Type: Apple Apple Apple Pear Pear Banana Grape Grape If I refer to this field in a ComboBox, it is showing me all the fields (including the duplicates) but I just want the ComboBox to show one instance of each value, i.e...

I have a query where one of its fields is dependent on the value in a combo box. However, if that Combo Box is empty, no records are returned. What do I put in the OR criteria to make sure it returns ALL records if the combo box is empty ? Thanks Al

like this ??

why not have a table ANIMALS and have fields which represent their attributes, like... tbl_Animal Animal_Name Has_Fur (Boolean) Has_Ears Has_Tail etc It would be easy to build the query you describe from this. Or will this not be sufficient for your application. If you have separate table...

Ive not been given any details as yet and I was thinking I might have to pay someone to sort out that part of this piece of work. What are the questions I should be asking the DB Administrator ?

Ive got a couple of spare days. Send me over your tables and I'll do it for ya - NO CHARGE !! I sent you my email address

I'm developing a database but need to reference a different database table (employees) from a different NON-ACCESS database. I will never need to update the data in the external database, just read from it. Im guessing I just need to query but what syntax is used when referencing an...

Thanks everyone. Just one other question. If I have a Lookup table... tbl_Colours Colour_ID (column 1) Colour_Name (column 2) When I represent that in a ComboBox on a form, which should be the bound column ? If column 1 is bound to the database, if I have to import data from a...

Thanks Dave Just one questin though. I dont really see why its a good idea to represent data on a form trough a query. I have managed to sort data on a form in the past by just selecting in that control and clicking the sort button. Also, I didnt think a query could be edited to update the...

How does this attachment look ??

OK, now Im converted about the evil of Lookup Fields and I will NEVER use them again. But, if Im using a Junction tables do I use the Primary Key of the tables or the linked fields ? So, if I have tbl_Club Club_ID Club_Name tbl_Members Member_ID Member_Name Do I use...

Ahhhh - I get it Im converted... Im gonna spend all weekend now putting right all the dreadful Lookup Field errors Ive made... I wondered why my query criterias never worked properly

and what is the preferred way to do it ?? Most access books I have read seem to guide people toward Lookup fields. So what is all the fuss about ? Al