ive also set double buffer to true but to no avail...
plz help

hello every1,
my project is on the verge of completion and a large part of the credit goes to daniweb.
now m stuck with a very annoying problm. ive googled the whole day but to no avail.
m using...

which database are you using and which version of visual studio are you using.
this shud get u strted...
go to the properties of the label..,..
go to databindings...
advanced option...
in the...

how to assign the date and time to the status strip..
it shud automatically update the date and time.
also i want to display the name of the form in the status strip.
how can this be done.
m...

i think there are extra inverted commas at the end of the update statement

hello every1,
am unable to edit data in a data table and save it to the data base.
this is my code
this is to fill the data table

m_ContentsDataAdapter = New OleDb.OleDbDataAdapter("Select...

no it is not being automatically incremented. i am aware of tht option but cannot use it since at a later stage i have to manually assign tht value.
moreover the porblem seems to be only at the id...

hie m looking to edit certain data on the form.
data on the form is divided into two sections A and B.
when i right click on A and select edit i shud get the option to edit A and similarly for B....

didnt get you...

If Me.txtCompany.Text.Trim = "" Or Me.txtTelephone.Text.Trim = "" Or Me.txtEmail.Text.Trim = "" Or Me.txtAddress1.Text.Trim = "" Then
MessageBox.Show("Please enter all informaiton",...

hie,
m using visual studio 2005 and access 07.
this is my code. ive also attached an access 07 file and this is the exact data tht my actual database has..plz help

Dim DataAdapter As New...

yes my table has a primary key.

if u want the exact exception that is occuring this is it

System.Data.OleDb.OleDbException was unhandled
ErrorCode=-2147217900
Message="Syntax error in...

still the same error

subquery is not the only way.
u can simply create another query and fetch the data from the other table.
alternatively u can also use data tables...

i am aware of the insert query. but i wanted to add data using command builder.

i agree with tomw.
m sorry i forgot to add the parameter part mentioned by tomw.

u can make the connection object as module level variable.
moreover u dont need to create a string and then attach it to the connection object
for eg.

dim conn as new sqlconnection("Data...

this is the code

m_DataAdapter = New OleDb.OleDbDataAdapter("Select * from [Base Colours]", oledbcon)
m_DataAdapter.Fill(m_DataTable)
m_CommandBuilder = New...

the data adapter handles my update insert and delete query...

price is declared as text in the database.

select * from accesstable

m using access 2007 and vb 2005
this is my code

Dim drNewRow As DataRow = m_DataTable.NewRow()
drNewRow("Code") = txtColourCode.Text.Trim
drNewRow("Colour Name") =...

why dont u try and use data reader

wht is search. if its just a variable then it can store only one value.
try using data reader or array.

thnx a ton tht worked fine.....

what r u trying to do..?
do u want the user to enter only numeric values?

the error that i get is
"syntax error in update statement"
with the title..."oledb exception was unhandled"
i am using access 2007 and visual studio 2005
sorry for late reply...

this is my code

If Me.txtOldPassword.Text = pwd Then
Dim oledbcom1 As New OleDb.OleDbCommand
oledbcom1.CommandText = "Update login Set password = ?"

...

first u have to think of a way to determine whether data is saved or not.
thn this factor can be used as a condition to determine if u want to run the above code or not.

Private Sub...

hie
how can i restrict the user to enter only numbers in a textbox

my previous code is working fine. i had made a few mistakes.

dataGridView1.Rows.Add()
dataGridView1.Item(0, dataGridView1.Rows.Count - 1).Value = cboColourCode.SelectedItem.ToString...

this is my code

dataGridView1.Rows.Add()
dataGridView1.Item(0, dataGridView1.Rows.Count - 1).Value = cboColourCode.SelectedText.ToString
dataGridView1.Item(0,...

hie
if the user, after working with the form wishes to reset it, how can it be done.
will me.refresh() help.
wht is it used for?

r u using windows authentication login

on button click event
me.close()
frmnewform.show()

you want me to add unbounded columns to the datatable?

hie
i have 3 columns in the data table.
id, name, telno.
i want to display only specific names and telno. depending on the charactes the users inputs in the text box.
this part has been taken...

your question must be a little more specific.
newways
hope u hav created a database.
when the user enters the text match it with the contents of the database and if a possible match is found...

got it
the error was something entirely different
thnx for ur help

datatable is module level
and i have inserted data during the load event using data adapter which is also module level