Search results for query: *

JohnH, In all honesty I COMPLETELY overlooked the fact that I called ClientString, and ClientConnection without first opening them in that portion. I got too lazy to make a new PasswordString, and PasswordConnection since it was the same database.That gives me a place to start, thank you VERY...

cjard, i can access the database fine, i can read and write to it if i click continue. I have all the proper permissions, its just an issue of that message popping up everytime i launch my program. Every other aspect works fine, i can read, write, and edit the remote database fine. I am curious...

...Source =\\142.23.231.1\Broadband Management System\SS Solutions.mdb" PasswordsConnection.Open() PasswordsString = "SELECT * FROM Passwords" PasswordsDA = New OleDb.OleDbDataAdapter(ClientsString, ClientsConnection) PasswordsDA.Fill(PasswordsDS, "PasswordsMain")...

...property has not been initialized. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.InvalidOperationException: The ConnectionString property has not been initialized. at...

Solved! Ok I solved the problem, here is the solution: Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim RecordUpdateCB As New OleDb.OleDbCommandBuilder(ClientsDA) Dim RecordUpdate As OleDb.OleDbCommand = New...

...to fix in my software, but i havent the slightest clue where to start. Basically, I have programmed a search button with the sql commad "SELECT * FROM X Where FirstName = '" & FirstName.text "' AND LastName ='" &LastName.text "'" ; it finds the entry based on firstname and lastname, and after...

cjard, The concurrency violation doesnt occur when I use the above mentioned method. I assume its because VS is doing the real life editing and appending to the database for me and then calling all the necessary routines and updating all the necessary 'stuff'. I think I will probably rewrite...

...WITH DATABASE\DATABASENAME.mdb" & Application.StartupPath & "\SS Solutions.mdb" ClientsConnection.Open() ClientsString = "SELECT * FROM Clients" ClientsDA = New OleDb.OleDbDataAdapter(ClientsString, ClientsConnection) ClientsDA.Fill(ClientsDS, "ClientsMain")...

Solved, Thanks to some help from IRC, the solution to the problem was to remove the code for lstClients.DataBindings.Add and lstPending.DataBindings.Add. There is no need for it. Thank you to those who helped. acidflash

...Source =" & Application.StartupPath & "\SS Solutions.mdb" ClientsConnection.Open() ClientsString = "SELECT * FROM Clients" ClientsDA = New OleDb.OleDbDataAdapter(ClientsString, ClientsConnection) ClientsDA.Fill(ClientsDS, "ClientsMain") ClientsInc = 0...

Hello, I have a small project that i am working on and i am stuck and i am not sure how to make this work. I need ideas, and some sample code if possible. I have dimensions, for example, 180cm x 100 cm x 4 cm ; i need to fill a 'container' with several items of these dimensions and other...

Ok I figured it out, its right but the syntax error is because the column name is a keyword, and the database is getting confused, fixed it, named column "TheDate" instead of "Date" and worked fine, thanks everyone. acidflash

Hello I have a line of code that is strangely returning a syntax error? it is the following "INSERT INTO TableName (Product, Quantity, Date, Price) VALUES ('test', '3', '11/5/2008', '1') From where im standing the string seems to be fine, any ideas? this is the error output Could not insert...

Concurred.

While I understand what your saying, i have the current situation in my project. There is a listbox that is bound with a bindingsource to a database, when I click on the an item in the listbox, the .position ALWAYS gives me the right row; Now, as i can see from your posts this is not good...

I was able to solve it through some very intense search and slight modifications, here is the code for anyone who might have a similar scenario as me: Private Sub Button15_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button15.Click Dim...

Hello, I have a database which has many tables in it, and also a VB GUI to it which creates databases on the fly, the layout for each database is the same, Column1, Column2, Column3, Column4, Column5 ; I have 1 crystal report called "ProjectReport" and inside this report I have the layout that...

cjard, I downloaded the project. When using a listbox it seems to work? I used this in my project and it apparently works fine? In what situations is it wrong to do this ? Thanks for the advice. acidflash.

I havent used reports yet in any of my programs, I usually do what needs to be done by hand for maximum results (I have full control over whats happening). There is probably some sort of a function out there somewhere for something like this, or possibly just a good idea which should be...

I asked a similiar question but no replies yet, One way of doing it (i figure out later on) is to make a datagrid, make it invisible, load the data onto the datagrid, select the columns you want to print, then go about printing them. What you need to keep in mind is you must make the datagrid...