Deleting Records

J

James

Is there anyway I can have a command button that deletes
the selected record?

Many Thanks

James
 
R

RobFMS

James

For simplicity, create a command button using the wizard. It will step you
through a series of wizard pages, one of which is Record Operations. In
this, you can select the "Delete Record" and see the code that is generated.

This is at least one step to learn what goes on behind the scenes.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
J

James

I have done this and it gioves me teh follwoing code which
seems to do nothing...

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, ,
acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ,
acMenuVer70

Is there any code which I could put in that would just
delete the record?
 
J

James

Hello,

For some reason its not deleting as it should come up and
ask me if I wish to delete the record and its not doing
that plus I have done as you asked and I still have the
record in my table.

Is there any other way I can do this as the previous way
stated does not seem to work...

Although if I use the delete record button on the toolbar
that seems to do the trick...

Many Thanks

James
 
R

RobFMS

One simplified approach would be to use the DoCmd.RunSQL <sql>

You write out the sql string you wish to execute.

Something like:

Delete From tblCustomers Where ID=3

or

Delete From tblCustomers Where State='DC'

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
J

James

I need it to delete the selected record...

IE..

In a subform I have a set of records and I wish to delete
one of them so I select it and click on teh button to
delete it but I dont yet have the button as I cant figure
out how to do it plus the fact everything I have tried has
failed...

Its not good....

Any more suggestions?

Many Thanks for all this

James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert PDF to Visio File or Editable PDF in Visio 0
Macro to select and delete levels of a document 2
Recover Outlook calendar entry 1
Improving Macro That Keeps First Letter 0
Select Text to End of Footnote 9
Getting Radio Buttons to work, that are inserted via AutoText 0
Deleting records from a subform 3
Relating 2 separate texts in word 1

Top