Records automatically deleting

[sthapa]

All

I am having a problem with records on my database automatically deleting themselves after they have been saved. Im not quite sure how to diagnose it

Any ideas

Im using Access 2000 with around 6 users

 

[Fizzio]

It is not likely that they are being deleted when saved (unless someone is deleting them ) but more likely that they are

a) being overtyped
b) not being saved in the first place due to some data violation eg duplicate key values etc.

I suggest look at (b) as your first problem (look at your data structure and see if it possible to duplicate primary key values)

 

[pony]

Automatically delitig

I am having a problem with a forms which I want to delite automatically in a time which I set. (Access 97)

 

[pony]

Haloo!
I made a form,which will be next year unusfule and i want to know,how to set the form to be delited on the time which I adjust.. ( form must be deleted avtomatcly on 01.01.2005)
Thanks

 

[sam77755]

Hi

to delete the form

1- you have to check the date every time DB opens..say on a splash form
2-create a control(check box) and make it as small as possible almost invisible.
3- write an if statement ie. if date() >= 01/01/2005 then docmd.deleteobject "......".
4- then set focus on your new control
3- on the new control write a code on the setfoucus event that deletes your function checking the date.

this should work just fine .. the first time..

 

[pony]

Thanks you. I will try.