Records automatically deleting
- Thread starter sthapa
- Start date
Fizzio
Chief Torturer
- Local time
- Today, 07:23
- Joined
- Feb 21, 2002
- Messages
- 1,885
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)
) but more likely that they area) 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)
- Local time
- Today, 02:23
- Joined
- Feb 19, 2002
- Messages
- 47,578
a) happens when you use a bound control as a "lookup". If that is your problem, just add an unbound combo and use that for finding records and leave the bound control for data entry.
P
pony
Guest
Automatically delitig
I am having a problem with a forms which I want to delite automatically in a time which I set. (Access 97)
I am having a problem with a forms which I want to delite automatically in a time which I set. (Access 97)
- Local time
- Today, 02:23
- Joined
- Feb 19, 2002
- Messages
- 47,578
Pony, I don't under stand your question. It sounds like you are asking how to delete a form based on a timer event and I'm pretty sure that that's not what you are asking. Please try to restate the question.
P
pony
Guest
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
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
- Local time
- Today, 02:23
- Joined
- Feb 19, 2002
- Messages
- 47,578
You could check the date each time the db opens and determine if it is time to delete the form.
However, since I can't refrain from adding my personal opinion, this sounds like a poor design. You should probably do some reading on application design and database design and normalization.
However, since I can't refrain from adding my personal opinion, this sounds like a poor design. You should probably do some reading on application design and database design and normalization.
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..
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..
P
pony
Guest
Thanks you. I will try.
