Search results for query: *

Hi, Just a sharing and I might be wrong. I had this error before when I use the SQL Server Express version. The error pop-up probably the SQL server 2005 you use haven't configure to allow the remote connection. The configuration can be done by: 1) Go to the surface area configuration for...

May be you can try to explore the DataView class and applying the filtering criteria.

Well, I think the 1st code portion is declare the user_id as global variable within the form, and can be refer by any method within the form. The 2nd code is to declare the user_id as local variable and the variable will be destroy once the method or the block within the declaration finish...

Yes, the error might be from the SQL line there, I see you used the string concatenation to generate the SQL and you tried to cast a string in the textbox to the integer. I expect the error might from here. You can try Str = "insert into table1 values(" & TextBox1.Text & ",'" &...

Yes, there is DateDiff function that you can use in access query. Please refer to this url to read on the information http://www.techonthenet.com/access/functions/date/datediff.php A simple example to compare the date in the query would be SELECT * FROM GLPOST WHERE DATEDIFF('d', Crt_Dt...

May be should use Form2.ShowDialog()

Try DataSet1.Tables.Clear()

If dr.Read() Then txtLeftAvgeMeanIMT.Text = CStr(dr.GetValue(0)) txtLeftAvgeMaxIMT.Text = CStr(dr.GetValue(1)) txtRightAvgeMeanIMT.Text = CStr(dr.GetValue(2)) txtRightAvgeMaxIMT.Text = CStr(dr.GetValue(3)) End If

Alternative is Dim dv As DataView = New DataView(glb_dtTransactionDesc) dv.RowFilter = "auto_tran = 'False'" Me.cboNewAutoTransaction.DataSource = dv Me.cboNewAutoTransaction.DisplayMember = "tran_description"

I think you cannot do in that was, if you change your code to this I think it will work: Me.cboNewAutoTransaction.DataSource = glb_dtTransactionDesc

For illustration.

How do you pass the value? It depends on how you declare your variable and it will affect the way you pass your value to them.

May be can show us some of your coding on how you do it?

Just some opinion: 1st Code 1) Object oriented. 2) Create as many new forms as you want. 2nd Code 1) Only show 1 form at a time (same form) 2) Traditional VB6 coding.

May be try out cdate(dr("DepositDate"))

May be try out change the DropDownStyle to DropDownList.

Had you bound the datatable to the datagridview?

I think you are not using VB.NET, you use the C# coding. In general view, from what you have describe, I think you should load 1 record at a time because you only display 1 record in the form. I think you have to sit down and rethink on the design. 2nd, make sure your database table is...

May be should try out me.lstproblemd.Items.Add(dr(1)) me.lsturgency.Items.Add(dr(1)) or load the data to the dataset and bind it to the list box Me.lstproblemd.DataSource = myDataSet.Tables("MyTable") Me.lstproblemd.DisplayMember = "SomeColToDisplay"

Might need to use the SQL join to join the 2 tables.