Search results for query: *

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

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

Hi, I get this error but i dont 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...

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...

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...

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

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!

I found this link that helped me in case someone want to save 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 à...

i mean in an automated way of course

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.

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

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

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

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

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.

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...

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...

thanks it worked in Excel 5.0/95

Hi, I want to 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)...

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