Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Paco75

    NullReferenceException was unhandled

    I declared my Class custConvert with New and all is ok now. Noob error! Thanks :)
  2. Paco75

    NullReferenceException was unhandled

    Here is the function called. Public Class custConvert Public Function CmToInches(ByVal cm As String) As String Dim dCm As Decimal = CDec(cm) Dim dInches As Decimal = Math.Round(dCm * 0.393701, 3) CmToInches = dInches.ToString End Function End Class
  3. Paco75

    NullReferenceException was unhandled

    ...understand why... here is the code : Try conn.Open() 'Open a connection to database Dim stm As String = "SELECT * FROM myTable" Dim cmd As MySqlCommand = New MySqlCommand(stm, conn) Dim reader As MySqlDataReader = cmd.ExecuteReader()...
  4. Paco75

    Use of MaskedTextBox with currency?

    I think it could have done it but i prefered to use textBox keydown and keypress events. Private variable in the form to act as a flag ' Boolean flag used to determine when a character other than a number is entered. Private nonNumberEntered As Boolean = False Method to call in Keydown event...
  5. Paco75

    Use of MaskedTextBox with currency?

    Hi, I'm trying to put a MaskedTextBox in which users can type a decimal number like a money amount i.e. 12345678.99 i put 99999999.00 in the "Mask" property but i dont like the way it works with the dot... they have to move the keyboard's cursor to the dot after typing the amount to write...
  6. Paco75

    Save excel sheet into excel 95

    #DEFINE xlExcel5 39 #DEFINE xlExcel7 39 #DEFINE xlExcel9795 43 i found variables here http://fox.wikis.com/wc.dll?Wiki~ExcelConstants
  7. Paco75

    Save excel sheet into excel 95

    I seem to use the wrong value for excel5 files... you seem to say it is 43 not 39... but it solves the problem i got previously... maybe the excel was having bad formatting and saving it corrected it. Anyways, thanks for the help!
  8. Paco75

    Save excel sheet into excel 95

    ...in another excel format (just as with excel save as) http://fox.wikis.com/wc.dll?Wiki~ExcelAutomation Here is my code MyFile = GETFILE("Excel *.xls:XLS,XLSX","Importer le fichier excel:","Importer",0,"Choisissez le fichier à importer") MyNewFile = JUSTPATH(MyFile)+"\New"+JUSTFNAME(MyFile)...
  9. Paco75

    Save excel sheet into excel 95

    i mean in an automated way of course
  10. Paco75

    Save excel sheet into excel 95

    Is there a way to open and save the file in excel 95? even if it opens excel and close it it would be acceptable.
  11. Paco75

    Save excel sheet into excel 95

    if i try with excel 2007 i got the following error: "Microsoft Excel file format is invalid.
  12. Paco75

    Save excel sheet into excel 95

    Weird, here it does not work unless i save the excel file as Excel 5.0/95 Workbook :S
  13. Paco75

    Save excel sheet into excel 95

    MyFile = GETFILE("Excel *.xls:XLS","Import the excel file:","Import",0,"Choose the file to import") IF NOT EMPTY(MyFile) THEN IMPORT FROM JUSTFNAME(MyFile) TYPE XL8 && imports the XLS into a DBF ENDIF
  14. Paco75

    Save excel sheet into excel 95

    well unless another trouble unknown to me is causing this error...
  15. Paco75

    Save excel sheet into excel 95

    Yep im sure if i save the file in 97-2003 and run the program i got a message saying that excel has stopped working and wil be closed.
  16. Paco75

    Save excel sheet into excel 95

    Hi, I use the import function to convert a excel file to dbf file. But it only works with excel 95 files. So if i have excel files from latest versions (97, 2003, 2007...) i have to manually save them in excel 95 files. I there a way to save a excel file into another format programmatically...
  17. Paco75

    select combobox item using a value

    Hi, I got a combobox filled with combobox.additem('values') RowSourceType = 0 (none) On init i want to place back the value the user had selected before he left the form. When the form is closed the value is stored in a public variable. on init i do : thisform.mycombobox.value = storedValue...
  18. Paco75

    Import excel sheet to foxpro table?

    thanks it worked in Excel 5.0/95
  19. Paco75

    Import excel sheet to foxpro table?

    ...import data from excel file into a vfp table. I tried with IMPORT command but it does not work... here is the code i use: MyFile = GETFILE("Excel *.xls:XLS","Import the excel file:","Import",0,"Choose the file to import") IF NOT EMPTY(MyFile) THEN IMPORT FROM JUSTFNAME(MyFile) TYPE XL8 &&...
  20. Paco75

    Custom Grid

    Hi Mike, I think i will go with codejock extreme property grid, but when i go on their website they got only one tutorial... so im not yet sure :S

Part and Inventory Search

Back
Top