Not a Member Yet,
Click here to Register
How do you like the new design?






ID: 302
Viewed: 2509
Added: Aug 19, 2002
Version:
Snippet uploaded by: snippet
Written By: Unknown
Demo: Sorry, no demo



User Rated at: 0 Stars
Rate This:

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

How to add a new record to access DB with code. Once you ahve the text boxes on the form and named respectably.

Highlight all by clicking in box
<!---Declaration--->
Option Explicit
'Dim database & recordset
Dim dbName As Database
Dim rsRoutines As Recordset

Highlight All
<!---Code--->

'Open database & table
Set dbName = OpenDatabase(App.Path + "codebank.mdb")
Set rsRoutines = dbName.OpenRecordset("SELECT * FROM Routine " & "ORDER BY Category, Routine")

'Add new blank record
rsRoutines.AddNew

'Set fields
rsRoutines.Fields("Category") = lblCategory(0)
rsRoutines.Fields("Routine") = txtRoute.Text
rsRoutines.Fields("Description") = txtCodeWindow(2).Text
rsRoutines.Fields("Snippet") = txtCodeWindow(3).Text

'Update recordset
rsRoutines.Update

'Move to new record
rsRoutines.Bookmark = rsRoutines.LastModified
;


No Comments to show

Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.


Replying to a Comment...


Adding your comment. Please wait...

Thanks for adding your comment!. After further review it will be added.

There was a problem adding your comment. Please try again.

Please complete all the fields in the form before sending.

© 2002 - 2017 snippetlibrary.com All Rights Reserved. Conditions