Search:

Many thanks will research it more as you suggest.

How should I alter this statement to add an encryption setting:-

Me.TableAdapterManager.UpdateAll(Me.SafeDataSet)

Something like this : Me.TableAdapterManager.Encrypt.UpdateAll(Me.SafeDataSet)...

This is the code I use to insert records but if I use " ' "(the apostrophe under the @ sign on the UK keyboard). The record should be Bill's Forum but I get an error. It will no way accept this key....

Thanks for all the advise, I will read up more on parameters.
Still won't work using parameters, I think I need a sub to change ' to ´ as this works ok. If any ideas for a sub to do this please let...

I have a database column set to Text but I get an error if I use the apostrophe if I omit it all is ok. Has anyone encountered this? I am using the latest MySql.

I wrote the program in Visual...

I am 65 and just started learning it.
Regards lol
sebalius

Many thanks make me rain, I appreciate your time on helping me. I will try as you suggest, once again many thanks to everyone for the help and guidance it is appreciated.

Thanks everyone for the advice, I will do as advised and use an Excel sheet instead of a database.
Regards
sebalius

I have the Income and Outgoings formatted as Currency and yes the date is formatted as date. I do have an ID column which is the PK

I have 4 columns like : Date Income Outgoings Balance
where balance is equal to Income-Outgoings so if on a date the income is 100.00 and the outgoings are 30.00 then the balance is 70.00, on the...

I have a database comprising basically "DATE INCOME OUTGOINGS BALANCE" I want to add the old balance from the previous record and then Add the new income minus the new outgoing to make a new...

Thanks for all the help, decided to make it easier and do the login via the program settings. Really appreciate the advise and I will try what you said to do.

The DataTable comes up with the following auto generated script which when I run informs me that the arguments have not been specified:-...

I just cannot put the code in the Codebank to reflect what I want to do, let me refresh.
I wrote a query in the DataTable (Code Below), I want to call this query on a button press (Code Below).
...

Thanks for the answer , I will follow your advise now. Thank you for the help it is really appreciated I assure you.

I am attempting to fill in a query on the DataTable Sql compiler I want it to change the value of Username & Password to the values of the textBoxes but it only changes to the TextBox Names.
Is...

I sorted it out myself, I was going about it the wrong way. Thanks to all who took the trouble to look.
Regards
sebalius

I was doing ok in this little program I am attempting, on running the ListBox populates great. I am having trouble now populating the listBoxes, here is the code I have tried and hopefully someone...

Many thanks for clearing this up for me, I am a pensioner and just venturing into VB to keep the brain active so please forgive my total ignorance. I will try your recommendations and once again many...

I have this code to populate the text Boxes via a query in MySql. Wouls it need much changing to work in a normal Sql program:-

Private Sub ComboBox1_SelectedIndexChanged(sender As Object, e As...

Thanks for your help, it clarified the situation for me and it is now working.

I am having trouble with an Sql connection string, I hope someone will give me advise as the string I have wrote will not connect and gives an error.
Here is my version, please advise me of my...