Search results

Ok. here is a qucik and dirty way to do it. You have to change it to suit your needs. Dim conn As OleDbConnection = New OleDbConnection(YourconnectionString) Dim str As String = "SELECT [Field1] FROM tblDivisionID WHERE([BranchID]='" & Combobox1.Text & "')" Dim cmd As...

How are the comboboxes populated? Are the two fields in the same table? if so then just write an SQL statement that brings up a resultset of one value by using the executescarlar method of the command object. The criteria from the SQL will obviously come from the selection in the first combobox...

As long as you are using access,I dont think there is a way to lock a table from an enthuthiast. May be right clicking on it and hiding it may do the trick. I dont see the reason as to why your users should navigate to the backend to look at the tables. What they are meant to see the the...

Pretty simple, 1) create a connection to the database 2) instantiate a new dataset 2) instantiate a new dataAdapter 3)Open The connection 4) fill to the dataset with the resultset of your SQL Statement. 5) Close and dispose your connection and dataAdapter. If you are new to this, there many...

hehe...correction. MS thought that VB6 code could easily be converted to VB.NET and Vise-Versa

ya5irha55an, its better off learning VB.NET than learning VB6. VB6 and below is outdated technology. The technology after VB6 is called .NET.With the invention of .NET 2002, 2003, VB6 programmers thought it was VB7. To thier suprise, it was totally a different technology that was generated from...

CCFlyer, Most .NET programmers use MS Access as thier Back-End. Its because other databases are too expensive or rather not easy to learn how to work with them. Due to the limitation of Access,I would recommed using other databases before its too late for you. There many out there. VS also comes...

just use the font property. Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click If Not Me.Label1.Font.Bold Then Me.Label1.Font = New Font(Me.Label1.Font, FontStyle.Bold) ElseIf Me.Label1.Font.Bold Then...

You need to know how to first Export to Excel before you know how to format. The question is, have you tried expoting to excel, if so then you can as well do the formatting as you do inside the Macros. But if its for reporting issues, i would rather advise you use some repoting tools. .NET...

unclegizmo, thats the best i have also ever found on the Net. And since they say they developed it based on #develop,it's considered as the most secure by many people. I used #develop to convert to and fro when am offline.

thses Tutorials may help you. http://quickstart.developerfusion.co.uk/QuickStart/

Hi. unlike Access, .NET is OO(Object Oriented), so most of what you will do will need creating objects and using thier instances wherever you need. To show a form, you create an instance of it, then call the show or showDialog method of the instance. If you want to change the startup form, you...

create a datatable from the datasource of the datagrid then, execute an INSERT SQL statement into the table, for all the rows in the datatable.

here is the translation. ..... 1) Create a connection string to your database 2) Create a command object 3) Create a stored query or Procedure in access using CREATE PROC 3) Open the connection. 4) ExecuteNonQuery against the command object 5) Close and dispose the objects. .....You MIGHT have...

Make a connection to the database create a command object and execute your SQL statement against it to give you the data from the database. You may use a dataset to get the data into variables or text boxes on your form. Then just do the normal mathematics.

Use ADOX Library. Attached is the dll and below is some sample code. Hope it helps. Imports System.Runtime.InteropServices Imports ADOX Public Class Form1 'Shows how to create an Access database and append tables, fields, indexes using ADOX. Don't forget 'a reference to ADOX (Microsoft...

I have a problem and it will be best explained by the attachments i post. I need to Update a table("MyOrgRunTable") from button "2" on my form. The Table data should be similar to the data that is on the word document attached. The data is created from table1 using a function called MakeOrgList...

Any One Read This?

If you perform a query and you get null values returned then it imples that those fields do not contain anything. I do hardcode my datasets,and i test for null values like this If TypeOf myDataRow("ColumnName") Is DBNull Then 'myDataRow.ColumnName=0 But,remember that your database column has to...

Good Link, but alas!...most of it is in the C++ line. I wonder how one can tell that this is VB.net code without passing from one thread to another!