Weird message

[janith]

Hi,

Just wondering if someone can figure this out for me!! I've a form created which imports records from an excel file by click of a button. All this work fine. But off late there is something weird that happens. No part of my code has a delete records code. But when I click this button to append records to my existing table after appending it gives another message if I want to delete all records. I can confirm that no where in my code did I mention anything about deleting records. Can someone explain this phenomena??? Or how to fix it?

 

[jdraw]

Is it possible you are using a makeTable query as part of the import?
A MakeTable will ask if you want to delete existing data (if I recall correctly).

 

[janith]

It is a query based records which I created as a form. So how to avoid it?

 

[smig]

what is the form for ?
Can you post the Import part of the code ?

 

[janith]

The code is similar to this video..https://youtu.be/vQZRadmm7Ho

 

[Uncle Gizmo]

Post the code Post the code Post the code Post the code

 

[JHB]

I do agree with Uncle Gizmo!
Some similar isn't the actual code you've, so ... !
Maybe it could also be a good idea to show the SQL-string from the query.

 

[jdraw]

janith,

There appears to be some reluctance to showing the actual code. If readers are going to help, they need to see the real material --not something like it.....
We all want to help, but we need to see the problem/opportunity.

 

[janith]

Don't have the code on my system. It's at office.. Probably will check back if can send via email