Thanks for moving this I didn't see this forum.
I might not have explained what im trying to do clearly enough.
I am just moving over from access & VBA so its a big learning curve.
I don't know if I am thinking down the right part with what im trying to do but I am really hoping someone...
I am having some problems trying to add a database to a vb express project.
I am running sql 2000 but for some reason it only wants to connect to a 2005 express database.
I have tried adding a new database but I get an error message telling me "Connections to SQL server...
I am in desperate need of some help.
I have made a form that I want to use to make orders. There are 2 datagrids (grdItems & grdSearchItems ) a textbox (txtAmount) and a command button.
What I am trying to do is select a row from grdSearchItems I only want to select the 1st 3...
I need some advise with a small task I am trying to achieve.
I have a form called frmCustomers. On the form there are 2 datagrids (grdOrders & grdPayments) I also have a textbox called txtCurrentBalance. What I would like to do is to be able to display a customers current balance...
I dont have a dataset set up on the application.
I am running vb express and have an SQL 2000 server. I have not been able to connect to an SQL database as I have problems with adding a new datasource as the wizard always creates a wrong connection string as it thinks I only have...
I tried your line of code but it didn't work for me.
I have the aboce code in the forms loading code.
I moved the following 2 lines as they are used to bind data to some textboxes within the form.
I code now looks like this.
Private Sub frmCustomers_Load(ByVal sender As...
I am sure this is really easy but I have a form that contains a number of textboxes and also a datagrid.
I have a textbox on the form called txtCustomerID which displays the primary key for tblCustomers and also I have another table called tblQuotes which has CustomerID as a FK...
I have managed to find a piece of code that allows me to display 3 datagrids. It works ok when using the northwind example but when I try using my own database I can only display 2 out of the 3 datagrids.
For testing purposes I have used the same table for all 3 grids.
I am using vb express 2005.
I have built a form that contains customer details and have also built a form for orders (frmCustomers & frmOrders)
I have added a button on the customer form to ADD an new order. The frmOrder is then opened.
My question is how do I take the...
I am hoping someone can help me out with a problem that I cant fix on my own.
I have created a form that contains customer details. I have also added a datagrid that I want to be able to view all the customer orders.
I am using an sql database with the following tables...
I am trying to use the wizard to setup a datasource between an sql database using vb express.
I am not able to do so and its due to the connection string that the wizard is creating.
Is the string its creating but I am not using sqlexpress.
How can I can the wizard to work...