Deleting records

[Chi]

Hi,

I created the database for checking Equipment.

In the DATA ENTRY form, after users entered a date in the CHECKIN column and
close the form, I would like that record is deleted.

Please help

Thanks
Chi

 

[John W. Vinson]

Hi,

I created the database for checking Equipment.

In the DATA ENTRY form, after users entered a date in the CHECKIN column and
close the form, I would like that record is deleted.

Please help

Thanks
Chi

Well, that sounds like a rather BAD idea.

Do you really want to permanently and irrevokably delete the information that
was entered? You enter a date into the checkin column - and then immediately
destroy that date and everything else in the record? That makes no sense!
"Please fill out this form, and then burn it."

If so, please give us some help. We have no way to know what table the DATA
ENTRY form enters data into, what the CHECKIN column means, or what you want
deleted and why.

 

[Stockwell43]

Hi Chi,

What you are asking for is not logical. I am assuming you must mean
something other than "Delete" like closed, disable, non editable or
something. Try to clarify precisely what it is you are trying to accomplish.

Thanks!!

 

[Chi]

Hi Stockwell43,

I wish I know your real name!!! Are you Stock?

Thank you for the nicely response! Sorry, I should give you move detail
about my database and why I ask for “not logical†things.

The database created for anyone in department, so they can check out and
check in equipment by themselves.

---------------------------------------------

The DATA ENTRY form based on Main table, which has BorrowerLastName,
BorrowerFirstName, CheckOutDate, CheckInDate, and Equipment fields.

Ex: FullName CheckOutDate Equipment CheckInDate
Nguyen Loi 01/08/08 tablet 1
02/18/08


When NguyenLoi enters the CheckInDate, 02/18/08, he actually returns the
tablet1. Therefore, I don't need to keep his record on the table.

I can manually delete NguyenLoi's record, but I would like this record is
deleted by itself so that my table will be updated all the time.

Thanks
Chi

 

[John W. Vinson]

Ex: FullName CheckOutDate Equipment CheckInDate
Nguyen Loi 01/08/08 tablet 1
02/18/08


When NguyenLoi enters the CheckInDate, 02/18/08, he actually returns the
tablet1. Therefore, I don't need to keep his record on the table.

So... you DON'T want to record the information that Loi checked out the
tablet; you DON'T want to be able to answer questions like "who hooked Tablet
1 up to the internet and infested it with 31 viruses last week"; you want any
even erroneous entry into the CheckInDate field to delete the record?

Why do you even HAVE a checkin date field if it will never contain any data?

Oh, you can do this - use the AfterUpdate event of the CheckinDate field to
run a command to delete the record - but I still think that this is no way to
run a railroad!