Only Title

Answer Questions

• Denny B Getting New Textbox value without using Afterupdate

  Hi. I'm fairly new with programming and I hope someone can help me with this. I trying to filter a list based on the value entered on a textbox but the only way I know of getting the new textbox value is wait for the AfterUpdate event. This works fine but I need to activate the filtering routine as the user types in the new value. Im thinking of using keypres, can anyone show me a way doing this. Any help would be appreciated. Thanks ...Show All

• MoGram Can anyone download VS Team Edition?

  We are a Certified Partner with the ISV Competency. The ISV Competency gives us a license for Visual Studio 2005 Team Edition for Developers but, we can't download that or the Team Server from MSDN. We can download the evaluation editions but not the real thing. Is this a problem for all partners with the ISV Competency or just us Can anyone download the real editions of Team Foundation server and/or VS for Developers Thanks, John Vot ...Show All

• Gregory Block Custom button on control bar

  I have a custom contorl bar button and it is connected to an addin. When my addin is first loaded the button is first displayed in the middle of the screen. I then need to drag it to the control bar. Is there any way I can code it so that it goes straight to the control bar and not in the middle Note: I have also asked this question at http://www.ozgrid.com/forum/showthread.php t=51966 Thank you ...Show All

• Paul Cheung Automatic BCC from Outlook (VBA)

  Hello, I am trying to create a subroutine in outlook to send an automatic BCC to a certain 'mail recipient (a@b.c)' if the subject contains 'xyz'. I have managed to create a subroutine which applys to EVERY mail i send. I want to set it for certain 'subjects' rather if subject contains 'xyz. What do i have to add Please help or guide me to resources. I need to know a subject field which i could compare strings with, i guess. -------------------- ...Show All

• AAV xp style to vba forms

  hi, i would like to apply the xp theme to my msforms in (excel) vba.  i have not been able to find any information on doing this.  i saw this done in a stand alone xla so i know it works.  any help would be greatly appreciated. -b Hi, thanks for the response.  Only the title bar and border itself seem to be drawn in the XP theme.  All of the controls I place on the userform are st ...Show All

• Black Bits Neeraj Missing record

  Hello, I have given the code for the function i am using to compare two tables and update one of them.. Sub DeptCheck_New() Dim dbs As DAO.Database Dim rst_pplops As DAO.Recordset Dim rst_local As DAO.Recordset Dim CurrentLevel As Integer Dim CurrentDeptId As String Dim LevelUp1 As String Dim LevelUp2 As String Dim tbl As DAO.TableDef Set dbs = CurrentDb dbs.TableDefs.Delete ("ups") dbs.QueryDefs(&qu ...Show All

• Diligent Bound form

  I am trying to fully understand how bound forms work (VBA in Access XP) I have a form bound to a query, but I need to "redefine" the query at execution time so I use set mrst=dbs.openrecordset( ....whatever SQL clause ....) ' module variable set me.recordset=mrst me.requery It seems to work up to here..... But,,... the Form Before Update and AfterUpdate events never fire (they used to fire until to yesterday!!). The Form_BeforeUpdate event w ...Show All

• Alan Cameron Wills -MSFT excel vba

  Dim rng As Range Dim rngSelect As Range Set rngSelect = Selection For Each rng In rngSelect.Rows Selection.Offset(2, 0) = rng.EntireRow.Select 'need to add each modified range to selection Next rng I want all modified ranges to be selected in code Hello MarcuslCox OK try and figure this out, and see if you can use it for your needs: Sub OnlyHighlighedRange() Dim rRangeToWork As Range '/This is the ...Show All

• sidthesloth print out to .pdf or calling a macro with parameter

  Hi, I created an .hta application that generates XML from Excel Sheets and the reverse, the thing is that when I do the reverse, generate Excel Sheets from XML files, i need to print that sheet to pdf. I try creating a macro that receives as a parameter the name of the final pdf file like this: Sub print2pdf(filename) ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, PrToFileName:=filename End Sub and then i call the macro in ...Show All

• dick giles Subform Problem

  hi all i have a problem that i tried my best to solve it but i can 't till now the problem is i have a form with 2 sub forms in side it built using MS access 2000 currently we moved the database from MS access to MS Sql Server 2000 since then this form no longer works the form idea is that user select the customer id from combo box after update event will do requery for both subforms both sub forms based in a query th ...Show All

• Lucrecio Menezes 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. Per our support engineer: Thanks for using ISV Community Forum. According to your problem, I’m wondering whether you are saving the Word document manual ...Show All

• jonnyO Application Hosted Scripting IDE in .NET 2 ?

  Hi Whats the direction for providing an application that enables hosted scripting and bebugging of the script etc. Is there an integrated commercial grade (or close) VBA replacement in managed code that supports debug, breakpoints single step etc, and can use VB.NET or C# as the language. Does anyone know of a simple control that would be close Andy Per one of our support engineers... I have done some intensive research on following iss ...Show All

• citifortune concepts Please, How change a class name in VBA Excel 2003

  help me Is this what you mean Select the class module in the project explorer pane of theVB editor, and in the properties pane (press F4 if it's not visible), select and edit the Name property. Keep in mind that now you have to change every reference to this class in your code. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ...Show All

• Joshua Morgan 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

• ZainabK BSM with SSRS(2005) on a different box

  Could anybody help provide some information about installing BSM with SSRS 2005 My installation needs to have SSRS running on a different box than the BSM server. There are 2 issues involved here: The BSM Server.msi by default looks for Reporting Services 2000. But I need to have the complete installation based on SQ ...Show All