Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Certification Visual Studio > Add/Update a Re...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 681 of 795
Post > Topic >>

Add/Update a Record in VB

by Donald Fisher <dsfcom@[EMAIL PROTECTED] > Aug 25, 2007 at 07:23 PM

I have an Access database as a data source and would like to add a 
record using the following code:

         Dim ol002 As New Microsoft.Office.Interop.Outlook.Application
         Dim olns002 As Microsoft.Office.Interop.Outlook.NameSpace
         Dim strENTRYID, strSTOREID, strFOLDER, strSECTION
         olns002 = ol002.GetNamespace("MAPI")
         Dim fldFolder As Microsoft.Office.Interop.Outlook.MAPIFolder
         fldFolder = ol002.GetNamespace("MAPI").PickFolder
         strENTRYID = fldFolder.EntryID
         strSTOREID = fldFolder.StoreID
         strSECTION = InputBox("Enter the section name as you would like 
it to be displayed in the schedule [ALL CAPS]." & Chr(13) & Chr(13) & _
             "Ensure this is the same name for a section already 
loaded.", " Enter Section -")
         strFOLDER = InputBox("Enter the exact name of the folder on 
your public share for this section [ALL CAPS].", " Enter Share Name -")
 
Me._Outlook_Task_Re****ting_Tool_1_0_2003DataSet.tblSections.AddtblSectionsRow(strSECTION,

strFOLDER, strENTRYID, strSTOREID).AcceptChanges()
         MsgBox("The following data has been added to 'tblSections':" & 
Chr(13) & Chr(13) & "SECTION: " & strSECTION & Chr(13) & Chr(13) & 
"SHARE: " & _
         strFOLDER & Chr(13) & Chr(13) & "ENTRYID: " & strENTRYID & 
Chr(13) & Chr(13) & "STOREID: " & strSTOREID, MsgBoxStyle.OkOnly, " Add 
Complete -")


Why doesn't it work?  I get no errors but the backend table is not 
updated for some reason.
 




 5 Posts in Topic:
Add/Update a Record in VB
Donald Fisher <dsfcom@  2007-08-25 19:23:27 
Re: Add/Update a Record in VB
"Scott M." <  2007-08-26 13:03:02 
Re: Add/Update a Record in VB
Donald Fisher <dsfcom@  2007-08-29 18:01:08 
Re: Add/Update a Record in VB
"Scott M." <  2007-09-01 12:24:33 
Re: Add/Update a Record in VB
"Scott M." <  2007-09-01 12:44:45 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 11:04:03 CST 2008.