Article View: comp.databases.ms-access
Article #77Re: How to create a form to delete specific record from table?
From: Ron Myer
Date: Wed, 23 Jul 1997 00:00
Date: Wed, 23 Jul 1997 00:00
26 lines
1703 bytes
1703 bytes
Volt Information Sciences wrote: > > How can I creat a form that will allow the user to delete a specified > record from a specified field in a table? > > I want to have a form that allows you to enter the "Order Number" and > then 'click' a button that deletes that order from the "Orders" table. > All records in the "Orders" table have "OrderID". > > If the order number entered into the box doesn't match a number in the > OrderID field of the Orders table then nothing happens. > > Thanks in advance for your assistance > > Lloyd D. Songne, Jr. > Volt Services Group > > Visit our interactive employment web site at http://www.volt-tech.comUse the DELETE Command in Code. See DELETE (SQL) in your help file! -- Ron Myer I've gone out to look for myself. If I should come back while I'm gone, please hold me here 'till I get back!
Technical Details
Message-ID:
<33D6C471.379E@ix.netcom.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<5r5mu6$8lk@sjx-ixn9.ix.netcom.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f6611,c6ecbd0945e250b4 X-Google-Attributes: gidf6611,public X-Google-Thread: ff0ac,c6ecbd0945e250b4 X-Google-Attributes: gidff0ac,public X-Google-Thread: 104de1,c6ecbd0945e250b4 X-Google-Attributes: gid104de1,public X-Google-Thread: 10bb27,c6ecbd0945e250b4 X-Google-Attributes: gid10bb27,public From: Ron Myer <myeron@ix.netcom.com> Subject: Re: How to create a form to delete specific record from table? Date: 1997/07/23 Message-ID: <33D6C471.379E@ix.netcom.com> X-Deja-AN: 258408647 References: <5r5mu6$8lk@sjx-ixn9.ix.netcom.com> To: volt1@ix.netcom.com Organization: Energy Masters X-NETCOM-Date: Wed Jul 23 9:59:04 PM CDT 1997 Newsgroups: comp.databases.ms-access,microsoft.public.access.queries,bit.databases.mssql-l,comp.databases.ms-sqlserver