User Profile

Chloe828 · Nov 20 '11, 01:46 PM

I'm using MsAccess 2007 for the database..
And I've tried the above and still it doesn't store.
As in it has no error or syntax, it just can't store :(

Is there any other way like using loops?

Chloe828 · Nov 20 '11, 10:23 AM

It didn't increment my Code column nor store the new description
:(
How so?

Code:

Public Function AddClassification(ByVal Description As String)
        Dim strSql As String
        Dim dstemp As New DataSet
        Dim intaffected As Integer

        Try
            build()
            'Using a SQL statement INSERT INTO to include data to access table
            strSql =

...

Chloe828 · Nov 20 '11, 04:59 AM

I've changed the ID to description because since you've said its
unique indexes.. so here what I actually suppose to do,

Access data:

Column 1: CODE (primary key)
Column 2: DESCRIPTION

CODE DESCRIPTION

1 MAMMAL
2 REPTILE
3 AMPHIBIAN

Its like this, as I enter a new DESCRIPTION,
and when I click the...

Chloe828 · Nov 19 '11, 05:02 PM

Hi, thank you for your kind help.
I have tried the code you gave me but it doesn't seem to work.
Ican't store the ID nor increment the Code.
Here are my codes below,

Column "Code" is the one that suppose to increment as I store new "ID".

Code:

         Private Sub addbtn3_Click(ByVal sender As System.Object, ByVal e As      System.EventArgs) Handles addbtn3.Click

...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Incrementing a field