Interact with MS Access using VB

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - VS 2008
  - Visual Studio
  - SQL Server
  - VS Express
  - Visual C#
  - Windows Live
  - Architecture
  - Game
  - Office
  - Windows Forms
  - IE
  - VC++
  - VFP
  - Smart Device
  - VB
  - SharePoint
  - Windows Vista
  - ISV
  - Dotnet

- Previous
  - 1
    - Method to refresh/update Word toolbar state I found a workaround! Code Snippet if(commandBar.Visible == true) { commandBar.Visible = false; commandBar.Visible = true; } Thanks, Guy Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 2
    - How to Add custom information in an appointment item using VSTO SE Outlook 2003 Addin ? Hi, I am creating a VSTO SE Addin for Outlook 2003 and i want to store some custom information in the form of Key-Value pair in every appointment item i have. Can anybody tell me is this possible to achieve this Thanks in advance. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 3
    - Copying RTF into word and from word to a richtext box using c# Hi Steve Better to post a new question, with a link to any relevant, existing discussion. If you post to a message thread already marked as "Answered", there's a good chance no one will see it... You're more likely to get a discussion on your question, with possible recommendations for (third-party) transforms in the newsgroup interface. Technically, the office.xml newsgroup would be appropriate, and you should try there. But as that gets relatively little traffic, asking in one of the general office.developer newsgroups (see " Please Read First " at the top of this forum) would be a good idea, as well. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 4
    - connecting excel file to C++ program Hi every body I am a new programmer and I have been studying C++ for one semester. I know how to link and use files with these extinsions (.dat , . txt). However, I need to know how to connect excel spreadsheet with my C++ program "win 32 console application" and then I need to read my input from this spreadsheet and produce my output on it. I searched a lot but I did not find any thing. Actually, I do not know what is the solution for my problem, is it a code or a tool or something else If there is any one who can help me, I will be thankful. Moreover, If there is a refrence or a book that helps me ,please tell me and I will be glad to study it. I use MS Office 2003, Visual Studio 2005. Sorry if my question seems silly, but I really want to learn it and it is urgent. Thank you a lot . Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 5
    - Which "Event Handler-adding" code is more appropriate for my application add-in? I've been puzzled by something for a while...every time I go looking for good source to double-check that the CommandBar and buttons I'm adding to one of the Office apps, I seem to come across one or more variants of the two main approaches here. Approach 1 (VB): Private WithEvents uiButton As Microsoft.Office.Core.CommandBarButton Approach 2 (C#): uiButton.Click += new Microsoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(uiButton_Click); I can't tell if one of these is for application add-ins and the other for document-level add-ins, or if one is VSTO 2005 and the other is new to VSTO 2005 SE, or if one is for VSTO add-ins and the other for "Shared" Add-ins> Or something else. Q: Are these types of Event Handler adding-code entirely equivalent, or are there unique dependencies, constraints or pre-requisites for using one over another Q: When should I use one vs. the other (or can I interchange them) I have a current CommandBarButton that no longer works, and I have no idea why. At some point it was working in this app's code (probably previous to this version): http://www.codeplex.com/word2mediawikipp/SourceControl/FileView.aspx itemId=130408&changeSetId=13025 Now, it no longer fires - even despite the fact that (assuming Visual Studio isn't lying to me and this Solution hasn't magically converted from VSTO for Word to a Shared Add-in) I could swear I have all the right pieces in place (at least according to these forum archives). However, for whatever reason Visual Studio won't break on the Event, and it doesn't even trap a breakpoint that I've set on all pieces of the subroutine in which the developer has involved the buttons: Public Class ThisAddIn Private W2MWPPBar As Office.CommandBar Private WithEvents uiConvert As Office.CommandBarButton Structure CommandBarButtonSettings Friend BeginGroupProperty As Boolean Friend ButtonVariable As Office.CommandBarButton Friend CaptionProperty As String Friend DescriptionTextProperty As String Friend FaceIDProperty As Integer Friend StyleProperty As Office.MsoButtonStyle Friend Tag As String Friend TooltipTextProperty As String End Structure Private Sub ThisAddIn_Startup( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Startup Dim _Template As Word.Template For Each _Template In Me .Application.Templates If _Template.Name = "W2MWPPTemplate.dot" Then Me .Application.CustomizationContext = _Template End If If Me .Application.CustomizationContext Is Nothing Then _Template = Me .Application.AddIns.Add( "W2MWPPTemplate.dot" ) Me .Application.CustomizationContext = _Template End If Next AddCommandBar( True ) AddCommandBarButtons( True ) W2MWPPBar.Visible = True End Sub Private Sub AddCommandBar( ByVal replaceExisting As Boolean ) Dim _CommandBarsCollection As Office.CommandBars = DirectCast (Application.CommandBars, Office.CommandBars) Try If replaceExisting = True Then W2MWPPBar = _CommandBarsCollection.FindControl(Tag:=TOOLBAR_NAME) If W2MWPPBar IsNot Nothing Then W2MWPPBar.Delete() End If End If If _CommandBarsCollection.FindControl(Tag:=TOOLBAR_NAME) Is Nothing Then W2MWPPBar = _CommandBarsCollection.Add(TOOLBAR_NAME, _ Office.MsoBarPosition.msoBarTop, _ False , _ False ) Else W2MWPPBar = Application.CommandBars(TOOLBAR_NAME) End If Catch ex As System.ArgumentException MessageBox.Show( String .Format( "{0} add-in's toolbar could not be found - you won't be able to upload to the Wiki until you restart Word and/or reinstall the Add-in." , TOOLBAR_NAME) _ + vbCrLf + vbCrLf + String .Format( "Error: {0}" , ex.Message), _ TOOLBAR_NAME, _ MessageBoxButtons.OK, _ MessageBoxIcon.Error) Exit Sub End Try End Sub Private Sub AddCommandBarButtons( ByVal replaceExistingButtons As Boolean ) Dim buttonSettings As New CommandBarButtonSettings() Dim buttonsList As New ArrayList() buttonSettings.ButtonVariable = uiConvert buttonSettings.CaptionProperty = "Convert to Wiki" buttonSettings.DescriptionTextProperty = "Converts Word Documents to MediaWiki format." buttonSettings.FaceIDProperty = 2144 buttonSettings.StyleProperty = Office.MsoButtonStyle.msoButtonIconAndCaption buttonSettings.Tag = "W2MWPP Convert" buttonSettings.TooltipTextProperty = "Word2MediaWiki++ - Convert to MediaWiki syntax and upload formatted text" buttonsList.Add(buttonSettings) buttonSettings.ButtonVariable = uiUpload buttonSettings.CaptionProperty = "Upload Images" buttonSettings.DescriptionTextProperty = String .Empty buttonSettings.FaceIDProperty = 38 buttonSettings.StyleProperty = Office.MsoButtonStyle.msoButtonIconAndCaption buttonSettings.Tag = "W2MWPP Upload" buttonSettings.TooltipTextProperty = "Word2MediaWiki++ - Upload Images to wiki" buttonsList.Add(buttonSettings) buttonSettings.ButtonVariable = uiConfig buttonSettings.CaptionProperty = "Configure Word2MediaWiki++" buttonSettings.DescriptionTextProperty = String .Empty buttonSettings.FaceIDProperty = 277 buttonSettings.StyleProperty = Office.MsoButtonStyle.msoButtonIconAndCaption buttonSettings.Tag = "W2MWPP Config" buttonSettings.TooltipTextProperty = "Word2MediaWiki++ - Add-in Configuration" buttonsList.Add(buttonSettings) If replaceExistingButtons = True Then For Each _buttonSettings As CommandBarButtonSettings In buttonsList _buttonSettings.ButtonVariable = W2MWPPBar.FindControl(Tag:=_buttonSettings.Tag) If _buttonSettings.ButtonVariable IsNot Nothing Then _buttonSettings.ButtonVariable.Delete() End If Next End If For Each _ButtonSettings As CommandBarButtonSettings In buttonsList If W2MWPPBar.FindControl(Tag:=_ButtonSettings.Tag) Is Nothing Then buttonSettings.ButtonVariable = CType (W2MWPPBar.Controls.Add(1), _ Office.CommandBarButton) Else buttonSettings.ButtonVariable = W2MWPPBar.FindControl(Tag:=_ButtonSettings.Tag) End If Try With buttonSettings.ButtonVariable .Caption = _ButtonSettings.CaptionProperty .DescriptionText = _ButtonSettings.DescriptionTextProperty If .FaceId < 2 Then .FaceId = _ButtonSettings.FaceIDProperty End If .Style = _ButtonSettings.StyleProperty .Tag = _ButtonSettings.Tag .TooltipText = _ButtonSettings.TooltipTextProperty End With Catch ex As System.Runtime.InteropServices.COMException If ex.ErrorCode = -2147467259 Then MessageBox.Show( String .Format( "The {0} toolbar has misconfigured one of its buttons. Please restart Word, and if this error recurs, please file a bug at {1}." , TOOLBAR_NAME, CODEPLEX_SITE) _ + vbCrLf + vbCrLf + String .Format( "Error: {0}" , ex.Message), _ TOOLBAR_NAME, _ MessageBoxButtons.OK, _ MessageBoxIcon.Error) End If End Try Next End Sub Q: Any ideas, anyone And rumours, inferred details or pointers to good docs that you know of would be most appreciated. Cheers, Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 6
    - COM Exception Error Hello, I solved it. I read the deployment article that was recently posted and I didn't have the Primary Interop assemblies loaded, so I went to http://www.microsoft.com/downloads/details.aspx familyid=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&displaylang=en and ran this. Thanks, Steve Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 7
    - VSTO SE 2005 Runtime Setup for Windows VIsta HI, I want to install VSTO SE 2005 Runtime Setup for Windows VIsta. But on its download page, Windows vista is not listed in the supported OS. Is there a seperate runtime for Windows Vista Regards Kulvinder Singh Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 8
    - Publish deployment issue I'm getting an error message intermittantly when publishing my application Could not load file or assembly ..., Version=1.1.2692.18376, Culture=neutral, PublicKeyToken=...' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Fusion Log Data: Successful load- LOG: Assembly Name is: , Version=1.1.2692.18376, Culture=neutral, PublicKeyToken=205848d03db232df LOG: Binding succeeds. Returns assembly from C:\Documents and Settings\Admin\Local Settings\Application Data\assembly\dl3\3MDEK0QZ.57D\D1GG5QL9.GKL\67c4e139\00df0250_c797c701\.dll. LOG: Assembly is loaded in default load context. Unsuccessful load attempt: LOG: Assembly Name is: , Version=1.1.2690.28864, Culture=neutral, PublicKeyToken=205848d03db232df WRN: Comparing the assembly name resulted in the mismatch: Revision Number ERR: The assembly reference did not match the assembly definition found. ERR: Setup failed with hr = 0x80131040. ERR: Failed to complete setup of assembly (hr = 0x80131040). Probing terminated. I havn't been able to isolate under what conditions it happens and what conditions it doesn't, but I am attempting to do so. My thoughts are that it may be to do with potentially having recompiled the referenced project separately, yet when the publish function is run, it recompiles the project to be published but doesn't include the latest assembly for the referenced project. Not certain tho. Would greatly appreciate any input/insight into how to resolve the issue. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 9
    - Cache data in workbook created from addin How much data can you store in a custom document property Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 10
    - A question about office clipboard Hi, Geoff Darst, Thank you very much. Your answer is very helpful. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 11
    - how to implement "in-Ribbon" Gallery ? I have almost read http://blogs.msdn.com/jensenh/default.aspx messages all. But I don't know how to implement "in-Ribbon" Gallery (that's like home styles in word 2007 ) At "2007 Microsoft Office System UI Design Guidelines - Evaluation.doc",they said there were two styles about Gallery ,that's " dropdown " and " in- Ribbon ".Could you tell me how to set " in- Ribbon " Gallery with xml thank you Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 12
    - Excel Edit Delete Disabled Hi Nikhil... Unfortunately, one of my customers seems to be having this problem with the VSTO 2005 SE runtime installed. While I have successfully been able to "fix" the problem by deleting the Application Data\Microsoft\Excel\ Excel11.xlb file, I can not - as some other people have posted - use the code snippet you provided, as it will reset all toolbar customizations that my customer may have done (they are advanced Excel users and have many toolbar customizations). And forcing the customer to delete this file every time they use our VSTO solution is more than just an annoyance - it is a showstopper as they will not use our VSTO solution. Do you have any other suggestions on how to fix this issue Even with VSTO 2005 SE runtime installed Thanks, Joe. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 13
    - Publishing VSTO 2005 SE addin to a network location Hi Denis, Thanks for the response. This seems to be a feasible solution. Just a few doubts, do you mean that the new application will kill all the instances of the host office application and then copy the required dlls. Also, will replacing the local copy with contents of the publish location activate the latest version or will we have to make some changes in the registry settings as well Would be great if you can share some details of what you did in the application launched. Thanks and Regards, Rakesh Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 14
    - WordApp.Selection.Range.set_Style throws exception I think I found the solution: the string is culture specific, I had to use the corresponding word in Hungarian (my language) intstead of "Heading" and then the element has been found. Thanks for the hints. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 15
    - Excel Solver macro from VB.NET I am trying to use the Solver Add-In to solve a problem. I can run the Solver Add-In, but when I cannot use it. For example the sample usage of Solver Add-In in Excel is like this: SolverOk SetCell:="$B$1", MaxMinVal:=2, ValueOf:="0", ByChange:="$A$1:$A$3" But When I want to use the "Solverok" as a method like this: objExcel.SolverOk SetCell:="$B$1", MaxMinVal:=2, ValueOf:="0", ByChange:="$A$1:$A$3" The VB give the runtime error 438 "Object does not support the Method" What should I do Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 16
    - VSTO Addin crashing outlook on select machines I have created VSTO addin and have successfully deployed it to most machines in my office. The addin adds a command bar button to the standard tool bar. On select machines the addin crashes outlook on startup. I have the startup code enclosed in a try catch to handle possible errors but it seems I cannot handle this error. EventType clr20r3, P1 outlook.exe, P2 11.0.8010.0, P3 43d16d53, P4 system, P5 2.0.0.0, P6 4333ae87, P7 5a2, P8 0, P9 system.io.filenotfoundexception, P10 NIL. When I strip out all code besides a msgbox call in the application startup method, the addin starts up fine and displays the msgbox, but then when outlook is closed the addin crashes outlook in a simmilar fashion as when it crashes on startup. I have been unable to find any differences between the affected machines and other machines in the office. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
- Next
  - 1
    - execute a vsto project on a remote machine Hello, I would like to execute a .docx of a word document project on a remote machine. I've installed the .vsto file both on the server and on the client machine and I've given full trust to the folder that contains the vsto project : C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727/CasPol.exe -m -ag 1.2 -url file://server/MyWordDocProject/* FullTrust But it doesn't work... :-( What else can I do Thank you in advance for any advices. mathmax Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 2
    - Highlighting the active field in the task pane Hi Sandeep, No. Your objective cannot be achieved. If you make all other controls disabled, they will no longer be able to respond to your click event. As an alternative way to do that, you can just set other textBox��s BackColor to be a System Control Color (Just like to be disabled). Codes I write are as follows: Code Snippet private TextBox[] txtarray = null ; private string name = null ; private void ThisWorkbook_Startup( object sender, System.EventArgs e) { txtarray = new TextBox[5]; for ( int i = 0; i < 5; i++) { txtarray[i] = new TextBox(); txtarray[i].Name = "TextBox" + Convert.ToString(i+1); txtarray[i].Text = "TextBox" + Convert.ToString(i+1); txtarray[i].GotFocus += new EventHandler(textBox_GotFocus); } this .ActionsPane.Controls.AddRange(txtarray); textBox_GotFocus(txtarray[0], new EventArgs()); Globals.Sheet1.SelectionChange += new Microsoft.Office.Interop.Excel.DocEvents_SelectionChangeEventHandler(Sheet1_SelectionChange); } void Sheet1_SelectionChange(Microsoft.Office.Interop.Excel.Range Target) { foreach (TextBox txt in txtarray) { if (txt.Name == name) { int row = Convert.ToInt32(Target.Row); int col = Convert.ToInt32(Target.Column); Char column = Convert.ToChar(col % 26 + 64); txt.Text = column.ToString() + row.ToString(); } else { } } } void textBox_GotFocus( object sender, EventArgs e) { name = ((TextBox)sender).Name; foreach (TextBox txt in txtarray) { if (txt.Name == name) { txt.BackColor = System.Drawing.SystemColors.Window; } else { txt.BackColor = System.Drawing.SystemColors.Control; } } } Hope this helps J Thanks Ji Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 3
    - What about Macs? Hi, Is there any way to port my Office VSTO customization to Apple Mac platform I'm completely ignorant about macs, and now I am asked about it, and I need help. So, is there the equivalent MS Office 2003 for Mac which supports customizations and also whether there is .NET framework for Mac that can run VSTO assemblies Thanks Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 4
    - building outlook toolbar in contacts No, a toolbar added to the Explorer window appears on the main Outlook window. The Inspector holds all toolbars for individual item windows. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 5
    - Excel Automation: How to use an external link as an argument in a user-defined function? Using VSTO2005SE, I created an automation add-in that contains a user-defined function. For the sake of simplicity, let's assume the UDF takes a single cell address as its argument and then multiplies its value by 1000. Public Function MyFunc( ByVal Range As Object ) As Double Dim dblY As Double = CType (Range, Excel.Range).Value * 1000 Return dblY End Function When entered into a worksheet cell (e.g., A1: =MyFunc(B1) ), the UDF obediently takes the value in B1 and returns it, times 1000. The UDF also works fine if the value shown in B1 originates from an external link to another workbook. However, the UDF returns a #VALUE! error, if the external link is used as an argument within the function, while the other workbook is not open: =MyFunc('X:\[ExtLinkSource.xls]Tabelle1'!$A1) --> #VALUE! If the other workbook is open, the UDF throws no error: =MyFunc([ExtLinkSource.xls]Tabelle1!$A1) --> returns correct result Incidentally, this is also the standard behavior for some of Excel's built-in worksheet functions, such as OFFSET or INDIRECT - these are known to not work with external links, unless the other workbook is open, unlike SUM or INDEX. Does anybody know how a user-defined function can adopt the behavior of the SUM function and the like, i.e. retrieving a cell value from a closed external workbook I know that cell contents can be retrieved from a closed workbook using ADO.NET, but I'm looking for something not quite so clumsy. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 6
    - Docx to Clean HTML Hi, I am trying to use Word 2007 and export HTML of its contents and publish it to my content management system. Right now Exporting Word using the API's is leading to incorrect HTML - like all lists are converted to P tags etc. Is there a way to generate correct HTML from Word Thanks. Regards, Saurabh Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 7
    - Fuzzy text in a label control Art, OK but just to satify my curiosity would be possible for You to send me a screenshot of it during runtime Thanks in advance. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 8
    - Microsoft.Office.Tools.Excel Items and controls in Excel 2007 with VSTO SE Dennis, one more question about the ListObject. When you said: " I t's possible to create a ListObject, populate it with data and then disconnect the ListObject from the range (see http://xldennis.wordpress.com/2007/05/08/csv-files-listobject-controls-and-vsto/ )." you mean that it is possible to create a Microsoft.Office.Tools.Excel.ListObject The link you make reference talks about this vsto list object, created by using the Microsoft.Office.Tools.Excel.Worksheet.Controls.AddListObject method. But, since I don't have any Microsoft.Office.Tools.Excel.Worksheet in the VSTO SE Excel application-level add-in, how can I create a Microsoft.Office.Tools.Excel.ListObject On the other hand, if I use the Microsoft.Office.Interop.Excel.ListObject, to which I do have access, I lack of the data binding capabilities. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 9
    - Issue in Excel report generation Hi, We recently migrated to Excel 2002 from Excel 2000 and are facing a wierd problem in the excel report generation through our Java code -- Using MIME type Excel. The issue is while generating the report after certain number of rows the values in the cells loses its numeric characteristics even though same code is used repetetively to display the all the rows. The data is absolutely fine and is working fine in Excel 2000. So it would be great if any one can help me to give an insight into what is causing this problem. Thanks in advance, Raghu Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 10
    - Event Handlers and UDFs in the automation add-ins Hi, Great ..thanks to this site for helping. I have an issue and have followed the following approach to create automation add-in. http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx . and created following code using System; using System.Runtime.InteropServices; using Microsoft.Win32; using System.Text; using Microsoft.Office.Interop.Excel; using Excel = Microsoft.Office.Interop.Excel; using System.Reflection; using System.Diagnostics; namespace lnzv2 { [ClassInterface(ClassInterfaceType.AutoDual)] public class wsf { Excel.DocEvents_ChangeEventHandler EventDel_CellsChange; Excel.Application xlApp; Excel.Workbook xlBook; Excel.Worksheet xlSheet1, xlSheet2, xlSheet3; public wsf() { myInitialization(); } public void myInitialization() { xlApp = new Excel.Application(); xlBook = xlApp.Workbooks.Add(Missing.Value); xlBook.Windows.get_Item(1).Caption = "XL Event Test"; xlSheet1 = (Excel.Worksheet)xlBook.Worksheets.get_Item(1); xlSheet2 = (Excel.Worksheet)xlBook.Worksheets.get_Item(2); xlSheet3 = (Excel.Worksheet)xlBook.Worksheets.get_Item(3); xlSheet2.Activate(); EventDel_CellsChange = new Excel.DocEvents_ChangeEventHandler( CellsChange); xlSheet1.Change += EventDel_CellsChange; // ........question1 } private void CellsChange(Excel.Range Target ) { Target.Value2=10;; } public int NumberOfCells(object Range) { int [,] TheValues = new int[1, 1]; TheValues[0, 0] = 1; TheValues[0, 1] = 2; TheValues[1, 0] = 3; TheValues[1, 1] = 4; Excel.Range r = Range as Excel.Range; r.set_Value(Missing.Value,TheValues);//......question2 return r.Cells.Count; } } } Given question1 I am unable to invoke the event.So please give me an idea how the event can be used and correct me if i am wrong. In question2 I am unable to get the value in the cells of the given range passes in the function and it gives an error in the cell where i have written the UDF =NumberOfCells(b2:c3). Please give a heling hand. thanks. Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 11
    - Range.get_Information() always throws an exception Just to provide an additional data point, I confirm Helmut's results. No errors here. No idea what could be wrong, although since VB.NET can do it, it almost seems like a problem with the PIAs. How about if you use late-binding (PInvoke), does that work for you in C# (it should if VB.NET does) Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 12
    - DllUnregisterServer issue; err code 0x80070005 i have a proj for creating an activex control. i have converted the vc6 proj to vc7 proj. now on building the activex control using vc7 proj i am not able to unregister the ocx using regsvr32. the return code is 0x80070005. if the same ocx is built using vc6 proj then everything works fine. didnt find anything special when comparing the vc6 and vc7 proj settings. the err code 0x80070005 suggests some permission issues. i tried checking the permissions for the users using regedit. the user had all permissions. please help. waiting for reply. Thanks, Chanakya Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 13
    - OCS 2007 Forums Still Down As reported last week, the OCS 2007 forums are down and still down. Any idea when these forums will be back up And please - can we get NNTP access to the forums Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 14
    - Catching email being sent using RibbonX control Sorry Helmut, I'm not sure this is working exactly as I'd hoped. I've finally managed to implement a sink for new mail sent, but my declaration ended up simply as... void __stdcall CConnect: nSend() ...so from that how can I get the inspector for the message Most of the code I've used has come from http://www.codeproject.com/useritems/Capture_Outlook_event_vc6.asp although because I'm developing in VS2005 things turned out very slightly different. Also the CConnect object seems to be reused so the member variables are global between messages. Thus once a user clicks the button and I set a variable in CConnect to process the messages as they are sent then all subsequant messages will be processed. So I have two problems, firstly can I simply change my OnSend declaration somehow to include the inspector, or is there some other way of getting it And secondly is there way to save inspector specific variables so only the messages nominated are processed on send Edit: In fact, I've just worked out that if I use the OLE/COM object viewer on the .olb file I've imported for the Outlook namespace, I can see some more information. I see that probably ApplicationEvents is the only interface I can use, and I see the various events (ItemSend, NewMail, Reminder etc with their various dispids.). I also see that the callback should be: void ItemSend( IDispatch *Item, VARIANT_BOOL *cancel ) So I changed my send function declaration to _ATL_FUNC_INFO OnSendInfo = { CC_STDCALL, VT_EMPTY, 2, {VT_DISPATCH,VT_BYREF | VT_BOOL} }; But now I just can't work out what the Item pointer is. If I QI for the Inspector on it then that fails with 0x80004002, and it doesn't seem to be the MailItem either because if I try to use it it just crashes. Thanks Jamie Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 15
    - Adding a context menu item for a chart in Excel? Hi, The following test with VB.NET for a VSTO 2005 SE project works as expected with Excel 2003. Hopefully You can take it from here to a working solution. Public Class ThisAddIn Private ObjectPlot As Office.CommandBar Private btn As Office.CommandBarButton Private btnTag As String = "Chart" Private WithEvents obtn As Office.CommandBarButton Private Sub ThisAddIn_Startup( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Startup Me .Application = CType (Microsoft.Office.Tools.Excel.ExcelLocale1033Proxy.Wrap( GetType (Excel.Application), Me .Application), Excel.Application) Add_Button() End Sub Private Sub ThisAddIn_Shutdown( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Shutdown End Sub Private Sub Add_Button() ObjectPlot = Me .Application.CommandBars( "Object/Plot" ) btn = ObjectPlot.Controls.Add( _ Office.MsoControlType.msoControlButton, _ Temporary:= True ) With Btn .Style = Office.MsoButtonStyle.msoButtonCaption .Caption = "My Item" .Tag = btnTag End With obtn = btn End Sub Private Sub obtn_Click( ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean ) Handles obtn.Click MsgBox( "I'm activated" ) End Sub End Class Tag: Visual Studio Tools for Office Interact with MS Access using VB Office
  - 16
    - How to deploy a VSTO project. Hi, How do you add these buttons They appear like this in IDE or on client machine Strange, I haven��t met such issue before. But I remember that I read something in MSDN about buttons on document appear weirdly! I research the link and find it: Controls Appear as Black Rectangles on the Document or Worksheet If you group controls on a document or worksheet, Visual Studio Tools for Office no longer recognizes the controls. Grouped controls cannot be accessed in the Properties window and they appear as black rectangles on the document or worksheet. You must ungroup the controls in order to restore their functionality. Controls on a Word Template are Not Visible in Visual Studio. If you open a Word template in the Visual Studio designer, controls on the template that are not in line with text might not be visible. This is because Visual Studio opens Word templates in Normal view. To view the controls, click the View menu, point to Microsoft Office Word View and then click Print Layout. Original link locates: http://msdn2.microsoft.com/en-us/library/h8c469ey(VS.80).aspx Is your scenario similar with above description Thanks Ji Tag: Visual Studio Tools for Office Interact with MS Access using VB Office

RMS81

Hi,

Is there anyway to use the database utilities provided by Access, like "Compact and Repair" using VB

Tks

Top

Re: Visual Studio Tools for Office Interact with MS Access using VB

Daniel Molina - MSFT

Hi RMS81,

Access is not a platform currently supported by VSTO. I would suggest asking the question in the one of the access discussion lists here:

http://msdn.microsoft.com/newsgroups/topic.aspx url=/msdn-files/028/201/016/topic.xml

Now, a quick search in MSDN reveals that Access provides the Application.CompactRepair method that might fit your needs, just recall that you cannot repair a database that is currently open.

http://msdn2.microsoft.com/en-us/library/aa221162(office.11).aspx

Top

Re: Visual Studio Tools for Office Interact with MS Access using VB

RMS81

Ok.

Thanks for your help.

Top