Search results for query: *

jebenson Thank you for the explanation. Much appreciated.

Thanks Andy, that works. Still a little confused as to why the original version didn't work but I guess I've got to change the old mindset a bit more than I realised with dot net. Thanks again

One other thing further to the above If I use the logic wrapped inside if statements the program does set the correct value ie If selectedtext = "2010" version = "V2" End If sets the version to V2 if it has been selected in the combo. I guess that's a way round it but would rather understand...

Hi Guys I hope there is someone out there that can point me in the right direction to clear up a bit of an issue I'm experiencing. I have a select case statement that is based on a value in a combobox but it doesn't appear to be working as I'd expect Here is the code: dim selectedtext as...

Excellent!!! Thanks Mike it works a treat. Slight alteration, as you suggested but it's just what I need. Thanks again Mike you're a star.

Thanks for that Mike I'll give it a go and let you know how I get on. Thanks again

Hi Guys, I hope someone here can point me in the right direction. I need to be able to sort a list of filenames in a directory by date and time. I know I can use ADIR to get a list of the files into an array and I can use ASORT to sort by the date the file was last modified or the time the file...

Hi Olaf, thanks for the input, it's much appreciated. I agree that the provider of the Excel file should take more consideration as to the format of the data but there's not a lot I can do other than provide suggestions. If the client flaty refuses to do anything other than they are...

Mike, as always, I appreciate your help and guidance so thank you. I spent a little time experimenting but can't really see how programmatically adding an apostrophe can be done effectively in this situation. I have written a program in the past that needed to save a workbook as a csv file...

Sorry, I meant to add.. Thanks for your help guys, much appreciated.

Mike Yes putting an apostrophe in front of the cell does make Fox see the number as a string. I could see how adding an apostophe would give us what we need however that is the file as we receive it and my code is supposed to import new product parts in a routine that runs overnight with no...

Hi Mike Are you using Excel 2007? I have made the spreadsheet visible. I have used the =ISTEXT() function in Excel and that returns True but when I debug the program and look at the value of the active cell in Fox the value has 5 zeroes appended to a numeric value

Thanks Mike It's not always appending exactly 5 zero's and I have already set the format of the cell with the following code: oExcel.Columns("A").EntireColumn.NumberFormat = "@" Is this incorrect?

Hi Guys, I wonder if anybody has any ideas on an odd issue I am experiencing. I'm importing a list of product codes from an excel 2007 spreadsheet using Automation. One of the codes is 111.00206 and my VFP 8 program is interpreting this a numeric value. I am not bothered by the fact that the...

Hi Thanks There was indeed a null value in one of the date fields. checking for not(isnull([date ordered])) seems to return the expected data. Thanks again

Thanks for responding Sorry for posting twice..Couldn't find the first thread..thought i must have done something stupid!! Obviously did!! I wouldn't have thought an invalid date was possible as it gets populated by the program at the front end if you see what i mean, if one was wrong, I would...

Hi Folks Bit of a weird one this. I've got two access databases same version of access, exactly the same structure (just store info for two websites) I go into one and do a simple query and I get back the expected results. Go into the other copy, and paste the exact same sql statement and I...

Hi Guys wonder if anyone can help. I have two databases. structure is exactly the same (just link to different websites). I run a query on one database and get the expected results. Run the exact same query on the other database and i get errors. Either data type mismatch errors or driver...

Thanks Guys The maths suggests that it does appear to returning all the fields regardless. I'll have to have another look at what it is we really need to be doing. Thanks again

Hi Pamela thanks for responding It only brings it across the first time it is run but 17 megs has got to be far too much for one little query surely