Recent content by richlewt

Hope I dont mind, you have just eased a major headache of mine !!!! I owe you one Pat. I see what you are doing now but I have been looking things totally differently. The issue hinges around what you are storing in tblMain. I have been trying to store the actual text in there i.e. "Dog" "Boxer"...

Ooh! wish you would tell me where? This is sooooooooooooo frustrating. I understand now about data type and have the combo box at least selecting the correct breeds from what you select in animals :) (lets face it, this is an achievement for me) BUT then get the error message "control cant be...

Hi Just to keep this thread flowing, and let all us beginners informed here was a pm I got back from Pat on the above post. "You put the code in the wrong place. When someone gives you VBA code, it needs to go into a sub or function in a code module even if it is only a single line as in this...

Hi Pat May i say a big thanks for taking the time and trouble to reply to my plea for help on the cascading combo saga. That was a great answer and the kind of thing i was looking for. I thought that to save the same question being asked time and time again a simple example with a solution...

Hi Mile Thank you for taking the time to respond. i will have to go away and think about this. Sorry, but I am only just starting at this and need to understand "get the continent from a DLookup() domain aggregate function" :(

Hi Apologies for starting another thread on the same subject but felt that anyone searching in the future would find this easier and maybe would help them as well. Its a question that has been asked before, I have tried to understand the answers but have struggled as some answers are very brief...

Anyone, PLEASE

Hi Major apologies for continual posting but its driving me mad!! I have added all relevant tables now and am just short on how to write the query for v_categories_name_2 which needs to get its values from what is selected in the column imediately before it in v_categories_name_1. If anyone...

Hi I have had a read through the notes on cascading combo boxes and tried including the example into my simple database but no good:confused: I have included a copy of my database in this post should anyone get 5 mins, what I am trying to achieve is the following: On the form top right hand...

Many thanks for that, thats the kind of thing I need. In that exammple there are 2 tables tblContinents and tblCountries. How do you make these 2 tables populate a tblMaster from the selections made? i.e. you select asia- africa and these values need to be written to tblMaster? Sorry if this is...

Hi I am new to Access so please excuse this basic question. I am trying to set up a database with the following functionality. Simplified fields used for clarity. main_table fields: ID category sub_cat1 I guess i will need 2 other tables, one for category and one for sub_category. Now heres...

Thanks Tim, now that makes sense, I will give that one a little go. Thanks again for all your help.

Hi Thanks for your reply, I could indeed store the prices in the invoices/order table but I really wanted it to look for the latest prices in the items table and apply that price whatever it is in that particular point in time to that item, otherwise I have to keep manually typing in the price...

Hi Please excuse me for this basic question but here goes. I am trying to write a simple database to handle a stocklist and orders. One table contains all the items and one table contains the orders. I have created all the links and everything is fine except for when I change the price of one of...