deleting upload access

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Deleting an upload from access

Deleting an upload from access

resolvedResolved · High Priority · Version 2016

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

Tue 6 Nov 2018: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Add date to a field

Press CTRL+SEMICOLON

View all Access hints and tips


Server loaded in 0.12 secs.