CharlieMay's Profile User Rating: *****

Reputation: 1624 Grandmaster
Expert w/DIC++
Active Posts:
5,207 (2.66 per day)
25-September 09
Profile Views:
Last Active:
User is offline Jan 27 2015 12:59 PM

Previous Fields

OS Preference:
Favorite Browser:
Favorite Processor:
Favorite Gaming Platform:
Your Car:
Dream Kudos:
Expert In:

Latest Visitors

Icon   CharlieMay has not set their status

Posts I've Made

  1. In Topic: Error when compacting .accdb database in VB.NET

    Posted 9 Jan 2015

    Make a copy of your database.

    Open Access without a database

    Run compact and repair on your copy from there and see if the error gives a more meaningful description

    I've often found that the actual software produces more verbose error messages and sometimes point you to the actual reason whereas the error that returns does not.

    If, from this, you discover the reason, correct the problem and try to execute your compact command again inside vb.
  2. In Topic: Put checkbox in any listview cell

    Posted 28 Dec 2014

    A datagridview would be easy to set up to do this

    It would have a Textbox column and 4 checkbox columns

    Attached File  dgv.JPG (25.16K)
    Number of downloads: 2
  3. In Topic: Updated dataset to access database

    Posted 28 Dec 2014

    Can you give us an example of what you tried using what andrewsw linked.

    In your code you are filling a dataset from a table in an access database, deleting the contents of the table and then merging a second dataset filled with data from a spreadsheet.

    His example skips the deletion process by just taking in the data from the spreadsheet and inserting it into the table. Which is essentially what it appears you're trying to achieve.

    This can be done using an OledbCommand and using the second dbProvider string you have in your code

    So basically:
    Create the connectionstring
    Create the connection
    create the sql statement (basically provided with only changes that reflect to your setup)
    Create the command passing it the sql and connection to use
    open the connection
    execute the command

    This should give you a table that has what it previously had plus what you pulled from the spreadsheet.
  4. In Topic: Use variable from textbox and run command line

    Posted 21 Dec 2014

    have you tried using " base" instead of "base"?

    Since base is a string you're concatenating, just add the space to the beginning of the string.

    alternatively, you would typically include a space between 2 quotes

    Textbox1.Text & " " & "base"
  5. In Topic: Generating receipt number and save to mysql database using

    Posted 19 Dec 2014

    There is nothing here that will insert a record into a database. The code you supplied only pulls the maximum id and adds 1 to it and then returns that values with your prefix.

    I would assume you would want to take this return value. Use it in a record that you are getting ready to create but you have shown no code which creates that record.

    Question: Why do you care what the maximum number is? This should be nothing more than an ID that is autogenerated against the row to keep it unique. As another person pointed out, displaying a prefix to the record on the printed/shown receipt is only cosmetic as far as the database is concerned. Externally you may have a receipt number of BSP000001 but internally 1 is your unique id and would be used to determine that you are working with the correct row.

    So in closing, until you create a statement that executes and INSERT a new row into a table, the code above will always show the same result

My Information

Member Title:
This space intentionally left blank
47 years old
October 27, 1967
Years Programming:
Programming Languages:

Contact Information

Website URL:
Website URL  http://


  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  1. Photo

    CharlieMay Icon

    30 Apr 2014 - 05:43
    asmalley, please post your question in the forums. Not only does it get you a lot more suggestions and help, it allows others to learn from the solutions provided. :)
  2. Photo

    asmalley Icon

    29 Apr 2014 - 06:43
    Hello Charlie if you have a moment to look at your private message that would be much appreciated :)
  3. Photo

    orangebanana Icon

    03 Dec 2013 - 19:57
    thank you very much :)
  4. Photo

    vks.gautam1 Icon

    11 May 2013 - 06:53
  5. Photo

    CharlieMay Icon

    06 May 2013 - 14:10
    OK, up at the top of this page is the "About Me" tab where my signature is: in there is a link to a very helpful set of videos that should help you with what you want. Start at the beginning video and follow along.
  6. Photo

    pavanvadrevu Icon

    03 May 2013 - 08:53
    i want to learn complete from basics sir
  7. Photo

    nK0de Icon

    01 Feb 2013 - 10:18
    Hey Charlie! :) How's it going over there?
  8. Photo

    beginner_emman Icon

    30 Nov 2012 - 09:05
    i agree, you should teach a programming..thanks for your help..
  9. Photo

    CharlieMay Icon

    22 Oct 2012 - 18:30
    Wow! thanks everyone. I apparently need to check this area more often ;)
  10. Photo

    Wizmeister Icon

    18 Oct 2012 - 17:00
    You are awesome man. You should teach a class on programming.
  11. Photo

    wanabavbcoder Icon

    09 Oct 2012 - 15:38
    hi charlieMay, Thank you so much. It has really helped. I wish I had the knowledge you had.
  12. Photo

    wanabavbcoder Icon

    09 Oct 2012 - 00:48
    hi charlieMay, Ive posted a question that seems to have stumped google. Maybe you might be able to help
  13. Photo

    wanabavbcoder Icon

    08 Oct 2012 - 15:22
    Sorry to bug your'll again but another error appeared:
    An unhandled exception of type 'System.Reflection.AmbiguousMatchException' occurred in microsoft.visualbasic.dll
    Additional information: No accessible overloaded 'MessageBox.Show' is most specific for these arguments:
    Public Function Show ( ByVal text As String, ByVal caption As String ) As Sy...
  14. Photo

    wanabavbcoder Icon

    08 Oct 2012 - 13:36
    thank you so much for your prompt reply. will it be possible for you to email me? my email is
  15. Photo

    czarmaiyne Icon

    04 Oct 2012 - 09:47
    hey charlie, been reading some stuff at the lounge.. gaaawwd! this site is simply amazing. have to explore more!
    thank you for guiding! :]
  • (3 Pages)
  • +
  • 1
  • 2
  • 3