PhilipEwen
Registered User.
- Local time
- Today, 14:12
- Joined
- Jun 11, 2001
- Messages
- 81
hi, i am using the between function to pull records from my rates table between txt_date and txt_date_to.
It therefore finds all those records ok and displays them on a form, with "warning, you are about to overwrite exisiting data below".
Hit the Proceed button and i run a delete query based on exactly the same query as before.
That would be fine, but sometimes if i enter a date perios of 10 days, and only 5 existing records are displayed, my delete query goes mad because it cannot delete non-existant records 'between' these dates.
( actually what happens is i get a message saying 'a problem occured while access was communicating with OLE or ActvX control......' - which i think is basically it )
On this basis therefore, can i base a delete query on the 'found exisiting between dates query' ? if so how ?
If not, how do i perform this 'simple' function ??
Thanks
It therefore finds all those records ok and displays them on a form, with "warning, you are about to overwrite exisiting data below".
Hit the Proceed button and i run a delete query based on exactly the same query as before.
That would be fine, but sometimes if i enter a date perios of 10 days, and only 5 existing records are displayed, my delete query goes mad because it cannot delete non-existant records 'between' these dates.
( actually what happens is i get a message saying 'a problem occured while access was communicating with OLE or ActvX control......' - which i think is basically it )
On this basis therefore, can i base a delete query on the 'found exisiting between dates query' ? if so how ?
If not, how do i perform this 'simple' function ??
Thanks
