Microsoft ISV

Page 137




  • Topics
    Replies
    Last post
  • Access forms - record change event
    by ADG
    1 Replies
    Last post by ADG
      • Hi all I have an Access form which allows entry / editing of product specifications. There are approximately 5 different types of specification. I want to capture an event when the record on the form changes so that only the relevant fields are displayed. I am struggling to find the right event on my form. Any ideas
  • Reference to a String
    by James Strater
    1 Replies
    Last post by Adamus Turner
      • Excel 2003 VBA: I have a class module that needs to refer to a global variable, but I don't want to force every project that uses the class to declare such a variable - the functionality here is optional, yet I need the variable to persist. I also don't want to force projects that use this class to globally declare instances of this class, there are already quite a few projects that use the class
  • LBound and UBound functions
    by Keithyboy1
    7 Replies
    Last post by Shlizar Axis
      • Is there a reference library I need to enable in the VBE to get LBound and UBound functions They don't appear to exist in the Object Browser with the current reference libraries I have enabled. Many thanks!
  • Convert Excel sheet to PDF using VB macro in Excel
    by JamelB
    1 Replies
    Last post by Bruno Yu - MSFT
      • I am a beginner programmer trying to write a code to convert an excel sheet to a pdf file. I want to include this in an excel macro. HELP please!!!
  • Problem: Macro not deleting columns I select
    by Donaghy
    6 Replies
    Last post by Donaghy
      • Hi all, I have a section of code in my macro which tells it to delete a selection of columns: Columns("C:F").Select Selection.Delete Shift:=xlToLeft this is the first bit of code in my macro but isn't working correctly. Instead of deleting columns C to F its deleting columns A to H. Any ideas why this could be happening
  • Protecting formulas in cells
    by chrstdvd
    6 Replies
    Last post by js06
      • Hello, Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten Thanks Chrstdvd
  • Checking the status of autofilter
    by pps!
    1 Replies
    Last post by ADG
      • I have an excel report on which i have to write the program for making formatting changes in that. But before that i want to check the autofilter (Selection.AutoFilter) status (whether on or off). I want to check this in the midde of my code.. code . . if autofilter is ON xyz if autofilter OFF Make it on . . How to do this
  • vlookup for a range of cells
    by vranjit138
    4 Replies
    Last post by vranjit138
      • Hi In Sheet 1 i have columns (A,b,c,d) "Names", "Marks", "Age" and "Location" i have thrity rows of data for these columns in sheet 2 i have one column showing the names (thirty rows) - Column A . i would like to populate in column B the data relating to "marks" or "age". The column reference in the vlookup formula should be
  • Accessing a subform, error 2455
    by storras
    4 Replies
    Last post by Andreas H
      • I am trying to access the fields in a (bound) subform that exists in a tab control, inside a form dim ctl as control set ctl=me.controls("subformName") dim frm as form set frm=ctl.form.... here a crash happens at run time, with error 2455 (invalide reference to a Form/Report property) I am stuck in this subject, and I have been doing that many times, with no problem May I get some advice on how to
  • Using arrows to select in drop down list in access
    by RhysDavies
    4 Replies
    Last post by RhysDavies
      • Hi - anyone know how to get a drop down list combo box to allow you to select an option using the up/down arrows on the keyboard in access rather than having to click on the down arrow on the combo box in access - user wants to do it by tabbing into boxes and using the arrows to select because its quicker. thanks, Rhys.
  • activate a sheet containing a specific chrtobject
    by JS
    2 Replies
    Last post by JS
      • Hi all, I have a macro that lets the usr mark a chart that the usr wants to add serie(s) to. After the usr has picked the data for the new serie I want the macro to return to the sheet that contains the pre selected chart. How can I get this sheet with the information set in the beginning (ACh) Dim ACh as Object ''' Can be Embeded or chart sheet Set ACh = Nothing Set ACh =
  • Overflow (error 6)
    by une
    5 Replies
    Last post by Keithyboy1
      • I have code that executes fine 99% of the time. The other 1% I get an overflow error (error 6) that relates to the following line; startTime = Year(Now) * 365 * 24 * 3600 + Day(Now) * 24 * 3600 + Hour(Now) * 3600 + _ Minute(Now) * 60 + Second(Now) startTime is declared as a double; Dim startTime As Double The value of startTime at this line (according to debugger
  • Adding Outlook signature using OLE automation.
    by jpas
    5 Replies
    Last post by jpas
      • Is it possible to add a signature to an Outlook message using OLE automation Outlook is configured to automatically add a signature to outgoing e-mails. If I don't try to set objMailItem.HTMLBody to any value after creating the Mail Item object, the signature is in the e-mail as expected. If the HTMLBody is set to a value, the signature is lost. Trying to pre-pend the application data to t
  • Once copied, can we export as a GIF file?
    by Perry Choy
    14 Replies
    Last post by duck thing
      • How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much    
  • help required related LCS(Live Communication Server).
    by kultuze
    1 Replies
    Last post by MS ISV Buddy Team
      • i wanted to make a client that will get the status/username of the user from the LCS and initiate a collaboration chat session between the LCS users and between my client application.........is it possible our nt .
  • this problem is also troubling me now!! :(
    by Moim Hossain
    14 Replies
    Last post by WebDev2000
      • Hello everybody, I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int
  • Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
    by remitdlo1944
    5 Replies
    Last post by bbenz3
      • I was working on another problem and reset my advanced options. After all my jpeg and gifs now are fuzzy when displaying in only internet explorer 7.0.5730.11 all other programs display normal.
  • WMI.Net 2.0
    by GUYO
    11 Replies
    Last post by Gabriel GHIZILA
      • The next manged code library for WMI was discussed at TechEd this year and has popped up in a couple of webCasts. -- The WMI.Net 2.0 is supposed to provide writeable properties and invokable methods from managed code. Is there an update on the release Beta program etc... --
  • Word document
    by Ravi@asp.net
    0 Replies
    Last post by Ravi@asp.net
      • Hi Friends I have two word documents.I have to compare the both documents.The difference between the two document is that the second documents contains an image,insert some data or delete some existing data.I am able to find the changes and store the result in another document in which the changes reflects.Now our main moto is how can the end user identify that there is a change of only ima
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • How do I deal with files of more than 65k rows?
    by chilehed
    8 Replies
    Last post by chilehed
      • I need my code to be able to deal with .csv files of well over 65k rows, but haven't the slightest idea how to do it. I've heard of a technique called "paging", which distributes the data over more than one sheet but processes it as if it's on one. How is this done Thanks.
  • Using VBA macro to locate next free column on worksheet
    by rabbitoh
    14 Replies
    Last post by magicalclick
      • I need a macro that locates the next free column (i.e. has no data in cells) and then places the cursor in a cell on a designated row. Would like search to start from column B and to place the cursor on row 4 on the free column. <> My VBA code thus far: Function NewColNumber(Range1 As Range) As Integer Dim j As Integer For j = 1 To Range1.Columns.
  • Setting a Bookmark to insert a Page Break in MS Word
    by LeVraiNinjaneer
    2 Replies
    Last post by LeVraiNinjaneer
      • Hi! I know how to use setBookmarkString, but I need to insert a Page Break with a Bookmark. What Function do I use thanks in advance Pieka
  • Macro - Replacing Contents of Cells
    by rachel777
    1 Replies
    Last post by Shasur
      • When dealing with the a spreadsheet, is there a macro code that would replace the contents of a cell with a "0" for all of the cells in each column in the Questions worksheet that do not match the criteria from a specific cell in the Solutions worksheet I received wonderful help for a similar question on the same worksheet with the following original question: I am trying
  • Getting data from other workbooks
    by Jeff DigiTech
    4 Replies
    Last post by Jeff DigiTech
      • I have a master Excel file named (master.xls) and other slave files called ( slave1.xls, slave2.xls, slave3.xls ....salve5.xls and so on. ) master's structure is exactly the same as other of other salves where they all contain a number in cell A1 master will first select the slaves. And master wants to calculate the sum of A1(s) in slaves and have the result put in B1 of master.xls getting A1(s) f