Thank you Tommy,
The presentation " ID:= "This is where I have a conflict" " is certainly a string, but it was a failed attempt to convey my confusion. I apologize.
In using Microsoft SQL Server Management Studio to generate my tables, the Table SQL is described as:
SET ANSI_NULLS ON
GO
SET QUOTED IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Admin](
[ID] BIGINT IDENTITY (1,1) NOT FOR REPLICATION NOT NULL,
[AdminFN] VARCHAR(50) NOT NULL,
[AdminLN] VARCHAR(50) NOT NULL,
[AdminPword] VARCHAR(50) NOT NULL,
CONSTRAINT [PK_Admin] PRIMARY KEY CLUSTERED
([ID] ASC))
To the best of my comprehension this configures column [ID] as the Primary Key with Auto Number.
The Userform generated with Visual Studio 2012 gathers three points of data into the Textbox's.
After all three have been filled, the Command Button Code includes:
[vba]
AdminTableAdapter.Insert(AdminFN:=AdminSetupFormFNBox.Text, AdminLN:=AdminSetupFormLNBox.Text, AdminPword:=AdminSetupFormPwordBox.Text)
MessageBox.Show("Database updated!")
Me.Close()
[/vba]
The error message shown below indicates that it will not allow me to exempt an INSERT reference to column [ID] within the userform command button code. (which... I thought exemption would allow the autonumber to fire when the balance of the columns were filled since the column [ID] is a Primary Key and configured to AutoNumber.)
===============================
"Error 1 Argument not specified for parameter 'ID' of 'Public Overridable Overloads Function Insert(ID As Long, AdminFN As String, AdminLN As String, AdminPword As String) As Integer'. C:\Users\rlb53\Documents\Visual Studio 2012\Projects\BOL\WindowsApplication1\AdminSetupForm.vb 7 13 WindowsApplication1"
================================
When Data is entered directly into the table, the auto number setting performs as intended.
================================
When a distinct value is entered after "ID:=" within the command code, an appropriate error message appears indicating that INSERT is set to OFF for column [ID] and the value is not recieved.
================================
Is there a keyword that should follow "ID:=" within the Visual Studio 2012 command code that will cause the autonumber to fire and the data to be stored?
================================
Is there another Syntax which would be more appropriate for use within the Visual Studio 2012 Form Command Code to insert the data into the Table?
================================
When I remove the IDENTITY command from [ID] and modify the Command Button Code to:
[vba]
AdminTableAdapter.Insert(ID:=1,AdminFN:=AdminSetupFormFNBox.Text, AdminLN:=AdminSetupFormLNBox.Text, AdminPword:=AdminSetupFormPwordBox.Text)
MessageBox.Show("Database updated!")
Me.Close()
[/vba]
All of the information is stored within the table with no errors but it does not provide the auto number feature.
=================================
I reviewed the Link that you shared. The table settings appear to be in order.
There is obviously a loose nut between the seat and the steering wheel here, but the nut is hanging on as best it can. If you could help tighten it.... it would be greatly appreciated.
I know the solution is going to be so friggin' simple.. I'll be slapping myself for being so blind.
=================================
I have a cross post at:
http://social.msdn.microsoft.com/For...1-9e2d06d48cfb
in an effort to reach out for a resolve to my blindness which has yet to be achieved. If for any reason the resolution is acquired, It will be posted ASAP.
=================================
Thank you for your continued support !