Microsoft ISV

Page 139




  • Topics
    Replies
    Last post
  • Assigning text box input to cells
    by une
    1 Replies
    Last post by Andy Pope
      • I have two problems. here is the first; In Excel I have a userform that prompts the user to enter values in text boxes. I then assign the values entered in the text boxes to various cells as follows; Range("B8").Value = TextBox1.Value Is there a more correct way of doing this I am not sure if I should be using Range. OK, here is my next problem; The userform is
  • VBA excel outlook / A program is trying to send mail using Item.Send
    by rhXX
    7 Replies
    Last post by LuisEG
      • hi, i am trying to send an automatic mail from excel VBA to the outlook outbox, when i send the mail i obtain this security warning: A progam is trying to automatically send e-mail on your behalf. the help buttom says: A program is trying to send mail using Item.Send A program is trying to automatically send e-mail using a Microsoft Outlook Visual Basic Application command, Item.Send. If you want
  • *** How can I add module code to a specific module? *** NEED HELP !!!!
    by sydney2000
    4 Replies
    Last post by NWAprog
      • Hi, I am currently working on an Excel Workbook where I have added a brand new code module called "Calculations2007". This module (*.bas) file contains several new functions. I have been searching on the web on how to deploy this new module in my workbook to a group of production workbooks. Basically I need this new code to get to production. I have gotten to a point wher
  • ListBox.AddItem drops value for last column if semicolon is in data
    by ke wenzel
    1 Replies
    Last post by ke wenzel
      • Hi, I am using a ListBox in MS Access 2003 with multiple columns that may have commas or semicolons are part of the data. I understand that when using the AddItem method that I need to use double quotes to surround the data before delimiting the values with semicolons. The problem is that when a semicolon exists inside a value, the ListBox drops the last column. Example: Code Block
  • Problem to activate server in live communications server 2005
    by Nard8102
    6 Replies
    Last post by jugal
      • I have just installed Live Communications Server 2005 Standard . I have a seperate server as a Domain Controller. When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I activate server the HTML log files show me this error 0x80072030 There is no such object on the server. , and i can¡¯t activate the
  • Excel status loader/counter?
    by Scott Boyd
    2 Replies
    Last post by Scott Boyd
      • Hey, Not quite sure how to word this but what i'm looking for is like some sort of preloader or egg timer style graphic or percentage counter to display when my function is running to indicate to users the current progress.  The function i'm running takes up to 3 mins to calculate so wanted to be able to show users that the program hasn't froze etc. [EDIT] Sorry just to update, i n
  • Enable/disable specific button in command bar
    by Gopra
    7 Replies
    Last post by Andy Pope
      • Need to enable/disable a button if if choose shapes, text boxes then button fill color should be enable, if i unselect then it would be disable
  • Add a customized Tab in Communicator 2005
    by Gabriel Méndez
    7 Replies
    Last post by Ken Kosmowski
      • Hi, i'm trying to add a new customized tab in Communicator 2005 to show an html page, i have a document titled "Planning and Deployment" which somehow explains how to do this... I tried to add a new entry on the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Communicator called "TabURL" and also under HKEY_CURRENT_USER\Software\Policies\Microsoft\Communicator wi
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • Enable/disable specific button in command bar
    by Gopra
    7 Replies
    Last post by Andy Pope
      • Need to enable/disable a button if if choose shapes, text boxes then button fill color should be enable, if i unselect then it would be disable
  • How to determine the cursor position to Excel range
    by Perry Choy
    6 Replies
    Last post by Perry Choy
      • I want to get the cursor position of excel application range A1
  • VBA Language Definition
    by RyanH106
    2 Replies
    Last post by RyanH106
      • Hi, just a quick question Does there exist anywhere a formal definition of the VBA language It would be really useful for my dissertation as i am writing a program that interprets macros so could do with something that would tell me, for example all the different ways that variables can be defined, or all the different types of statement that can be used etc. Any advice is much appreciat
  • Configuration Failed: Windows SharePoint Services 3.0 (Beta)
    by KevinTunis
    9 Replies
    Last post by lindi_xp
      • Downloaded SharePoint Services 1.I selected Basic Button ¡°install single server stand alone using default settings 2.Closed SharePoint Service Install and checked to start the configuration wizard. 3.Next I said yes to the popup message: The following services may have to be started or reset during configuration: Internet Information Services SharePoint Administration Services SharePoint Timer Ser
  • Excel help needed
    by GaryHolc
    4 Replies
    Last post by magicalclick
      • Prob very simple to do but I cant figure it out. All I want to do is enetr a formula in every cell in a column until I reach the end of the dataset (the data can vary in size and rows). So lets say I start in cell J2, how do I enter a formula in J2, then move down to J3, J4 etc. until it reaches the end Many thanks.
  • Combobox Add Item Run-time error '13': Type Mismatch" Access Form
    by john.w.keck
    1 Replies
    Last post by Cringing Dragon
      • I have a database where I have a table set that populates a combobox that fills a field. They have requested that I allow them to directly add a new item directly into the combobox vs my link to the database. I though I found the answer below, but everytime I think I get close, I get the below error - "Combobox Add Item Run-time error '13': Type Mismatch". Thanks in advance! I used the
  • Pivot Table Totals
    by polenick
    0 Replies
    Last post by polenick
      • Hello, I'm working in Access 2003. I have a form on which I have a Pivot Chart (clustered column). There are two series and the number of categories varies depending on the data. What I'd like to do is display the total for the entire chart. I'm wondering what the best way to do this is The total doesn't have to be on the chart itself. I could put it somewhere else on
  • Generate ID when user press Save Button
    by Ashu Sehgal
    0 Replies
    Last post by Ashu Sehgal
      • We add one Attribute named AccountCustomID in account table though Microsoft CRM 3.0 . Which we want to make auto generate (i.e. this attribute is not shown on the form) when user save the account according to some predefined rule for example if user region is south and user city is Delhi then in AccountCustomID CRM save SDEL001 which is auto generate by CRM according to region and state and add u
  • iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
    by sapphireoceans
    14 Replies
    Last post by Jillytodd
      • Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
  • Converting Sub routine to UDF
    by Charlesi123
    1 Replies
    Last post by Andy Pope
      • Hi! I wrote the code below, but can't seem to get it to work as a Function (although it works fine as a sub routine with the 3 lines un-commented) - it's a 3D sumIf. Can someone tell me what I'm doing wrong Thanks a lot!!! Code Snippet Function sumifall(Look_Val As String, Tble_Array As String, Sum_Range As String) 'Look_Val = "a12" 'Tble_Array = "a5:d5
  • [Excel 2000 + VBA] How can I check that cell colour in was changed in Worksheet_SelectionChange
    by Tomek S
    0 Replies
    Last post by Tomek S
      • I wrote short formula to sum or account the same colour cells in selected area. Because this formula is plenty slowly I want to account value with every colour change in cells. How can I detect that there was change of colour
  • Microsoft Platform Test for ISV Solutions
    by Eli Gazit
    2 Replies
    Last post by EliGazit
      • Hi. My company is getting ready for the "Microsoft Platform Test for ISV Solutions". Can I find more detailed directions and resources to set the designated application for the test i.e. to pass "managed code" tests- I know that the application is free from 'DllImport', but I'm not sure that: This is enough. One of the components I'm using works with unm
  • populate listbox with data from a table, depending on what's in another listbox
    by Mondego
    0 Replies
    Last post by Mondego
      • i am using MS Access v6, and am desperate. i have posted this everywhere and no one has a answer. i have done many searches, and tried many things. i hope this is even doable. i need to query a table, but only where a field in the table equals a field in a listbox.column(2) I have 2 listboxes, the first has a list of parent categories, the second has a list of subcategories. i need to c
  • Problem with checkbox
    by RuizJ
    11 Replies
    Last post by Sumerdai
      • Hi. We are having a weird problem with the checkbox control. We are using an access project (.adp) to connect to a SQL Server 2000 database and the visual basic editor that comes with Access to create the form, macros and reports that the system runs. We don't use third party tools and its purely just the default settings that MSAccess gives We use checkboxes in the project forms linked to fie
  • Justifying text in message box
    by une
    2 Replies
    Last post by une
      • Is there a simple way to justify text in a messgae box Consdier the following text; The number of lions = 23 The number of tigers = 2 The number of monkeys = 34 I would like the words and the equals signs to be left justified in the message box and I would like to right justify everything to the right of this. This would mean the numbers would all be right justified and line up
  • Export snp file from access - file name
    by ezop
    0 Replies
    Last post by ezop
      • Hi, I would appreciate help with a problem. I have the following function, which exports a .snp file (kl.snp) from access: Function Makro_max() DoCmd.OutputTo acReport, "rptdob_KlVlastni_IMT_Max", "SouboryveformatuSNP(*.snp)", "C:\Documents and Settings\kvit\Karel\Komentare\Test\KLnaSQL\Export\ kl.snp ", False, "", 0 End Function What d