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

Reputation: 1623 Grandmaster
Expert w/DIC++
Active Posts:
5,200 (2.71 per day)
25-September 09
Profile Views:
Last Active:
User is offline Today, 02:23 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: 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"
  2. 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
  3. In Topic: Generating receipt number and save to mysql database using

    Posted 19 Dec 2014

    Does either of those give you a desired result?

    This is where you do your testing to see if the result of the query returns what you expect. You should be able to set up a test to determine if your code is producing the next receipt number as you expect it to.
  4. In Topic: Generating receipt number and save to mysql database using

    Posted 19 Dec 2014

    Telling us what error you're receiving would be helpful but I did notice that you have not opened a connection in your code.

    Perhaps place a cn.Open() inside your Using cmd block prior to trying to execute the command.
  5. In Topic: build age function for oledb query expression

    Posted 18 Dec 2014

    I did find this:

    A quick test of this produced 47 from my DOB using the query

    SELECT FullName, Age(DOB) FROM Test

    Using a Test Table containing
    FullName   DOB
    CharlieMay 10/27/1967

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