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...

Public Class LoginForm1 Private Sub Window_Unload(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosedEventArgs) Handles Me.FormClosed PasswordsConnection.Close() End Sub Private Sub LoginForm1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)...

Hello, I wrote a vb.net 2008 database program, and I set the connectionstring to be remote, ie: "\\xx.yy.zz.aa\whatever\database.mdb". Now whenever i launch my program, it gives me the following error, and yes I read the thread and wasnt able to solve it still... and I have been looking online...

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...

I am writing a vb.net program with ado and i just recently noticed a bug that i need 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 ='"...

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...

I have a small problem with my program. When I launch the program I have a few parameters that I run to load datasets, and fill listboxes, etc. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.Activate()...

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

Hello All, I am writing a small program and i have recently encountered a problem that i cant seem to find a solution to. I have 2 listboxes on a single page, and I am trying to populate both of them according to certain SQL commands. When I put one infront of the other, the one in front works...

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...