ACCESS FEED: Re: [MS_AccessPros] Deleting a record from a button

Selasa, 31 Januari 2012

Re: [MS_AccessPros] Deleting a record from a button

Art -
Why are you deleting a record,
I would hope that you are saving the information somewhere.
I have move in date, move out date, initial rent, current rent,

and a field Active that I toggle to filter out past tenants

Take care, Michael
From: Art <dbalorenzini@yahoo.com>
>To: MS_Access_Professionals@yahoogroups.com
>Sent: Tuesday, January 31, 2012 6:18 AM
>Subject: [MS_AccessPros] Deleting a record from a button
>
>
>
>I have a table call tblUnitTenant with the following fields:
>
>UnitID
>PeopleID
>
>I have two forms:
>
>frmUnitDetail
>UnitID
>UnitStatus
>cmdRemoveTenant
>
>sfrmTenant
>
>The sfrmTenant contians the tblUnitTenant fields and is linked to the frmUnitDetail via unitid.
>
>If the use changed the UnitStatus to Vacant I need the record in the tblUnitTenant (sfrmTenant) deleted or if they press the cmdRemoveTenant button the same thing needs to happen.
>
>Is this possible?
>
>Thanks,
>
>Art Lorenzini
>Sioux Falls, SD
>
>
>
>
>

[Non-text portions of this message have been removed]