Modifying MS ACCESS with VP

[flipflop]

Sorry for asking simple QU's but I need to learn this fast! there is a job on the line !! by 2/5/01 please help.

I need the code fo command buttons to :-
add a record
delete a record and
save a record

My books don't hold the answers, Thanks of all your help!
Paul

 

[delynn]

Paul,
You have recordset(s) created, and want to manipulate the data? Are you using Access?, SQL?, ADO?, RDO? ect.? I can send you related information from the MSDN Library. Will that help? Or are you looking for keywords like 'Append', 'AddNew', and 'Update'?

 

[flipflop]

I've got most of it working now, just the last bit......

I'm get the access database via the Data tool bar and can add and delete record by using:

Database.Recordset.Delete
Database.Recordset.AddNew

(database is just the allocation name I used)

This all works ok, but I need to be able to modify, and then save changes to a record.

This is all very simple stuff! its for an interview I have to teach at a school ! any ideas !!
Paul

 

[flipflop]

I think I have it !!!!

Database.Recordset.Edit

seems to do the job.... to save you time I'll get back to the page If i need help,, GOOD JOB PEOPLE !!!

Paul