Search results

thanks very much for the reply - the demo helped. one more query needs answering though, please: is there a way i can put a an image control on one of my forms and set the criteria so that it has to equal that of the current record? e.g. if u are displaying registration number: "F423FDS" then...

hi all - i know there are many threads relating to linking pictures to records etc, but forgive me for asking one more time: I have managed to get pictures into my dbase - using Microsoft KB help - by linking them in a table to an external source. However, I want the dbase to know which...

thanks for your advise. i have now used forms instead - much easier! :)

hi - currently i have an append and delete queries to first put cars that are "sold" into the soldcars table. then i run a query to delete this car from the cars table. problem is, i have invoice for all these cars. when i delete the car from the cars table - the invoice goes too! i would really...

thanks for the quick reply. so would it be safe to delete that field from the table, e.g. in my case it would be Final Price ? thank you

hi - i have tried search for the solution to my query - but to no avail, so here goes: I have a query which is based on more than one table. In the query, I have specified a calculation, eg. Final Price: SUM([Sale Price] - [Discount]) From this query I have a form, just showing everything...

its ok - got it sorted. thanks for your help Pat

thanks for ur reply - however, i do not think that is what i need. my cascading combos work fine. however, i want to be able to do a search on "make" or "make" and "model". I have an unbound textbox which is requeried after a selection is made. however, now that i have a JOIN query, the record...

hi Pat, thats great. the search form now shows the actual names. however, there is one more problem :o I used to be able to search using "Make" or "Model" or "Colour" or all of them - but with this JOIN query, I can only search for "Make". If I try and search for "MODEL" it makes me have to...

hi, thanks for your reply. when i tried to create a union query, it asked me for some SQL code. if anyone can advise me as to what i should put in, i shall be grateful - as i have never used a union query before. thank you

Hi,I shall be grateful for any help. My problem Tables: Cars Customer Invoice TblMake Tbl Model I have used cascading combos for Make and Model. They work fine. I have set up tblMake as follows: ID Make I have make tblModel as follows: ID Make Model I use these cascading combos on a form. The...