Answer Questions

• mparter Execute an access DB macro from VB.NET

  Hi, I am having problems trying to execute an access DB macro from my VB.NET APP. Any help is welcome. Thanks Mike Hi, Thanks for the code. I have it working now. The only part that I could not get to work was the "CloseCurrentDatabase"; however, the quite command worked great. Thanks Again Mike Mike, One way this can be done is to include the reference to Microsoft Access obje ...Show All

• mr pitiful New to VB

  I have to do a project in VB Excel. I don't write code and it has been over 10 years since I took any programming classes. I have books on VB but I don't know where to start. I need to have our main invoice spredsheet update automatically when we get new invoices at the end of the month from our printing service. I know what I want to do but not how to code it. I would appreciate any advice. Thanks, Melissa ...Show All

• angelasw Put E-mail In From Field

  Dear All, Please Help me , I need a VBA code to Put certain E-mail in From field before sending any E-mail Automatically Dawy You can use the "SendOnBehalveOfName" property: Sub MailMe() Dim outApp As Outlook.Application Dim outMail As Outlook.MailItem Set outApp = CreateObject("outlook.Application") Set outMail = outApp.CreateItem(olMailItem) outMail.SentOnBehalfOfNa ...Show All

• Shreyas Patel Programming with MULTIPAGE

  Hi. I added controls in the multipage like text box, combo box and calendar button. The problem is there's no event for each control inside a multipage. I can put values in the combo box, I want to place values into another combo box based from his choices of the previous combo box. I hope you could help me on this. Thanks! Hi, The events of the controls held in the mutipage are still usable. If you double ...Show All

• Sk75 Need recommendation on Office/VBA/.NET/C# solution (cross-posting from the VSTO Forum)

  ****** The reason that I am cross-posting this from the VSTO froum is to reach the widest expert base. Thanks. ****** We want to move logic currently in Word XP VBA to C# component(s). What the VBA code basically does is calling Web Services that are implemented in Java, and display the returned data in Word documents. Our requirements are: improved performance easiness to install the components on end-user's PC's ability to be shared the ...Show All

• gkustas How long this forum exists?

  Hi everyone, My company is trying to integrate VBA into our application. I had some contacts with Summit software ( Microsoft's partner for VBA licensing) some years (2-3) ago. Because we didn't finish our application yet and we're still in process of developing and testing we didn't purchase a license of VBA, but we're going to do it as soon as we finish. The person from Summit software who had contact with me, sent me VBA 6.2 SDK. But I know ...Show All

• pkdenver BSC manager - Error connecting to server

  I've installed BSC manager 2005 following these steps: 1. Created a Virtual PC with 512 MB RAM 2. Installed Windows Server 2003 entreprise edition 3. Installed Windows Server 2003 SP1 4. Installed Sharepoint Services 2003 5. Installed Sharepoint Services 2003 SP2 6. Created a site and extended (Port: 46786) 7. Installed SQL 2005 developer edition 8. Configured SPS to use SQL instance 9. Installed BSC manager (server an ...Show All

• lthomasny won't recognize DisplayControl Property

  The below is from another forum, where I have posted my question - and from the answer I got I assume that I cannot do what I want to do in Acces 2003, does anyone have an alternative solution _____________________ I am trying to change the property DisplayControl for a field in a table, but keep getting " runtime error 3207 - property not known" when running the code . Can anyone identify where I go wrong I have no problems crea ...Show All

• borix69 Run-time error 3706:

  We have front end application which is developed in PB and resides on Citrix server. One of the module in PB application opens a screen which is developed in VBA. When we upgraded the citrix server and Ms Office on the server to higher version, the module which is developed in VBA is not working and gives the following error.   Run time error – 3706: Provider cannot be found it may not be properly installed.   Here is ...Show All

• TimirP ms access counting specific values on a subform for display

  Hi all I was wondering how can I count a if a value in the field DisabledUser is "Yes" or "No". Until now i have been using the following to count all records in the subform but i also need to count specific values to display them. Do Until Forms!frmVolumes!frmGroupToVol.Form.RecordsetClone.EOF Forms!frmVolumes!frmGroupToVol.Form.RecordsetClone.MoveNext Loop myint5 = Forms!frmVolumes!frmGroupToVol.Form ...Show All

• leighs Accessing control textbox text

  Hi, I am trying to access text typed in a control textbox during a powerpoint presentation. I first have the following code to check if any of the boxes have been left blank: For Each SomeShape In ActivePresentation.Slides(17).Shapes If SomeShape.Type = msoOLEControlObject Then If SomeShape.OLEFormat.Object.Text = "" Then BlankFound = True End If End If Next Tbox I get a run time error on the third line. Object ...Show All

• Daggs Can I get Micorsoft.RuleEngine.dll ?

  Hi Ihave a question on Microsoft.RuleEngine.dll used in Biztalk server 2004 core: Can developer buy a stand-alone licence of Microsoft.RuleEngine.dll (without the development FrameWork :Deployment wizard, Business rule Composer,.. ) thank you ;) Per our support engineer: Base on my understanding, our buddy wants to buy BizTalk rule engine instead of whole BizTalk package. We may as ...Show All

• nCognito vb in excel - on data modified?

  Hello. This is my first time here and I'm totaly not sure if I post this question in the right place (or even if this forums have a place for it) but I didn't found anything that sounds more apropriate so here goes. I'm trying to capture the event when someone modify a cell data in an excel worksheet. I managed so far to patch the following "macros": per the support engineer: ...Show All

• AQQWER Icons In ListBox

  Hi dears I want to add icon to the items of VB.NET 2005 ListBox , Could i do ... Hi Derek Smyth Tnnx for your replay, thinking in listview is better. I just added an imageList and a listView, and set the "small imagelist property " of the listView with the imageList i added then. set the "View property" of the listView with "smallicons" and then choose an image icon for every item of the listV ...Show All

• storras transaction processing in an Access app?

  In an Access app, is there the concept of a transaction, with "start transaction", "commit", and "rollback" If so, how do I implement it in VBA My app will have a main form withfour subforms on it. It will also have a Save button and a Cancel button. I would like to start the transaction when the main form is loaded, and commit only when the user clicks the Save button. The Cancel button would trigger a rollback. ...Show All