Search results for query: *

You would be better off structuring your dates as yyyy/mm/dd." This is guaranteed to work I believe the Date format for SQL Date Range Queries needs to be in USA Format (#MM/DD/YYYY#) Even if you are in UK, Australia, etc Also the select Operation needs to use BETWEEN Something like...

However there are no plans to include VB6 runtime in future versions of Windows beyond Windows 7." I wonder what that is supposed to mean ? I never knew VB6 runtime was included in any of the Windows operating systems (I always install it myself). I have never wanted Microsoft to have the...

I am at a loss how to do this I want to convert a text field like "1.5" into a decimal field which Delphi Pascal can process The data will be processed in a system script in Ostendo (If that helps) StrToInt is DEFINITELY NOT the answer I just cannot find ANY reference on how to do this -...

Thank you Tom - excellent!

If I were to take a text based cobol and upgrade to a windows cobol, which would it be ? In particular, while I would want the system to look like a true windows system and have mouse operability, it would be really nice if it also provided "thin client" connectivity optionally (not using...

Sorry guys - I am saying "PRINT" but am meaning Display on the Screen (Spent too much time in VB Land where Print is used to Display data) So if the Pic 9(2) Comp field contains 123 (it has a maximum value of hex FF = 256), then I would normally get a crash - its trying to print 3 digits when...

I use BOS Cobol If you examine a record on DISK with a HEX VIEWER then you will see data stored in HEX with values of Semi-Bytes being between 0 and F ie, a Value of 12 in a Pic 9(2) Comp field (which takes up 1 byte) would look like '0C' How would the same value look like in your cobol (when...

NORMAL RULES This is normally the case (as explained above) Anything larger than 99999.99 will be truncated. Anything smaller than -99999.99 will be truncated. HOWEVER If the value is stored as a computational variable, then internally, the variable is stored "Base 16" - ie, each semi-byte...

I have a free routine (MDE) which allows me to convert Access forms to VB. Problem is it converts from Access 97 which I don't have any more. Is there a version which can convert from Access 2000 (not necessarily my one) FOR FREE (MINE WAS FREE). Appreciate any help

Why Redim at all ? Why not "dim" the array size initially to a maximum, and test that you don't exceed the theoretical maximum size. If in fact you by chance do hit the maximum, only THEN use the redim statement.

You're right about the dates being text. The sheet was created by a generic program under VB automatically. I therefore don't know if a column is going to be a date or not. Your suggestion works, but if you highlight the column heading rather than every row affected, I get 65565 resulting...

It seems that in Australia (date format dd/mm/yyyy) Excel cannot easily sort a sheet based on a column containing a date) In fact, even if your REGIONAL SETTINGS are set to English Australia, Excel does not offer a standard date format of dd/mm/yyyy. Data was imported into the column...

I would like to be able to merge data into a Word/RTF document WITHOUT WORD popping up every time I do this - then I would like to print the resultant Document, again, WITHOUT word popping up. Is this possible ? I understand the other way (create object word.app) which causes word to pop up...

I GOT IT ! - I GOT IT ! Thanks a million - I kept seeing the OTHER FAVORITES (next to search)

Sorry - I'm just not getting this. I have Windows XP Professional - there is no Favorites under the Start Button. If I open Explorer and Click Favorites I get 2 options Add and Organize. Under Organize I can DRAG each entry to where I want it - that's NOT what I want to do as I have hundreds of...

Sorry again - I am using XP Professional which doesn't seem to have the menu item you are talking about - I am still in the dark ....

Sorry - I can't find what you are talking about. I have arranged my favourites in a series of FOLDERS (Must be more than 100). I just want to get the FOLDERS into alphabetical order. Any Ideas ??

I can't believe I can't do this - I have tried and tried to organise my favourites into alpha order but cannot (automatically). I have even tried copying them out to another directory, deleting them, then copying back - bit still they remain in a "semi unsorted" order. What is the...

Where the excluded keys go (when you uncheck the box in MSCONFIG) is : hkey_local_machine\software\microsoft\shared tools\msconfig\startupfolder or one of the startup folders under msconfig Thats how I finally deleted the blasted msblast off my msconfig list! PS I found this by running...

I hadn't heard of the CopyObject method - thanks for that ! What I really want to do is copy the data from one table and insert it into a table in another database. The reason I am doing this is because I changed the LENGTHS of some of the variables and I want to create a more compacted version...