Manny has attended:
Access Intermediate course
Access Advanced course
Deleting an upload from access
Hello Guys,
A controversial one but nonetheless important. The core of my data is split between 5 tables. common in each table is date and fund. If the user uploads the same data twice it will cause significant errors into the data. I have a control in the database to ensure that this is flagged however to remove the data could be troublesome.
Im not sure how to write a query to delete this "upload" out of each 5 tables. I have a drop down menu and a calender icon to select the data but im unsure how to structure my delete query accordingly. Please advise?
Manny
RE: Deleting an upload from access
Hi Manny,
Thank you for the forum question.
If I understand you correctly you want to delete
duplicates.
I have used the method from this video:
https://www.youtube.com/watch?v=amRbEhQWH78
if you want to use a delete query you need to be able to define the criteria for the delete query. Based on the facts in your question I am not able to define, which criteria you can use.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Deleting an upload from access
Hi Jens,
It may not always be a duplicate. I have created a form where the user must select from the upload date and the code.
the upload date and the code is in all 5 tables. I have designed the query to delete all the records where upload date = calender and code = code selected in the form.
It returned the error could not delete from the specified tables? I am really not sure why this isnt working. Please may you review.
manny
