Search results for query: *

Format Yes the field has a specific format. It's an Enquiry ID generation. ID has to be generated as ENQ+Course code for which enquiry is done(string)+Automated number. example: ENQCCLW0001 or ENQCISS0002 I have been able to get the ENQ + Course Code. but how to generate number?

generate ID I have one problem. I have to generate ID automatically in my software which contains a combination of text and numbers. The main thing is that in access database, I hav given its datatype text because its alphanumeric but tell me can a text field be autoincremented to generate ID...

f1 wat to do nw. plz help me...

combobox code Ok i'm sending you all the code relevent to that combobox. ComboBox1 Me.ComboBox1.DataSource = Me.DataSet_Crs1 Me.ComboBox1.DisplayMember = "Course_MST.Course_ID" Me.ComboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList Me.ComboBox1.Location = New...

This is what i have done but still it duplicates. Have a look at Combobox code: ' 'ComboBox1 ' Me.ComboBox1.DataSource = Me.DataSet_Crs1 Me.ComboBox1.DisplayMember = "Course_MST.Course_ID" Me.ComboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList Me.ComboBox1.Location = New...

hi That problem is solved but whenever my form gets loaded the combobox from where i am selecting the id gets duplicated in it. It means if i have 5 id then i hide form and when i return it gets 10. Can u suggest wat to do?:eek:

send the syntax I know it will be done with selectedindex change event of combo box but what exactly i have to write? textbox1.text = ?

Hi! Can anyone tell me how we can fill textboxes with columns from access database on selection of an primmary key item from the combobox. I have a form in which i have a combobox where i display the unique field of the table. I want when the user clicks on one item in combobox i can fill...

This code is alright but doesn't work. It throws exception at runtime "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.windows.forms.dll" The code on button click is: Me.OleDbInsertCommand1 = New OleDbCommand("INSERT INTO Enquiry(Enq_ID, Cand_Name...