Old Access Macro not running all steps in Access 2013

[evil1966]

In a legacy database originally built in Access 95 and now in Access 2013 I have form that runs a simple macro. Originally it opened a table - used sendkey to select all records and delete them, then closed the table. Then it ran an append query to add new records to the table. The append still works, but nothing gets deleted in the table. I thought creating a delete query and running that then the append query would work (see attached) but I'm still just adding more records to the table.

Any ideas?

Thanks!

 

[dhookom]

What is your delete query SQL and the code you are running?

Duane
Hook'D on Access
MS Access MVP

 

[evil1966]

Thanks for the reply!

The delete query deletes all records in the table and works fine when I run it by itself. I have no code as the jpg I attached above shows:

SetWarning
Warning On No

Open Query
Query Name qryErollmentForm Delete
View Design
Data Mode Edit

Open Query
Query Name qryApplication Form
View Datasheet
Data Mode Edit

MessageBox
Message Enrollment table has been updated!
Beep Yes
Type None
Title

I get new records from the append query and the message box.

 

[dhookom]

I don't use macros but I expect you need to change the View of the delete query to something other than design.

Duane
Hook'D on Access
MS Access MVP