VB.NET formats - directly from vb.net help
Top

VB.NET

The following lists the format characters for ms:format-date().

Character(s) Description 
M Months as 1-12 
MM Months as 01-12 
MMM Months as Jan-Dec 
MMMM Months as January-December 
d Days as 1-31 
dd Days as 01-31 
ddd Days as Sun-Sat 
dddd Days as Sunday-Saturday 
y Years as 1,2 �,99 
yy Years as 1900-9999 
yyyy Years as 1900-9999 
gg Period/era (ignored if there isn't one) 

The following lists the format characters for ms:format-time().

Character(s) Description 
h Hours as 0-12 
hh Hours as 00-12 
H Hours as 0-23 
HH Hours as 00-23 
m Minutes as 0-59 
mm Minutes as 00-59 
s Seconds as 0-59 
ss Seconds as 00-59 
tt Insert AM or PM, display hurs as 12-hour clock 
t Insert A or P, display hours as 12-hour clock 

The following table shows characters you can use to create user-defined 
date/time formats. Unlike in previous versions of Visual Basic, these format 
characters are case-sensitive

(:) Time separator. In some locales, other characters may be used to represent 
the time separator. The time separator separates hours, minutes, and seconds 
when time values are formatted. The actual character used as the time 
separator in formatted output is determined by your system's LocaleID value. 
(/) Date separator. In some locales, other characters may be used to represent 
the date separator. The date separator separates the day, month, and year when 
date values are formatted. The actual character used as the date separator in 
formatted output is determined by your locale. 
(%) Used to indicate that the following character should be read as a single-
letter format without regard to any trailing letters. Also used to indicate 
that a single-letter format is read as a user-defined format. See below for 
further details 
d Displays the day as a number without a leading zero (for example, 1). Use %d 
if this is the only character in your user-defined numeric format. 
dd Displays the day as a number with a leading zero (for example, 01). 
ddd Displays the day as an abbreviation (for example, Sun). 
dddd Displays the day as a full name (for example, Sunday). 
M Displays the month as a number without a leading zero (for example, January 
is represented as 1). Use %M if this is the only character in your user-
defined numeric format. 
MM Displays the month as a number with a leading zero (for example, 
01/12/01).  
MMM Displays the month as an abbreviation (for example, Jan). 
MMMM Displays the month as a full month name (for example, January). 
gg Displays the period/era string (for example, A.D.) 
h Displays the hour as a number without leading zeros using the 12-hour clock 
(for example, 1:15:15 PM). Use %h if this is the only character in your user-
defined numeric format. 
hh Displays the hour as a number with leading zeros using the 12-hour clock 
(for example, 01:15:15 PM). 
H Displays the hour as a number without leading zeros using the 24-hour clock 
(for example, 1:15:15). Use %H if this is the only character in your user-
defined numeric format. 
HH Displays the hour as a number with leading zeros using the 24-hour clock 
(for example, 01:15:15). 
m Displays the minute as a number without leading zeros (for example, 
12:1:15). Use %m if this is the only character in your user-defined numeric 
format. 
mm Displays the minute as a number with leading zeros (for example, 12:01:15). 
s Displays the second as a number without leading zeros (for example, 
12:15:5). Use %s if this is the only character in your user-defined numeric 
format. 
ss Displays the second as a number with leading zeros (for example, 12:15:05). 
F Displays fractions of seconds. For example ff will display hundredths of 
seconds, whereas ffff will display ten-thousandths of seconds. You may use up 
to seven f symbols in your user-defined format. Use %f if this is the only 
character in your user-defined numeric format.  
T Uses the 12-hour clock and displays an uppercase A for any hour before noon; 
displays an uppercase P for any hour between noon and 11:59 P.M. Use %t if 
this is the only character in your user-defined numeric format. 
tt Uses the 12-hour clock and displays an uppercase AM with any hour before 
noon; displays an uppercase PM with any hour between noon and 11:59 P.M. 
y Displays the year number (0-9) without leading zeros. Use %y if this is the 
only character in your user-defined numeric format. 
yy Displays the year in two-digit numeric format with a leading zero, if 
applicable.  
yyy Displays the year in four digit numeric format. 
yyyy Displays the year in four digit numeric format. 
z Displays the timezone offset without a leading zero (for example, -8). Use %z if this is the only character in your user-defined numeric format. 
zz Displays the timezone offset with a leading zero (for example, -08) 
zzz Displays the full timezone offset (for example, -08:00) 

The following table identifies characters you can use to create user-defined 
number formats. These may be used to build the style argument for the Format 
function:

Character Description 
None Displays the number with no formatting. 
(0) Digit placeholder. Displays a digit or a zero. If the expression has a 
digit in the position where the zero appears in the format string, display it; 
otherwise, displays a zero in that position. 
If the number has fewer digits than there are zeros (on either side of the 
decimal) in the format expression, displays leading or trailing zeros. If the 
number has more digits to the right of the decimal separator than there are 
zeros to the right of the decimal separator in the format expression, rounds 
the number to as many decimal places as there are zeros. If the number has 
more digits to the left of the decimal separator than there are zeros to the 
left of the decimal separator in the format expression, displays the extra 
digits without modification.
 
(#) Digit placeholder. Displays a digit or nothing. If the expression has a 
digit in the position where the # character appears in the format string, 
displays it; otherwise, displays nothing in that position. 
This symbol works like the 0 digit placeholder, except that leading and 
trailing zeros aren't displayed if the number has fewer digits than there are 
# characters on either side of the decimal separator in the format expression. 

 
(.) Decimal placeholder. The decimal placeholder determines how many digits 
are displayed to the left and right of the decimal separator. If the format 
expression contains only # characters to the left of this symbol; numbers 
smaller than 1 begin with a decimal separator. To display a leading zero 
displayed with fractional numbers, use zero as the first digit placeholder to 
the left of the decimal separator. In some locales, a comma is used as the 
decimal separator. The actual character used as a decimal placeholder in the 
formatted output depends on the number format recognized by your system. Thus, 
You should use the period as the decimal placeholder in your formats even if 
you are in a locale that uses a comma as a decimal placeholder. The formatted 
string will appear in the format correct for the locale. 

(%) Percent placeholder. Multiplies the expression by 100. The percent 
character (%) is inserted in the position where it appears in the format 
string. 
(,) Thousand separator. The thousand separator separates thousands from 
hundreds within a number that has four or more places to the left of the 
decimal separator. Standard use of the thousand separator is specified if the 
format contains a thousand separator surrounded by digit placeholders (0 or 
#). A thousand separator immediately to the left of the decimal separator 
(whether or not a decimal is specified) or as the rightmost character in the 
string means "scale the number by dividing it by 1,000, rounding as needed." 

For example, you can use the format string "##0,." to represent 100 million as 
100,000. Numbers smaller than 1,000 but greater or equal to 500 are displayed 
as 1, and numbers smaller than 500 are displayed as 0. Two adjacent thousand 
separators in this position scale by a factor of 1 million, and an additional 
factor of 1,000 for each additional separator. 

Multiple separators in any position other than immediately to the left of the 
decimal separator or the rightmost position in the string are treated simply 
as specifying the use of a thousand separator. In some locales, a period is 
used as a thousand separator. The actual character used as the thousand 
separator in the formatted output depends on the Number Format recognized by 
your system. Thus, You should use the comma as the thousand separator in your 
formats even if you are in a locale that uses a period as a thousand 
separator. The formatted string will appear in the format correct for the 
locale.
 
(:) Time separator. In some locales, other characters may be used to represent 
the time separator. The time separator separates hours, minutes, and seconds 
when time values are formatted. The actual character used as the time 
separator in formatted output is determined by your system settings. 

(/) Date separator. In some locales, other characters may be used to represent 
the date separator. The date separator separates the day, month, and year when 
date values are formatted. The actual character used as the date separator in 
formatted output is determined by your system settings. 
(E- E+ e- e+) Scientific format. If the format expression contains at least 
one digit placeholder (0 or #) to the left of E-, E+, e-, or e+, the number is 
displayed in scientific format and E or e is inserted between the number and 
its exponent. The number of digit placeholders to the left determines the 
number of digits in the exponent. Use E- or e- to place a minus sign next to 
negative exponents. Use E+ or e+ to place a minus sign next to negative 
exponents and a plus sign next to positive exponents. You must also include 
digit placeholders to the right of this symbol to get correct formatting. 
- + $ ( ) Literal characters. These characters are displayed exactly as typed 
in the format string. To display a character other than one of those listed, 
precede it with a backslash (\) or enclose it in double quotation marks (" "). 
(\) Displays the next character in the format string. To display a character 
that has special meaning as a literal character, precede it with a backslash 
(\). The backslash itself isn't displayed. Using a backslash is the same as 
enclosing the next character in double quotation marks. To display a 
backslash, use two backslashes (\\). 
Examples of characters that can't be displayed as literal characters are the 
date-formatting and time-formatting characters (a, c, d, h, m, n, p, q, s, t, 
w, y, /, and :), the numeric-formatting characters (#, 0, %, E, e, comma, and 
period), and the string-formatting characters (@, &, <, >, and !).

 
("ABC") Displays the string inside the double quotation marks (" "). To 
include a string in the style argument from within code, you must use Chr(34) 
to enclose the text (34 is the character code for a quotation mark (")). 

VISTA ERROR - Run time error '5922' Word was unable to open datasource
Top

VB.NET

Vista machine with both MS word 97 and MS Word 2000
On Vista machine program bllstmt.exe compiled with VB 5.0 on VISTA machine, works good on XP

MS Word 97 upon opening always had macro storage error 
MS Word 2000 upon opening now has the 5922 unable to open error
MS Word when pressing ALT F11, then showing references has:
       vb for applications
       ole automation
       normal
       microsoft office 9.0 object library

Above works on XP but not on VISTA machine
Above works on VISTA but with Word 2007 for VISTA (not purchasing sorry MSFT!)



Set oDoc = oApp.Documents.Open(FullProgramPath, False, True)
    
With oDoc.MailMerge
        
'Set up the mail merge type as mailing labels and use
'a tab-delimited text file as the data source.

    .MainDocumentType = wdFormLetters
    .OpenDataSource (FullMergePath)  <<<<==== FAILING HERE WITH DEBUG ON
                 
    If DeliveryType = "Email" Then
        .Destination = wdSendToEmail
        .MailAddressFieldName = "Email_address"
        .MailAsAttachment = True
        .MailSubject = SYSCYCLESELECTED
        .SuppressBlankLines = True
    ElseIf DeliveryType = "Fax" Then
        .Destination = wdSendToFax
        .MailAddressFieldName = "Fax_phone_number"
        .SuppressBlankLines = True
    Else
        .Destination = wdSendToNewDocument
        .SuppressBlankLines = True
    End If

    .Execute
    

End With


In my case several items were attempted. What I had believed the fix for my 
problem was both usage of "Select method" when setting up the .txt merge mail 
information and selecting text driver vs. odbdc driver, AND, fix my column 
headings which previously had spaces and now match the field names 
being used in the document exactly: "Customer Name" vs. what it looks like 
now "Customer_Name". Spaces are not supported in newer versions of word. I 
believe the misleading error message was a result of field names being 
mismatched. This worked on one of my vista machines but not on another. Something is telling me it is the OS now, as of 10/3/08 I'm not sure what is happening; some type of vista security is not permitting this action.

WARNING - be attentive when re-assigning the datasource there is a little tiny 
checkbox when browsing for your datasource that you'll need to click "SELECT 
METHOD"


please reference Microsoft website for fix or just read below

http://msdn.microsoft.com/en-us/library/aa140183.aspx

Text Files

Delimited text and comma-separated value files are standard data formats. 
Almost any program that imports and exports data supports one or both, be it a 
Windows, DOS, or mainframe application. Up through Word 95, using text files 
as a data source was a fairly straightforward proposition. 

But if you're merging in Office 97 (and on Office 2000 machines upgraded from 
an earlier version), you're likely to run into a number of problems: The 
individual fields aren't recognized, the names all run together as a single 
field, and error messages like "Word was unable to open the data source" 
appear. The culprit is the text ODBC driver with which Word does not 
communicate correctly. To link up to your data source, you have three options: 


1)        uninstall the ODBC driver; 

2)        activate the Select method checkbox so you can specify Word's 
internal text file converter as the link method (see FIGURE 1); 

3)        rename the file with an extension the ODBC driver doesn't recognize 
(such as .dat), so that Word automatically uses its internal text file 
converter. 

"Virgin" Office 2000 installations shouldn't have this problem, as Microsoft 
didn't include the Text ODBC converter as one of the recognized link methods. 

If you use a Header file to define the field names for the data source (as is 
often the case with data coming from a mainframe), an annoying automation 
obstacle you'll encounter in all versions of Word is a dialog box requesting 
you to confirm the field and record delimiters. For this, too, there are a 
couple of work-arounds: 


1)        Create the Header file as a Word table, or

2)        duplicate the first line of the Header file, so that it contains two 
lines with the same number of fields using the same field delimiter (Note: 
This only works for field delimiters, not for record delimiters.): 

