Search:

Type: Posts; User: sebalius

Search: Search took 0.02 seconds.

  1. Thread: Encryption

    by sebalius
    Replies
    3
    Views
    489

    Re: Encryption

    Many thanks will research it more as you suggest.
  2. Thread: Encryption

    by sebalius
    Replies
    3
    Views
    489

    Encryption

    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)...
  3. Re: [RESOLVED] Using ' as in Can't in a Text Box in MySql

    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....
  4. Re: Using ' as in Can't in a Text Box in MySql

    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...
  5. [RESOLVED] Using ' as in Can't in a Text Box in MySql

    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...
  6. Replies
    190
    Views
    29,369

    Re: above 50 years old and still programming

    I am 65 and just started learning it.
    Regards lol
    sebalius
  7. Replies
    15
    Views
    1,274

    Re: Totals in Access Database

    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.
  8. Replies
    15
    Views
    1,274

    Re: Totals in Access Database

    Thanks everyone for the advice, I will do as advised and use an Excel sheet instead of a database.
    Regards
    sebalius
  9. Replies
    15
    Views
    1,274

    Re: Totals in Access Database

    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
  10. Replies
    15
    Views
    1,274

    Re: Totals in Access Database

    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...
  11. Replies
    15
    Views
    1,274

    [RESOLVED] Totals in Access Database

    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...
  12. Replies
    7
    Views
    1,023

    Re: Problem with DataTable Sql Query

    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.
  13. Replies
    7
    Views
    1,023

    Re: Problem with DataTable Sql Query

    The DataTable comes up with the following auto generated script which when I run informs me that the arguments have not been specified:-...
  14. Replies
    7
    Views
    1,023

    Re: Problem with DataTable Sql Query

    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).
    ...
  15. Replies
    7
    Views
    1,023

    Re: Problem with DataTable Sql Query

    Thanks for the answer , I will follow your advise now. Thank you for the help it is really appreciated I assure you.
  16. Replies
    7
    Views
    1,023

    [RESOLVED] Problem with DataTable Sql Query

    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...
  17. Re: ListBox to populate TextBoxes from a Query

    I sorted it out myself, I was going about it the wrong way. Thanks to all who took the trouble to look.
    Regards
    sebalius
  18. [RESOLVED] ListBox to populate TextBoxes from a Query

    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...
  19. Re: MySql or Sql are they that different

    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...
  20. [RESOLVED] MySql or Sql are they that different

    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...
  21. Replies
    3
    Views
    733

    VS 2015 Re: Stopped at the first hurdle

    Thanks for your help, it clarified the situation for me and it is now working.
  22. Replies
    3
    Views
    733

    VS 2015 Stopped at the first hurdle

    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...
Results 1 to 22 of 22



Click Here to Expand Forum to Full Width