Search results for query: *

  • Users: jnash
  • Content: Threads
  • Order by date
  1. J

    what am i missing - taking values from do to array

    im trying to retrieve all the email address's from my db ad put them into a array, for ms access i always used a object reader, not as simple on mysql!!! Public Sub retrieveAddress() Dim address As String Dim myCommand As New MySqlCommand Dim myReader As...
  2. J

    incorrect values and slowness

    Hi there im using this code and whenever i input a date, i get all the entries in the table instead of the ones specified with the date, what am i doing, also loading can take over a minute, how can this be sped up i have 1.5gb's of RAM!!!! Private Sub Button1_Click(ByVal sender As...
  3. J

    datasource not found

    I have been trying to get a mail merge working for ages made this up from various sites, im gettin the error after the ODBC connecter page comes up and i click okay the error is "cannot open datasource" any immediate ideas ? thanks Public Sub domailmerge() Dim oApp As Word.Application...
  4. J

    adding a button event to a generated form

    my application generates forms via writing to a text file and then compiles via vbc, im having trouble adding the button onclick event, im getting errors saying the the method for onclick is incorrect, which it probably is my app outputs the below code, im not sure what i need in there to make...
  5. J

    running external exes from my form

    System.Diagnostics.Process.Start("VBC.EXE /t:winexe /reference:System.dll,System.Windows.Forms.dll,System.Data.DLL,system.drawing.dll,AxInterop.WMPLib.dll,Interop.WMPLib.dll,AxInterop.ShockwaveFlashObjects.dll,Interop.ShockwaveFlashObjects.dll /out:" & formName & " " & "C:\Documents and...
  6. J

    VBC Compiler

    i want to compile this form below using vbc, but i know that im either missing references for the flash and the media player when i compile it, which references do i use everything i try doesnt seem to work also VBC is giving out a error saying that .imagelocation is not a member of picturebox...
  7. J

    General Database Information

    i have a space on my form that deals with all the database, it would be nice to have some information about the database im using, maybe location, size, version?? any ideas, and also how to implement them! thanks Jon
  8. J

    office 2003 word mail merge

    i have seen many examples online but there either out of date or not very good at explaining themselves, i want to mailmerge a document using mysql! thanks in advance Jon
  9. J

    backing up/ restoring database from vb

    hi there i was wondering how i can back up my mysql databse from vb.net
  10. J

    error in SQL syntax

    Dim TheConnection As New MySqlConnection("server=localhost;" _ & "user id=root;" _ & "password=password;" _ & "database=supervid") Dim cmd As New MySqlCommand Try TheConnection.Open() cmd.Connection = TheConnection...
  11. J

    Paremeters & Images in Crystal Reports

    Hi there i have a simple Crystal report (winforms 2005) that i have generated with the wizard, its shows all the data from a table it shows dateOfTransaction TypeOfTransaction AmountOfTransaction , what i would like is to ask for a date so it only shows the information corresponding to...
  12. J

    change the actual computers date

    i need a function that changes the computers date so i can simulate days passing , can anyone point me out in the right direction, thanks Jon
  13. J

    exporting a windows form to a text file

    how can i export a windows form to a text file so it can be compiled by VBC, having no luck searching for it. thanks Jon
  14. J

    getting object location and size from their strings

    i have saved a objects location and size in a string, i was wondering how i can convert it to get the values out of it to recreate the location and size the strings are like this object location = "{X=278,Y=59}" object size = "{Width=390, Height=192}" thanks Jon
  15. J

    Windows Media Problem

    im recalling the string out of a access db the value is ""C:\Documents and Settings\halo9\Desktop\Boom.mp3"" its called "floc" i generate a new media player box Dim audio1 As New AxWMPLib.AxWindowsMediaPlayer audio1.URL = floc audio.Add(audio1)...
  16. J

    getting a color out of a string

    ive saved a form to a database and its backcolour as a string im now tryin to recreate the form and get back the color, now as its a string i need to convert it to a color that vb recognizes e.g i have a string "color [white]" and i want to convert it into a color (system.drawing.color) so i...
  17. J

    datareader??

    im trying to get the values out of my Access database, it finds the correct rows in the database (that contain the project name) but it says all the values are empty (dbnull = true) , where they are not! any ideas thanks , the values i want are strings ! Private Sub formload() Dim...
  18. J

    cant insert a filepath into a access db?

    hi there, i have this one issue when i try to insert a filename of a image into a access database, it errors saying it cant find the filepath?? is there another setting i need to insert this string? thanks in advance my code: Public Sub imageSave() Dim x As Integer Dim ol...
  19. J

    changing the sql date??

    mysql server takes a date like 1984-12-12 ? how can i change that or is it et in stone thanks!
  20. J

    databinding isssues!!

    i keep on getting this error: This causes two bindings in the collection to bind to the same property. Parameter name: binding using this code : adapter.Fill(myDataTable) lbltitle1.DataBindings.Add("Text", myDataTable, "StockTitle")...
Back
Top