Answer Questions

• azpat0 cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. Everytime I click on your link for the hpfix, I get taken to hotmail Aloha all, Microsoft sent me this solution, try it and see if it helps. It has ...Show All

• JP.DEV 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

• blucas2006 Access 2003 Printer Settings

  I'm trying to set the printer, paper size and source tray via vba code. I can set the Printer using the following code Dim p As Printer For Each p In Application.Printers If (StrComp(sPrinter, p.DeviceName, vbTextCompare) = 0) Then Application.Printer = p SetPrinter = True Exit For End If Next p Though, when I set the PaperBin to anything, no matter which printer I have, it sets it to the first tray only. Should the command " ...Show All

• tuhack After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. yeah, I implement it and runs great for save excel file. Now, the problem is when the user want to Save As...how can i show the Save Dialog If not, I will try to do a form that ask for the file n ...Show All

• Howez Access 2003 - programming arrow keys with combo box

  On an Access form, I'd like the up/down arrow keys to be used to navigate the values in a combobox, similar to how a listbox behaves. So, for example, if there are five values starting with "M", the user could enter "M" and then press the down arrow key to get to the other entries. Since it's a combo box, the user could also just continue to enter text. I assume I need to program the keypress event to do this, but I'm not ...Show All

• Navin Joy Setting Chart Title through VBA sometimes works sometimes doesn't.

  Hello folks, Wonder if anyone has the solution to the following problem. Got an Excel addin that the user can use to generate Charts. The users are very lazy and want the addin to set the titles for the chart as well as for the axis. When I tested the code everything works fine and the charts including it's titles are set. Everyone is happy. However in certain spreadsheets the code throws an error. Method 'HasTitle' of object '_Chart ...Show All

• El Bruno .NEt and industrial automation

  Hi all, I want to get information or links to read about combination the .Net framework on the industrial automation. I mean SCADA and HMI or OPC in . Is there any classes or components that deals with these issus s there and open sourse tutorials of these systems Regards... You might find some useful information and code examples on using OPC and .NET on the OPC Programmers' Connection website. Check the li ...Show All

• Sanjay Garg Help with using Outlook from Access

  I am openning Outlook by calling createobject, which I expected to open a new instance of the application. However it appears to use the one open on my desktop. This means that my quit statement closes my e-mail. How should I amend the below to leave my original e-mail session open Also I will be replacing the debug.print statement with code to work with the attachment to copy data into my database. I am intending to save the file to a tempor ...Show All

• formhabit Sending Mail as a different user in outlook

  Hi, First off, apologies for any thickery in the post, I'm a Outlook VBA newbie and have been trying for a couple of hours to solve my problem, no luck so far. I need to send an email, but I need to send it as another user (we have a account which is used as a collection point for receiving and sending emails, lots of users can access it) I have tried using Namespace.Session.login and logging in as the user but when I try to send the mail it sti ...Show All

• KBaghaei VB6 XP Themes support. Solved! Source included...

  Hello! I received help from nice people here(hi brenda) so i'll release this small patch right here. I know it's not right place, but hey... Here is decription: This code will make any VB6 application XP Themes compatible. No code or forms change needed. All you have to do is copy this code to a module(let's call it mdlTheme.bas) and call one function in your's Sub Main() So, your code will look like this: Sub main() DoTheTrick end s ...Show All

• C# read-only OLEs ?

  Hello all ! I 'm database administrator and I 've a MSAccess db , which contains a tables with OLE objects (most of them are MSWord documents). I 've also some forms , that prevents they fields from changing (read-only forms). But when OLE object field is "executed" (Word document opens) , user can modify something. Then , when user closes form , he is getting an error with saving OLE object. Question: how to prevent OLE object from ...Show All

• Mike Mathis Microsoft Platform Test for ISV Solutions & FxCop

  Hi, the Microsoft Platform Test for ISV Solutions site ( https://partner.microsoft.com/global/40010438 ) states that to pass the managed code component "All Application Assemblies pass analysis by FxCop without errors or warnings" does this mean: 1) all assemblies must pass with the default FxCop rules (not even microsoft application blocks manage this) 2) the FxCop rules file used for the test must be supplied so any customisations can be seen ...Show All

• PhilipD After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. thank you very very much!! now, I try do it. I hope that works. thanks ;-) thanks * 100000...!!! you have save my life!!! hehe really thank you very much friend. Regards. ...Show All

• techie1111 Emailing sheet with Excel macro

  I have recorded a macro in Excel with a lot of filters in it. After filtering I want to send several sheet selections to different email addresses without having to create a new workbook for each selection. So, after I have made a selection, I want to send this selection via Outlook to a particular recipient from the macro. In total I will have 4 different selections to be send to 4 different recipients. 1. Is it possible to edit my mac ...Show All

• Parripati Using Built-In Constants in VB.net / Word

  I'm using vb.net to create a Word document (COM) and perform some simple operations on the docment , then close it. I have everything working except the use of built-in constants, such as wdFormatRTF. I keep getting compile errors cause they can't be found. Any help I've tried a sample out and couldn't replicate the problem, can you get this code to work. Dim x As New Microsoft.Office.Interop.Wor ...Show All