Surely this is a Bug

Microsoft Word developer's have proven once again their determination to 
make the goal of a simple and reliable means of validating content control 
contents seemingly impossible.

The OnExit event has been buggy since the release of Word and MS simply 
doesn't seem to care.

For the last several days I have been getting closer and closer to finding a 
reliable (far from simple) means.  At first I thought that the CustomXMLPart 
NodeAfterReplace event would fit the bill.  Unfortunately when a mapped CC 
starts out life with the placeholder text displayed then the corresponding 
node contains a null value.  When content is added to the CC this 
replacement of "null" with "something" is not detected by the event.  Only 
replacing "something" with "something else" triggers the event.  (bug or by 
design I am not certain?)

Next I experimented with NodeAfterInert.  Sure enough when I replace CC 
placeholder text with something else and tab to the next CC this event 
fires.  Almost ready to proclaim EUREKA, I encountered more bugging 
behavior!!

When the event first is inconsistent!!  To work as a CC validation event it 
must not fire until "after" the user enters the data an exists the CC. 
Unfortunately sometimes if fires after the data is entered and the user 
leaves the CC, but other times it fires immediately after the user enters 
the first character.  Thsi has to be a bug!! Why on earth should it fire on 
first character entry and the bigger issue is however it fires it should 
fire consistently.

You can observe this behavior using the following steps:

1.  Open a new Word Document.
2.  Paste the following code in the "ThisDocument" class module:

Option Explicit
Dim WithEvents oMonitor As CustomXMLPart
Sub SetMonitor()
On Error Resume Next
Set oMonitor = ThisDocument.CustomXMLParts(4)
End Sub
Private Sub oMonitor_NodeAfterInsert(ByVal NewNode As Office.CustomXMLNode, 
ByVal InUndoRedo As Boolean)
Main.CCValidaton NewNode
End Sub
Private Sub oMonitor_NodeAfterReplace(ByVal OldNode As Office.CustomXMLNode, 
ByVal NewNode As Office.CustomXMLNode, ByVal InUndoRedo As Boolean)
Main.CCValidaton NewNode
End Sub

3.  Paste the following code in a standard module and run AddCCsAndMap. 
This will add four mapped CCs to the document.

Option Explicit
Sub AddCCsAndMap()
Dim oCC As ContentControl
With ActiveDocument
  .Range.InsertAfter "Test 1: "
  .Bookmarks("\endofdoc").Select
  Set oCC = .ContentControls.Add(wdContentControlText)
  oCC.Title = "Test 1"
  .Range.InsertAfter vbCr + vbCr & "Test 2: "
  .Bookmarks("\endofdoc").Select
  Set oCC = .ContentControls.Add(wdContentControlText)
  oCC.Title = "Test 2"
 .Range.InsertAfter vbCr + vbCr & "Test 3: "
  .Bookmarks("\endofdoc").Select
  Set oCC = .ContentControls.Add(wdContentControlText)
  oCC.Title = "Test 3"
  .Range.InsertAfter vbCr + vbCr & "Test 4: "
  .Bookmarks("\endofdoc").Select
  Set oCC = .ContentControls.Add(wdContentControlText)
  oCC.Title = "Test 4"
End With
MapCCs
ThisDocument.SetMonitor
End Sub

Sub MapCCs()
Dim oCC As ContentControl
Dim pXML As String
Dim oCustXMLPart As CustomXMLPart
Dim XPath As String
pXML = "<?xml version='1.0' 
encoding='utf-8'?><Main><Test_1></Test_1><Test_2></Test_2><Test_3></Test_3>" 
_
       & "<Test_4></Test_4></Main>"
