Search results for query: *

thanks again for trying to help combo .. I can add a package, but the problem is when I try to copy and paste the file into it's application folder out of the Powerpoint document the binary data in the file is corrupt / updated by powerpoint - not only does it add a file path but it also messes...

thanks Combo .. I believe I have tried your suggestion - thanks for that. For example - In Powerpoint 2010 - I go Insert --> Object --> From File ... select the EX4 file and it embeds fine. I have done the same thing with a ZIP file containing the EX4 file. Problem is, the .EX4 file appears...

Hello Everyone .. I was wondering whether there was a way to embed a file (.EX4) into a Powerpoint presentation - Mainly to transport it with the rest of a package so that users can use it while going through the presentation. The idea is not to run the file within the presentation, but merely...

Hi All .. I'm playing around with a program (not very good at it) and have written the below piece of code so far: All of the below code is added to my main form and therefore loads when the application is started. The code basically connects to a database and then dynamically creates a...

fantastic thanks for all your help bborissov

my mistake sorry! works a treat now! the latest date gets displayed first ... is there a way to display the oldest date first instead but still keep the dates at the top? thanks again for all your help!

Hi bborissov Yep I don't care how the other fields are sorted .. but at the moment .. if the column looks like this: mm-dd-yyyy mm-dd-yyyy mm-dd-yyyy mm-dd-yyyy TBD Abandoned Abandoned mm-dd-yyyy mm-dd-yyyy mm-dd-yyyy then only the top 4 dates get sorted ... until the query reaches the first...

Hi bborissov The query works for all the values in the column that are dates until it finds the first non-date value (TBD, Abandoned etc) ... after that the OrdBy column displays 1900-01-01 00:00:00:000 for all the other columns inc. the ones that do have actual dates in for values. thansk for...

thanks bborissov will try it out again tomorrow once i have access to this system again. A

cheers bborissov almost something like that yes .. you query looks good however the date is not sorted/ordered properly .... as the column is not of datatype Date, the query does not seem to know how to sort the strings that are in a date format. It does something like this: 29/08/2008...

Hi there I have a column (varchar(255). This column contains either dates in the format dd/mm/yyyy, the string "TBD" or the string "Abandoned". I was wondering if there was a way to select all the data in this column but order the data so that the all the rows with dates are displayed first...

Hi there all .. I think I know what the answer to this question might be, but I'll ask anyway. Is there a plug-in, or a way to make VB6 Forms look a bit nicer? without converting to something like VB.NET? I know that VB6 probably IS very old by now but was wondering if there was something...

thanks again tsuji great stuff

thanks all ... i have global set and would therefore like to save all instances of the pattern that i find in a variable in the below format. "BBB89765678 & BBB09567865" I can then use that variable to set the value of other cells ..

thanks tsuji i already have a loop ... i would like to know how i can store each pattern found in a variable. for example. if i search/test the string: "asfsBBB12345876gfff" I would like to store "BBB12345876" in a variable. Another example: If I say test the string...

Sorry one more thing ... I'm struggling to now save the value found as a variable so that I can use it to populate another cell .. any ideas? Something I should also have mentioned was that what if there are 3 of these BBB's in one cell ... I would like to populate a target cell with all of...

Perfect thanks tsuji !

thanks for the info tsuji ... it gives me an idea what to look for howerver these examples don't appear to find anything. for example .. the string i search looks like this: "sdgfdg eqwwe234 asfdsfBBB54538765dfgsd" x is say declared as a Bolean i then do: x = BBBReg.Test(String) .... but x...

just to further clarify .... i don't expect all of the code to be written for me but if someone could help me with the pattern then that would be great .. something like the below maybe? RTEReg.Pattern = "BBB????????

Hi there I was hoping someone could please help me. I have managed to write a bit of code that reads from one excel spreadsheet and then create a populate a new spreadsheet with this data. One of the columns in the source spreadsheet is a description column. This column could contain any...