Deleting an upload from access

Resolved · High Priority · Version 2016

Tue 30 Oct 2018, 11:47 Delegate Manny said...

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

Tue 30 Oct 2018, 20:12 Trainer Jens said...

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

Wed 21 Nov 2018, 16:40 Delegate Manny said...

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

Tue 6 Nov 2018: Automatically marked as resolved.

Training courses