ClearXMLParts
Set oCustXMLPart = ActiveDocument.CustomXMLParts.Add(pXML)
Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 1").Item(1)
XPath = "/Main/Test_1[1]"
oCC.XMLMapping.SetMapping XPath
Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 2").Item(1)
XPath = "/Main/Test_2[1]"
oCC.XMLMapping.SetMapping XPath
Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 3").Item(1)
XPath = "/Main/Test_3[1]"
oCC.XMLMapping.SetMapping XPath
Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 4").Item(1)
XPath = "/Main/Test_4[1]"
oCC.XMLMapping.SetMapping XPath
Set oCC = Nothing
Set oCustXMLPart = Nothing
End Sub
Sub ClearXMLParts()
Dim i As Long
For i = ActiveDocument.CustomXMLParts.Count To 4 Step -1
  ActiveDocument.CustomXMLParts(i).Delete
Next i
End Sub

Sub CCValidaton(oNode As Office.CustomXMLNode)
Dim pStr As String
pStr = oNode.Text
With ThisDocument
  Select Case oNode.ParentNode.BaseName
    Case "Test_1"
      If Len(pStr) < 5 Then
        MsgBox "Invalid entry"
        .SelectContentControlsByTitle("Test 
1").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
      Else
        .SelectContentControlsByTitle("Test 
1").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
      End If
    Case "Test_2"
      If Len(pStr) < 5 Then
        MsgBox "Invalid entry"
        .SelectContentControlsByTitle("Test 
2").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
      Else
        .SelectContentControlsByTitle("Test 
2").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
      End If
    Case "Test_3"
      If Len(pStr) < 5 Then
        MsgBox "Invalid entry"
        .SelectContentControlsByTitle("Test 
3").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
      Else
        .SelectContentControlsByTitle("Test 
3").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
      End If
    Case "Test_4"
      If Len(pStr) < 5 Then
        MsgBox "Invalid entry"
        .SelectContentControlsByTitle("Test 
4").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
      Else
        .SelectContentControlsByTitle("Test 
4").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
      End If
  End Select
End With
End Sub

4.  Click in the Test 1 CC and enter 1 to 4 characters then tab.  This will 
show you the expected behavior.

5.  The focus is now in Test 2 CC.  Type a single character.  This will show 
you the unexpected behavior and the bug!

6.  The focus is now in Test 3 CC.  This one behaves as expected.  Test 4 is 
unexpected.

For whatever reason every other CC behaves unexpectantly.  If you start with 
Test 2 then is is OK but Test 3 then fails.  Start with 4 OK but Test 1 
fails.

I have repeated this behavior consistently over 50 times.

Appreciate any response confirming this behavior and earnestly hoping that 
fixed in Word2010.

-- 
Greg Maxey

See my web site http://gregmaxey.mvps.org
for an eclectic collection of Word Tips.

Arrogance is a weed that grows mostly on a dunghill (Arabic proverb)



0
Greg
11/12/2009 4:58:00 PM
word.vba.general 1023 articles. 0 followers. Follow

1 Replies
856 Views

Similar Articles

[PageSpeed] 14

This gets even weirder.

If you add a CC between each of the four mapped CCs then cycle through the 
CCs each performs as expected (i.e., the event doesn't fire in the second 
and fourth control until after the user completes the text entry and exits 
the CC.  This the odd behavior also does occur if you enter the text in 
CC1>tab to CC2>click out of CC2>click back into CC2.

It seems that the event is somehow hanging and doesn't reset until you cycle 
in and out of the CC.  Weird.

"Greg Maxey" <gmaxey@mIKEvICTORpAPAsIERRA.oSCARrOMEOgOLF> wrote in message 
news:eRAJJl7YKHA.1596@TK2MSFTNGP06.phx.gbl...
> Microsoft Word developer's have proven once again their determination to 
> make the goal of a simple and reliable means of validating content control 
> contents seemingly impossible.
>
> The OnExit event has been buggy since the release of Word and MS simply 
> doesn't seem to care.
>
> For the last several days I have been getting closer and closer to finding 
> a reliable (far from simple) means.  At first I thought that the 
> CustomXMLPart NodeAfterReplace event would fit the bill.  Unfortunately 
> when a mapped CC starts out life with the placeholder text displayed then 
> the corresponding node contains a null value.  When content is added to 
> the CC this replacement of "null" with "something" is not detected by the 
> event.  Only replacing "something" with "something else" triggers the 
> event.  (bug or by design I am not certain?)
>
> Next I experimented with NodeAfterInert.  Sure enough when I replace CC 
> placeholder text with something else and tab to the next CC this event 
> fires.  Almost ready to proclaim EUREKA, I encountered more bugging 
> behavior!!
>
> When the event first is inconsistent!!  To work as a CC validation event 
> it must not fire until "after" the user enters the data an exists the CC. 
> Unfortunately sometimes if fires after the data is entered and the user 
> leaves the CC, but other times it fires immediately after the user enters 
> the first character.  Thsi has to be a bug!! Why on earth should it fire 
> on first character entry and the bigger issue is however it fires it 
> should fire consistently.
>
> You can observe this behavior using the following steps:
>
> 1.  Open a new Word Document.
> 2.  Paste the following code in the "ThisDocument" class module:
>
> Option Explicit
> Dim WithEvents oMonitor As CustomXMLPart
> Sub SetMonitor()
> On Error Resume Next
> Set oMonitor = ThisDocument.CustomXMLParts(4)
> End Sub
> Private Sub oMonitor_NodeAfterInsert(ByVal NewNode As 
> Office.CustomXMLNode, ByVal InUndoRedo As Boolean)
> Main.CCValidaton NewNode
> End Sub
> Private Sub oMonitor_NodeAfterReplace(ByVal OldNode As 
> Office.CustomXMLNode, ByVal NewNode As Office.CustomXMLNode, ByVal 
> InUndoRedo As Boolean)
> Main.CCValidaton NewNode
> End Sub
>
> 3.  Paste the following code in a standard module and run AddCCsAndMap. 
> This will add four mapped CCs to the document.
>
> Option Explicit
> Sub AddCCsAndMap()
> Dim oCC As ContentControl
> With ActiveDocument
>  .Range.InsertAfter "Test 1: "
>  .Bookmarks("\endofdoc").Select
>  Set oCC = .ContentControls.Add(wdContentControlText)
>  oCC.Title = "Test 1"
>  .Range.InsertAfter vbCr + vbCr & "Test 2: "
>  .Bookmarks("\endofdoc").Select
>  Set oCC = .ContentControls.Add(wdContentControlText)
>  oCC.Title = "Test 2"
> .Range.InsertAfter vbCr + vbCr & "Test 3: "
>  .Bookmarks("\endofdoc").Select
>  Set oCC = .ContentControls.Add(wdContentControlText)
>  oCC.Title = "Test 3"
>  .Range.InsertAfter vbCr + vbCr & "Test 4: "
>  .Bookmarks("\endofdoc").Select
>  Set oCC = .ContentControls.Add(wdContentControlText)
>  oCC.Title = "Test 4"
> End With
> MapCCs
> ThisDocument.SetMonitor
> End Sub
>
> Sub MapCCs()
> Dim oCC As ContentControl
> Dim pXML As String
> Dim oCustXMLPart As CustomXMLPart
> Dim XPath As String
> pXML = "<?xml version='1.0' 
> encoding='utf-8'?><Main><Test_1></Test_1><Test_2></Test_2><Test_3></Test_3>" 
> _
>       & "<Test_4></Test_4></Main>"
> ClearXMLParts
> Set oCustXMLPart = ActiveDocument.CustomXMLParts.Add(pXML)
> Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 1").Item(1)
> XPath = "/Main/Test_1[1]"
> oCC.XMLMapping.SetMapping XPath
> Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 2").Item(1)
> XPath = "/Main/Test_2[1]"
> oCC.XMLMapping.SetMapping XPath
> Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 3").Item(1)
> XPath = "/Main/Test_3[1]"
> oCC.XMLMapping.SetMapping XPath
> Set oCC = ActiveDocument.SelectContentControlsByTitle("Test 4").Item(1)
> XPath = "/Main/Test_4[1]"
> oCC.XMLMapping.SetMapping XPath
> Set oCC = Nothing
> Set oCustXMLPart = Nothing
> End Sub
> Sub ClearXMLParts()
> Dim i As Long
> For i = ActiveDocument.CustomXMLParts.Count To 4 Step -1
>  ActiveDocument.CustomXMLParts(i).Delete
> Next i
> End Sub
>
> Sub CCValidaton(oNode As Office.CustomXMLNode)
> Dim pStr As String
> pStr = oNode.Text
> With ThisDocument
>  Select Case oNode.ParentNode.BaseName
>    Case "Test_1"
>      If Len(pStr) < 5 Then
>        MsgBox "Invalid entry"
>        .SelectContentControlsByTitle("Test 
> 1").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
>      Else
>        .SelectContentControlsByTitle("Test 
> 1").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
>      End If
>    Case "Test_2"
>      If Len(pStr) < 5 Then
>        MsgBox "Invalid entry"
>        .SelectContentControlsByTitle("Test 
> 2").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
>      Else
>        .SelectContentControlsByTitle("Test 
> 2").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
>      End If
>    Case "Test_3"
>      If Len(pStr) < 5 Then
>        MsgBox "Invalid entry"
>        .SelectContentControlsByTitle("Test 
> 3").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
>      Else
>        .SelectContentControlsByTitle("Test 
> 3").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
>      End If
>    Case "Test_4"
>      If Len(pStr) < 5 Then
>        MsgBox "Invalid entry"
>        .SelectContentControlsByTitle("Test 
> 4").Item(1).Range.Shading.BackgroundPatternColor = wdColorRose
>      Else
>        .SelectContentControlsByTitle("Test 
> 4").Item(1).Range.Shading.BackgroundPatternColor = wdColorAutomatic
>      End If
>  End Select
> End With
> End Sub
>
> 4.  Click in the Test 1 CC and enter 1 to 4 characters then tab.  This 
> will show you the expected behavior.
>
> 5.  The focus is now in Test 2 CC.  Type a single character.  This will 
> show you the unexpected behavior and the bug!
>
> 6.  The focus is now in Test 3 CC.  This one behaves as expected.  Test 4 
> is unexpected.
>
> For whatever reason every other CC behaves unexpectantly.  If you start 
> with Test 2 then is is OK but Test 3 then fails.  Start with 4 OK but Test 
> 1 fails.
>
> I have repeated this behavior consistently over 50 times.
>
> Appreciate any response confirming this behavior and earnestly hoping that 
> fixed in Word2010.
>
> -- 
> Greg Maxey
>
> See my web site http://gregmaxey.mvps.org
> for an eclectic collection of Word Tips.
>
> Arrogance is a weed that grows mostly on a dunghill (Arabic proverb)
>
>
> 


0
Greg
11/12/2009 9:15:12 PM
Reply:

Similar Artilces:

Calculation Bug?
There appears to be a bug in Excel which is causing me considerable woes. Maybe it is functioning as intented but i cannot imagine any reason why. There are tables on two sheets, and each one has VLOOKUP functions and autofilter applied. There are no circular references. There are dynamic named ranges for some columns in each table. Excel re-calculates the entire workbook every time I make any change. This even occurs if the change is not in a cell referenced by functions in either table. If i change the autofilter, it also recalculates. Since VLOOKUP and the dynamic named ranges are ...

Not sure why this code isn't working
Hello, I have a subform in Access 2003 with these fields, type of day, OLPEndDate, OLPBeginDate. At the end of each row, I want to calculate the total day taken for that particular vacation request, so if a person took 12/1/2009-12/2/2009 then the last field "TotalOLPTaken" should calculate as 1. What's happening is that it does calculate but all of the rows calculate to the same number. If I put the cursor in the second row and that row happens to have 12/4/2009-12/6/2009, then even the row with 12/1-12/2 calculates as 2. Then if I put the cursor back in the fi...

Not Sure
Hi, Can anyone help? If I use a Form selecting from the range "make" I want the next Form to be able to pick from the "model" range of that make. So if I picked Ford in the 1st form, the 2nd form will only give me the options of Mondeo LxTD or Mondeo Aspen. The other information I can already obtain using Vlookup() but I cannot find a way of inputting the "model" range into the Vlookup() In cell A1 the form will bring in the option picked (ford Or Vauxhall) What I need is in cell B2 I want to be able to pick from only the cars made by ford or vauxhall...

Is it a bug?
ROUND(((2226-123.36-39.34-303)-1600)*0.05, 2) == 8.01 No. If you increase the DP to about 10 DP without the ROUND Function you will see the answer is 8.014999999999900 ROUND rounds it up to 8.01 Gord Dibben MS Excel MVP On Mon, 10 Dec 2007 08:45:26 +0800, "Cai Bing Lin" <half_worm{at} 163.com> wrote: >ROUND(((2226-123.36-39.34-303)-1600)*0.05, 2) == 8.01 > thank you . But when I use VBA. It will be 8.02? why? To 13 decimal places without the Round function (((2226-123.36-39.34-303)-1600)*0.05) is 8.0150000000000 "Gord Dibben" <gorddibbAT...

Do You Want To Know For Sure That You Are Going To Heaven? The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news
The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Heaven which is described in the Holy Bible as a beautiful place with no death, sorrow, sickness or pain. God tells us in the Holy Bible how simple it is to be saved so that we can live forever with Him in Heaven. "For if you confess with your mouth Jesus is Lord and believe in your heart that God raised Him from the dead, you WILL BE SAVED." (Romans 10:9) Over 2000 years ago God came from ...

ListCount bug: is it OK in A2007?
I'd like to point you to UtterAccess http://www.utteraccess.com/forums/showflat.php?Cat=&Board=83&Number=1427385&Zf=&Zw=&Zg=1&Zl=a&Main=1427385&Search=true&where=&Zu=122546&Zd=l&Zn=&Zt=26&Zs=&Zy=#Post1427385&Zp= You may need to include the equal sign = at the end of URL to get into the right place. I'd like to know if the ListCount bug has been fixed in A2007. TIA Vlado � "Vladim�r Cvajniga" <NOSPAM@THANK.YOU> ������ ��� ������ news:exjrhhxTIHA.4532@TK2MSFTNGP02.phx.gbl... > I'd like to ...

BUG in MFC vc2008!
Hello Microsoft's guys! :-) I have detected a bug in MFC, with vc2008! Take a look at afxstate.cpp: Line 185-190: m_pDllIsolationWrappers = new CDllIsolationWrapperBase*[_AFX_ISOLATION_WRAPPER_ARRAY_SIZE]; #ifndef _AFX_NO_AFXCMN_SUPPORT m_pDllIsolationWrappers[_AFX_COMCTL32_ISOLATION_WRAPPER_INDEX] = new CComCtlWrapper; #endif m_pDllIsolationWrappers[_AFX_COMMDLG_ISOLATION_WRAPPER_INDEX] = new CCommDlgWrapper; m_pDllIsolationWrappers[_AFX_SHELL_ISOLATION_WRAPPER_INDEX] = new CShellWrapper; Then line 335-339: #ifndef _AFX_NO_AFXCMN_SUPPORT delete m_pDllIsolationWrappers[_AFX_COMCTL32...

Not sure.
Ok, Kinda new a formuals for Execl 2003 / 2007 I have catalog numbers in column A B LNL FNM BLB TNT KBA BER these are cross reference numbers for a fuse company, what formula would you use that if you choose LNL and it would reference cell "B" FNM, Hi Old Guy I would use VLOOKUP, check it out in Excel Help. Regards John ( Old Guy too ) "Old Guy" <OldGuy@discussions.microsoft.com> wrote in message news:E10D6AF2-F61D-481D-99C4-1D06F3F57CF8@microsoft.com... > Ok, Kinda new a formuals for Execl 2003 / 2007 I have catalog numbers in > co...

2005 Bug: The list is temporarily (always!) unavailable.
Problem Description: When I try to setup online services I always get this message, "The list is temporarily unavailable. Please try again later." Frequency of problem: Always Happens Operating system / version: Microsoft Windows XP Professional - 5.1.2600 Computer manufacturer and model: Dell Computer Corporation, Dimension 8200 Processor model and speed: I586IV, 1993 MHz Memory (RAM): 523.276 MB ...

Volume Shadow Copy - how to test to make sure new copies are being created?
Hey folks, I am running into a problem where several of our Windows 2003 servers are no longer creating shadow copies on their shares. The Volume Shadow Copy service kicks off periodically like it should, but there are no new copies being created (there is plenty of disk space available). However, I'm not necessarily looking for a fix on that front - it would be nice to fix it, but I have a higher-level goal in mind - I need to *test* to make sure these copies are being created on all of our file servers. (I'm not actually a Windows file server admin, I'm the guy i...

Do You Want To Know For Sure That You Are Going To Heaven? The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news
The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Heaven which is described in the Holy Bible as a beautiful place with no death, sorrow, sickness or pain. God tells us in the Holy Bible how simple it is to be saved so that we can live forever with Him in Heaven. "For if you confess with your mouth Jesus is Lord and believe in your heart that God raised Him from the dead, you WILL BE SAVED." (Romans 10:9) Over 2000 years ago God came from ...

Outlook 2003 or 2002 Not sure?
I can't figure out why when I hotsynic from the handheld to the computer, why there is always duplicates of some names? It does this do ways, if i hotsynic either way: from the computer to the handheld or vise versa. Can someone help? I'd check with your handheld manufacturer's support people (or whoever makes the conduit for Outlook). Stephen wrote: > I can't figure out why when I hotsynic from the handheld > to the computer, why there is always duplicates of some > names? It does this do ways, if i hotsynic either way: > from the computer to the handheld or ...

OWA bug
anybody seen this problem ? We are running Exchange 2003 (upgraded from Exchange 2000) on Server 2003 (upgraded from 2000 Server) and when some people use OWA to send emails, a question mark (?) character always shows up at the beginning of the message body when the recipient views this. When the sender is typing the message, there is no indication of the '?' in the message body. Thanks for any help... ...

Microsoft Bug?
I'm reporting a weird problem... either in MFC or Remote Desktop (both belongs to Microsoft) I have this simple MFC code which draw a red ellipse (circle) and green background color. When view directly through local machine, it's okay. However when viewed through Remote Desktop Control (of the same color resolution), the background color overfill beyond the circle boundary. You could see this clearly in image.bmp The problem don't exist if - Viewed through VNC Viewer - Draw a rectangle instead of the same size - Draw the ellipse bigger Since I can't post any attachment...

Money 2004 bugs
I have just spent a rather unpleasant hour with Money 2004 doing a task that used to take me 15 minutes with Quicken -- downloading and categorizing my MBNA credit card statement. Problem 1: if you have multiple uncategorized transactions in the download with exactly the same payee, when you enter the category for the first, the other transactions don't inherit this information. You have to enter it for each (not so in Quicken). Problem 2: sometimes when you display a transaction for categorizing, the payee line is doubled, as is the line with the accept and enter buttons. Problem 3: Mo...

Bug in COM Interop Sample?
I'm trying to run the sample program used to demonstrate Exposing .NET Framework Components to COM. (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcominteropsamplecomclientnetserver.asp). The application is crashing when it attempts to instantiate the COM ptr. Anyone have any experience with this sample, or this topic? Any idea what's going wrong here? ...

Do You Want To Know For Sure That You Are Going To Heaven? The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news
The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Heaven which is described in the Holy Bible as a beautiful place with no death, sorrow, sickness or pain. God tells us in the Holy Bible how simple it is to be saved so that we can live forever with Him in Heaven. "For if you confess with your mouth Jesus is Lord and believe in your heart that God raised Him from the dead, you WILL BE SAVED." (Romans 10:9) Over 2000 years ago God came from ...

Very easy I'm sure
Afternoon.. This is the easiest thing to do i'm sure but i cant!! I need to enter a date into a cell format. 170983 and it change it to show. 17/09/1983. I cant find this in the formatting options as all show in mmddyyyy format. Thanks James -- themax16 ------------------------------------------------------------------------ themax16's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23622 View this thread: http://www.excelforum.com/showthread.php?threadid=478218 Morning..<g> Excel number formatting (including date/time, etc.) is generally not ...

VS2008 (Std) Bug
Hi, I think the VS2008 standard version has a bug. I installed MySql DB software. A person using VS2008 (Pro) has no problem but me with VS2008 (Std) notices the software will not load the MySql Store Procedures. I used an alternative DB app and it did recognize the procedures. My environment: o MySQL server 5.1.31x32 on local Vista workstation o MySQL c/NET 6.2.1 msi installed with "Complete" option o VS2008 (Std) Since, the VS2008 (Pro) and the alternative MySQL Manager apps recognizes the c/NET 6.x store procedures... I can only assume: VS2008 (Std) has ...

CHtmlView bug ?
Hi, I created a simple MDI application, using CHtmlView as the view class. I guess I found a problem. When I open an Excel file inside the view, I see an Excel.exe is running, using task manager. But after I close that view, the Excel.exe is still running until the whole application is closed. Is there some way to fix the bug ? Or it's not a bug ? Thanks in advance Jeff ...

Not sure what to do?
I have an Access database containing general information about students. Each of those students has a seperate excel spreadsheet containing their "plan" for schooling. I need to somehow setup a link or something where I while I am in the Access database, click a button and open that particular students plan. I'm not sure what the best process is, or where to start. Any suggestions? Dear Patti, Create a field that contains the path to that excel spreadsheet. Then create a button and put dim strPath as string strPath = me!Name_Of_Field_That_Contains_File_path followh...

Dual monitor bug between Entourage and Word
Dual monitor bug between Entourage and Word Set up: Open Entourage on either the main monitor or the secondary monitor. Open a Word document on the secondary monitor only. Problem: If you minimize Entourage to the Dock, or restore it from the Dock, the Word document window will shrink to an unusable size, whether or not Word has the "focus". This does NOT occur if the Word document is on the main monitor. Has anyone else seen this problem? Come up with a solution? On 2/20/08 6:49 PM, in article ee8e335.-1@webcrossing.caR9absDaxw, "whytwolfasu@officeformac.com" <whyt...

VS 7.1 IDE bug w/ Events
Hi, Might as well post here; I just came up with a few compiler errors; after changing several functions around. Here is what I have done: I have a dialog, with an existing OnNMRclickAvatarsLeft(NMHDR *pNMHDR, LRESULT *pResult) [NMRC] in it, I tab out this entire function for archival. I also remove its Message Map entry, I do not remove its function defenition. I attempt to add the same [NMRC] function again via right click and add event, it denies this saying the function already exists. I remove the function header, and add the function again via right click and add event. The IDE...

conbo box bug
I have a combo box with an input range of numbers formatted as %. I figured out how to format the box as % to the 3rd decimal. ComboBox3.Value = Format(ComboBox3.Value, "0.000%") (seems to work - if its wrong please let me know) My issue is the cell that this is linked to it doesnt format as a % until the next time the sheet recalculates (i.e. - enter a formula or do some other calculation in the sheet). Meaning the box show 6.000% the cell A1 which its linked to show .06 until the sheet calcs then it switches to 6.000%. Any idea why this is happening and how to correct ? ...

Not sure if this is possible
I am in charge of Payroll in my company, and at the end of the year have to compile a very large excel sheet showing what each employe made, for tax purposes. I have a digital copy of all the payroll o the computer, which is also excel sheets. My question is this: Is it possible to make a formula that will take the money that the made from the one document onto this new one? If so, how -- C_Purbaug ----------------------------------------------------------------------- C_Purbaugh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3519 View this thread: http://...