Search results

Hi, horse_entries table will have ent_HorseName (PK) (horse name) ent_entries (races horse is entered for, for example my dad uses T8 one race that's coming up) horse_information will have inf_HorseName (horse name) inf_Ground (info on horse ground preference if there is one) inf_Notes (notes...

Works brilliant, thanks :)

Hi, I have these two tables horse_entries ent_HorseName (PK) ent_entries horse_information inf_HorseName inf_Ground inf_Notes I have no records in horse_information yet. I need it so that when a record is added to the first table then whatever is added to ent_HorseName is added to...

That works great, thanks so much. You have saved me so much trouble :D -EDIT- One more thing, sorry. After the brackets are removed there is a space left. Could that be removed with the brackets? When I am checking the horses against those running will the space count as a character? Thanks

Hi. I done this, it works great for removing the brackets but it's deleting those without brackets completely. Was I supposed to run a query to find those with brackets first before running the update query? I have made several backups until we have it working. Thanks :)

He has the country identifier left in some of them, so I'd need to do the same to his list. I don't know what to put in. Can you help me? I have attached my update query where you can see my field and table names. What should I put in the 'Update to' section? I really appreciate your help :)

Thanks, worked great :) I am wrong, it's a one-to-one relationship. I have enforce referential integrity turned off. The problem is I have a lot of data all in .txt files I have to get in my table. Is this possible using forms? I have tried importing them but I need an entry to be placed...

Hello, I need help. I have two tables. horse_entries ent_HorseName (PK) ent_entries horse_information inf_HorseName (PK) inf_Ground inf_Notes It is a many-to-many relationship. When I open a table and enter a record there is a small + sign that allows me to open up the rows from the other...

French horses have two letters (FR) Thanks, I have changed it On the web their is a list of the days runners in the cvs format. I was hoping I could compare the horses from the horsename field against the horses in their table. Sorry for the stupid question but where do I put this? Will...

Hi, I am new to access. My father likes to gamble and has lists of horses he likes to check to see if they are running. He is currently using Microsoft Word and has to check each one by one. I thought if I could get the lists in to Access then it would be a lot easier. I have a field called...