If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: More Database Questions

in order to add a new record to the databse, you will create a recordset object
and open it with an SQL Select statement which will creatre all of the fields
to be populated. YOu will the use the AddNew method of the record set, populate
the fields with the new data values, and the save the record with the Update
method of the recordset. This will in fact insert that new record at the
"end of the table".

When you delete a record, you create a recordset object,
position the recordset in the tabel with the appropriate select statement,
and the use the Delete method of that recordset to delete the "current" record.

Note : with Delete, you do NOT use the Update method.

Arthur Wood

"Matt Wyant" <MDWyant@SRPnet.com> wrote:
>
>It's me again.
>
>I have created a DAO 3.6 Access database program, and I need to know a couple
>things.
>
>I need to be able to add and delete a record. I would like the new record
>to be appended to the end of the database. And when I delete, I would like
>it to be the current record.
>
>Any help would be appreciated, but please keep in mind that I am a very
new
>programmer and the more detailed the explanation the more helpgul it is.
>
>Thank you.
>
>Matt Wyant
> MDWyant@SRPnet.com
> Http://www.public.asu.edu/~Mwyant

"Arthur Wood" <wooda@saic-trsc.com> wrote:
>
>in order to add a new record to the databse, you will create a recordset
object
>and open it with an SQL Select statement which will creatre all of the fields
>to be populated. YOu will the use the AddNew method of the record set,
populate
>the fields with the new data values, and the save the record with the Update
>method of the recordset. This will in fact insert that new record at the
>"end of the table".
>
>When you delete a record, you create a recordset object,
>position the recordset in the tabel with the appropriate select statement,
>and the use the Delete method of that recordset to delete the "current"
record.
>
>Note : with Delete, you do NOT use the Update method.
>
>Arthur Wood
>
>"Matt Wyant" <MDWyant@SRPnet.com> wrote:
>>
>>It's me again.
>>
>>I have created a DAO 3.6 Access database program, and I need to know a
couple
>>things.
>>
>>I need to be able to add and delete a record. I would like the new record
>>to be appended to the end of the database. And when I delete, I would like
>>it to be the current record.
>>
>>Any help would be appreciated, but please keep in mind that I am a very
>new
>>programmer and the more detailed the explanation the more helpgul it is.
>>
>>Thank you.
>>
>>Matt Wyant
>> MDWyant@SRPnet.com
>> Http://www.public.asu.edu/~Mwyant
>

you should also look at the Help for Recordset and then AddNew, Edit, UPdate
and Delete methods.

"Matt Wyant" <MDWyant@SSRPnet.com> wrote:
>
>Can you give me some small pieces of code that refelct what you are saying?
> Maybe just using one field. I think I have already created a recordset
>(I can browse the database, just not edit it).
>
>Matt Wyant
> MDWyant@SRPnet.com
>
>"Arthur Wood" <wooda@saic-trsc.com> wrote:
>>
>>in order to add a new record to the databse, you will create a recordset
>object
>>and open it with an SQL Select statement which will creatre all of the
fields
>>to be populated. YOu will the use the AddNew method of the record set,
>populate
>>the fields with the new data values, and the save the record with the Update
>>method of the recordset. This will in fact insert that new record at the
>>"end of the table".
>>
>>When you delete a record, you create a recordset object,
>>position the recordset in the tabel with the appropriate select statement,
>>and the use the Delete method of that recordset to delete the "current"
>record.
>>
>>Note : with Delete, you do NOT use the Update method.
>>
>>Arthur Wood
>>
>>"Matt Wyant" <MDWyant@SRPnet.com> wrote:
>>>
>>>It's me again.
>>>
>>>I have created a DAO 3.6 Access database program, and I need to know a
>couple
>>>things.
>>>
>>>I need to be able to add and delete a record. I would like the new record
>>>to be appended to the end of the database. And when I delete, I would
like
>>>it to be the current record.
>>>
>>>Any help would be appreciated, but please keep in mind that I am a very
>>new
>>>programmer and the more detailed the explanation the more helpgul it is.
>>>
>>>Thank you.
>>>
>>>Matt Wyant
>>> MDWyant@SRPnet.com
>>> Http://www.public.asu.edu/~Mwyant
>>
>