Search results for query: *

Ok this is a weird one. I recently got Windows Vista along with Access 2007. I am making a new database which deals with item sales. The items are listed in a subform each with their own price. Underneath the subform I have a totals text box. I want this to automatically update to show the price...

I've created a small database with an add new record screen and a view/amend screen (currently bound). I would like to add transaction rollback to these screens if possible. But I believe that rollback only works if you use queries/SQL statements, and currently to add a record I'm using the...

Thanks very much to you all

I'm creating an application where I need to run through a list box of values and where the value matches a pre-chosen variable it needs to be automatically highlighted (will usually be multiple highlights). I thought I could obtain the values shown in the list by using the itemdata command e.g...

Got it working at last, thanks for your help Keyth and TipGiver. Do you know how to display multiple columns of visible data in a list box? Say for example Name and Date Of Birth shown, and another hidden ID field?

You mean attach the database inside SQL Server? Why would I neeed to attach it if it is already in there? I don't understand. If you mean inside VB 2005 there is the option to add a datasource under the Tools menu but this just sets up a short cut to the connection string. I've decided to...

Following on from my previous post Keyth, the code works when I use "Select * From tblCustomers" as the datatable, but if I use a query view result set instead "Select * From qryCustomers" it brings back the error. Do I need to use different code for dealing with a query? I thought data tables...

To Keyth, thankyou for your very useful posts! However I am still currently getting the same error - it says System.Data.DataRowView in the list box instead of displaying the values. The code I am using is as follows: dtCustomers = New DataTable sqlda.Fill(dtCustomers)...

Maybe I haven't worked it out. Earlier today the copy that I made to the other directory stopped working. I copied it back there again but now my SQL Server doesn't recognise that it's there at all so I can't add tables or anything to it. Can anyone please explain to me how the hell to connect...

Ok let's say I just want to set the list to a single column, I've got the the table from SQL Server linked to a datatable, how do I get the Name field from the table to display in the list box on screen?

Hey all, I'm trying to link multiple columns from a table based in SQL Server to a list box on one of my Visual Basic 2005 forms. I've set up the datatable correctly, and I can obtain individual values from it using datarow, however I wish to populate a list box with all the records from both...

Ok I seem to have worked it out. I did this by moving the database files out of the default SQL Server directory into another directory on my PC - then the connection works fine. Why? Who knows...another great example of Microsoft being daft.

I'm not trying to connect remotely, I'm trying to connect using the local machine...

Heya all, my efforts to connect to SQL Server 2005 Express from Visual Basic 2005 are still not successful, despite trying it on numerous different systems. Can somebody please explain to me what I'm doing wrong? 1) I install SQL Server 2005 Express and Visual Basic 2005 Express (With .NET...

Would somebody please be able to try out the following so I can see if it is just my PC mucking up and not an error in the code I'm using?... (1)Download and install Visual Basic 2005 Express and SQL Server 2005 Express. (2)Log into SQL Server with name of computer followed by \SQLEXPRESS, go...

Thanks for replying. I tried that new connection string in code (Adding in extra "s and &s around the directory structure of course) but it still comes up with the same error. I tried to download the SQL Native Client but it says I already have a higher version on my PC. When I create a new...

Oh I don't know if this is related or not but I don't seem to be able to Dim a variable with the type Sqlconnection. I can set a variable to SqlClient.Sqlconnection. I've seen other people's code examples where they seem to be setting variables to Sqlconnection type e.g. Dim sc as new...

I am currently working on a Visual Basic 2005 Express project, and wish to connect to SQL Server 2005 Express for the data tables. However it is not letting me connect. I do not have a user name or password specifically set up under SQL Server, it is just going in with Windows authentication...

Greetings all. I'm currently creating a database process that automatically updates various columns of an Excel spreadsheet using Access code and table data. However I have come across a couple of issues related to Excel formulas as follows - 1) How do I put a formula created in Access code...

Thanks for the fast replies! Ed, the Join command doesn't seem to be recognised in my Access (97 version). Any ideas?