Search results

I have one major prob with my system. I have been told you are great at sorting out append queries. Can you e-mail me so i can reply to ur e-mail..sending you my zipped system. Its only small. PLEASE thanks

Can I send you my database and you can see if u can solve it?

hi,I have asked this b4, but il try again. I have a database that creates a table with an append query. When i update the append query there are many duplicate records in the table. I have tried using customer ID as a key field, but this only allows one customer to have one video.I want one...

Dont I need to enforce the relationship for it to work though? I tried it without it and when i opened it after entering some data, there were numerous numbers of duplicate records.

Data in 'Customertbl' violates referential integretity rules!

Hey people, Have any of you ever tried 2 create a video shop database? I am trying 2 create one and cant seem 2 solve a certain problem. I have a purchase table, that's updated with an append query. I want the append query to stop repeating records, but i still want to be able to let one...

I tried this, but i cannot enforce the link between customer ID and purchase ID.

Is there a way of stopping repeating records in an append query???

Can anyone help on this?

Hi I have a problem with my database.I have an append query creating another table in my database. The database is designed to be used in a video shop. I previously asked on here how I could prevent the repeating records from appearing in the appended table. I was told to put customer ID as a...

Hey again, AMAZING it all works, accept i get an error. "Vidz Rentals can't append all the records in the append query" Vidz Rentals set 0 field(s) to Null due to a type conversion failure, and it didnt add to record(s) to the table due to key violations, o record(s) due to lock violations...

Hi, Thats great it has 99% solved my problem. The only thing now is that I have duplicate records in the table appearing. how do I remove these duplicates? Thanks

I am designing a database to store and calculate products + prices in a video shop. I have created a query to calculate amound due etc, but i want to create a table for recording all transactions made. In the query you can to do this using the make table option, but when you update it again it...

I am designing a database to store and calculate products + prices in a video shop. I have created a query to calculate amound due etc, but i want to create a table for recording all transactions made. In the query you can to do this using the make table option, but when you update it again it...