Answer Questions

• fumble Form Show Problem

  Hi for all I have the following problem !! I have Form1,Form2 and Form3 I want to show Form3 from Form2 in a manner that allowing me to : Enable to Access Form1 But Restrict Access to Form2 So, Please any help If any one have VB.NET 2.0 Code sample please providing me with it Thanks to all Mahmoud Our support engineer provided a sample application for you. Please contact me at budsup@microsoft.com so that I can ...Show All

• robbrianius VB & VBA - page setup options completely disappear after merging a document

  Hello, I created a VB application which uses Word to merge documents. I used Microsoft office 97 to create these Merge Documents. With These merge documents, I was able to save the setting such as font and how it should print using tray 2 & tray 3. We have upgraded our Microsoft office to 2000. This is where the problem begins...now every time we use the VB application to do the merge---everything seems to work just fine until we ...Show All

• Bob Schmidt vba5.0 doesn't work on dual core computer with Windows2003 system

  We have tested at Dell dual core computer(PRECISION 670 and OPTIPLEX 620). If we uses Windows XP, it works well. But it doesn't work at Windows2003, even can't work when disable one CPU and disable Hyper-threading. The VBA initialization succeed, but the application crashs at call CallMacro function. I don't know what's the matter with it. Update to VBA6.X seems not easy and also not sure if it can work. H ...Show All

• J-BRIM VBA: Timer event?

  Hi, Cutting straight to the chase: How can I implement a polling mechanism in VBA The context: I'm using the xmlHttp component to call an xml web service from an XLA (Excel Add-in) written in VBA. Some of the calls are computationally intensive and take a while to complete, during which time Excel seems to "hang" resulting in an unpleasant user experience. I'd like to change things and use an async approach instead. Luckily, I control t ...Show All

• Saamy Vb migration to Access 2003

  Can someone help to convert the following VB so taht it is usable in Access 2003 Thanks. Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Layers() As String = { "100" , "100" , "100" , "120" , _ "120" , "140" , "140" , "180" , "180" ...Show All

• Kevin Shan Standalone aplication

  I am beginner to this VBA scripting. I ussed to make small code in C++ and comile to it get the excuatable file that ran good without opening any specfic compiler/application like excel where there needs to be some worksheet opened. Now I want to create a simple project/application that run some of the macros that I have recorded in Microsoft Excel. Is there any way that I can run the macros using sum .exe file that opens up some form where I ca ...Show All

• Tommy Campbell - MSFT* extract office file's title into excel

  hi guys! I have a folder which included many office excel and word files. these files have a file properties as "QMS-DOCUMENT-NO", which is created by myself when I create the file. New file will be add into this folder frequently. two questions: 1. I want to creat a excel file consolides what i have in this folder. it shall shows the file "name", "Title", and "QMS-DOCUMENT-NO". is there an automa ...Show All

• Sushil Chordia Windows media files have changes to Nero

  Hi just wondering how I change my music files back to windows media player, they changed to nero flies last week after burning a CD. Hate the nero player, but love windows media player. Hope someone can help me Thanks Shihad P.S check out Shihad single    ALIVE   Hi Rich, Here's another suggestion from our internal WMP alias: Well, WMP's Tools:Options:File Types is your first stop. Then Explorer's Tools: ...Show All

• KeithM86 For Each & Variable Problem

  Hello Chiefs, At first, my English isn't very well so maybe it would look a bit curios what I write ;) I have a Problem, I write a little Programm with VBA. Programm Users can type there Information about them (Name, Telephone Number...) and the Informations would saved in a XML File. Now, the Informations who are between the XML Element Nodes (<ELEMENT>...</ELEMENT>) must be loaded in Textboxes from the Programm, before th ...Show All

• WISDOM Date validation on a form

  On a form that's bound to a table, I'd like to override the standard Access date validation message ("The value you entered isn't valid for this field."). I've coded the Before Update event: Private Sub EventStartDate_BeforeUpdate(Cancel As Integer) If Not IsDate(Me.EventStartDate) Then MsgBox "Invalid date.", vbOKOnly, gstrAppTitle Me.EventStartDate.Undo Cancel = True End If End Sub However, when I t ...Show All

• ctimko Excel macro question - ref: sheets (hopefully a simple one!)

  Trying to debug a macro in Excel and it has an odd line. Could someone explain it to me please. "Sheets("comparative_report.pl reportNam").Select As you can't have a question mark in the name of a sheet - what's this all about Sorry if I'm being a bit thick but this is new to me. Thanks Damian It doesn't execute ok for me either. I am told that this used to work with Office 2000 ...Show All

• Taha macro that hides rows - excel

  hi, i was wondering if there was a way to write a macro that will automatically hide a row based on a value in a cell in excel say, if the sum of a selection of cells = 0, i want to hide the row all together. is there a way to do that thanks. anthony I seem to be having a problem. Every time it comes to a value that isn't "a", the loop ends. Basically that other value is a "b". I need this ...Show All

• Ebola project email updates set to not automatic

  Does anyone know how to turn off the email without turning off the ability to request status updates I don't want an email sent out every time I update something on a task to a resource. I would like to be able to control when an email gets sent to someone. Thanks! Per our support engineer: Thanks for using Microsoft ISV Community Forum. As you may know, Project Server leverages the alert functional ...Show All

• kwilk Can I unProtect a document?

  My VB code protects a Word object without setting a password, like this: Call Document.Protect(2)  Is it possible to Unprotect this document If so, how  (Did I post this in the right forum ). Thanks in advance for help. -Jeff Use the uprotect method of the document If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument. Unprotect Password:=strPassword End If ...Show All

• SurreDeth Edit Data in Access

  Hi, I currently have a MS Access 2002 database, and it has a table with the fields "Part", "Quantity", "Date", and "Comments". Thie "Part", "Quantity" and "Date" data are extracted on a weekly basis from another MRP database. However, I have to manually copy the "Comments" data over because it is not part of the MRP database. I wrote some simple queries to see ...Show All