FirstName~LastName~Address~City~PostalCode
FirstName~LastName~Address~City~PostalCodeText files created with non-ANSI 
character sets present a problem. Word will open them for mail merge 
automatically, without recognizing their origin or giving you the opportunity 
to convert them. For a DOS file, with ASCII Code Page encoding, you could get 
something like this: 

Vous ^tes all,s ... Bfle. instead of: 

Vous �tes all�s � B�le. Looking at the OpenDataSource method of the MailMerge 
object, you may notice the Format argument and think this provides a way out. 
Unfortunately, it's generally ignored by Word, even if you use one of the 
built-in constants. What does work is opening the document manually in Word. 
With Tools | Options | General | Confirm conversion at open activated, select 
the correct conversion filter, and save it as a Word document for use as the 
data source. However, there is no ideal way to automate this. Again, in the 
Open method, Word provides no way to specify the correct converter. You have 
to rely on SendKeys to make the proper selection, and confirm it in the 
Confirm Conversions dialog box: 


szFileName = "E:\My Documents\Mergdata.txt" Options.ConfirmConversions = True
SendKeys "^{HOME}MS-DOS Text{ENTER}" 
Set doc = Documents.Open(FileName:=szFileName) 
doc.SaveAs Left(szFileName, Len(szFileName) - 3) & "doc" 

To contact me, please (Author of this website) E-mail me at:
jep1965@gmail.com

This page last updated August 28 2008

Hosted by www.Geocities.ws