Microsoft ISV

Page 134




  • Topics
    Replies
    Last post
  • excel chart
    by paxa
    2 Replies
    Last post by paxa
      • hi. i'm a little newb in vba and excel can anyone help me get this problem figured out i have some charts in an excel worksheet, and what i would like is to select a chart, assign the the series values for it that are in another sheet and then select another chart and do the same again any help would be appreciatted thanks in advance
  • SpeedUp a Macro in Excel - Disable Functions
    by PYA_Ferro
    8 Replies
    Last post by PYA_Ferro
      • Hi all, In my macro I used this sentences to speed it up: Application.ScreenUpdating = False Application.EnableEvents = False But I've also created some functions and they are beeing recalculated every time my macro do a change in a worksheet. Is there any way to disable the calculation of functions Thanks and really sorry for my English.
  • Can I add a button on the toolbar with a certain code?
    by lyp_sj
    1 Replies
    Last post by MyLady
      • Hello, I'm wonderring if I can make a button on the toolbar with a certain code Thanks so much! B.regards/Yaping
  • Writing result in Excel
    by Victor D
    2 Replies
    Last post by Victor D
      • Hello, I have the folowing code:   Public Function DgrMinSec2DecDgr(Angle As Double) As Double ' * -------------------------------------------------------- ' * Program not yet working ' * -------------------------------------------------------- ' * Variables Dim grd As Integer Dim min As Integer Dim sec As Integer Dim calc As Double ' * Values grd = Angle \ 1 calc = (Angle -
  • New CRM 3.0 Blog - http://4mscrm.g-s.co.il
    by mblaivas
    1 Replies
    Last post by mblaivas
      • New CRM 3.0 Blog - http://4mscrm.g-s.co.il
  • Obtain Unique Work Units via SQL
    by AlDeb
    14 Replies
    Last post by AlDeb
      • Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals. I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits. In the example below on on
  • aggregate functions: problem with SELECT SUM()
    by Maximus
    4 Replies
    Last post by Cringing Dragon
      • Hi there, I wonder why the function below returns 0 (it should return 4335) * the conn to the db is ok (this function works with diff parameters, it has somthing to do with the SUM) * I check the SQL code on the db - and the return result is not 0 Code Snippet Function test3() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row Set objDB = DBConnect()
  • Reference a query rather than table as recordset source
    by RhysDavies
    1 Replies
    Last post by RhysDavies
      • Hi - my brain is frazzled at the moment. I have a form that exports contact information from an access table into a public folder in outlook. However i dont want the code to reference the table, i want it to reference a query which contains all contacts that have an email address. the relevant bits of code are dim rst as recordset Set rst = dbs![tblContacts].OpenRecordset(dbOpenTable,
  • (newbie) How can I flag multiple values in a column?
    by Dave Navarro
    1 Replies
    Last post by Shasur
      • Hello all - I'm trying to create an Excel VBA macro (my first one!) that will do the following: Search a column, and for any duplicate values in that column, turn those cells red Move to the next column and repeat (flagging values that are duplicates *only* in that column). (Preferably) Quit when it comes to an empty column. The XLS in question is a scheduler where the columns represen
  • Using DCount function in a Report group footer
    by LizF@RMIT
    6 Replies
    Last post by Cringing Dragon
      • Hi, I'm having trouble getting a DCount function to work on an MSAccess 2003 report. I'm using a text box in a group footer - I want it to show a count of the number of distinct records in the group. Here's what I'm using - which produces the result of '#Error' with no further help.: =DCount("Task ID","Tasks","TaskID IN (SELECT DISTINCT TaskID FROM
  • Vba Excel - Get Workbook Author
    by ajliaks
    3 Replies
    Last post by Shasur
      • Hi guys, The code below makes an excel spreadsheet wich retrieves the names and details of the files contained into a specific folder. Does anyone knows how to get name (author) of the file Thanks in advance, Aldo. Function GetListOfFilesInspecifiedFolder() Dim oFSO As Object, Folder As Object, File As Object Set oFSO = CreateObject("Scripting.FileSystemObject"
  • Does Winqual accept WER reports from Vista systems?
    by Claus Brod
    14 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
  • How to capture cmd output from Shell.run
    by mamutp
    0 Replies
    Last post by mamutp
      • I am working on a VB Script. My problem is I am running a command with some arguments as below: y = shell.Run( "%comspec% /c D:\tp\my_prg\my_prg.exe" & " " & JT_filename & " " & jtcatia_config, 1, true) Now in my application, a cmd window having some messages comes and vanishes away as was expected by above statement.
  • Web Pages into Excel
    by JezLisle
    0 Replies
    Last post by JezLisle
      • I have a database system at work that only allows the printing of a report query or saving as a web page. I need to be able to add this data into other things. So if I save the report as a web page, how can I import that into excel I am looking for some vba code that would import the web page onto a specific worksheet and this would enable me to take data from it and produce my own report.
  • Office Communicator 2005 sign-in name, auto populate after install somehow?
    by markm75c
    14 Replies
    Last post by Mike@ALS
      • Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users prob
  • SharePoint 2007 Consumer Web Parts Don't Consistently Consume Values of Sorted or Filtered SharePoint Lists
    by Mark Coburn
    0 Replies
    Last post by Mark Coburn
      • I am experiencing a problem in SharePoint 2007 where my cell/field consumer web part sometimes receives a consumed value of null when the provider web part is a sorted or filtered custom SharePoint list. To recreate this problem simply create a new custom list in SharePoint by clicking on Site Actions > Create > Lists. Leave the schema of the list as is so that you just have the default Titl
  • Exchange 5.5 Network Architecture Reconfiguration
    by djaps
    0 Replies
    Last post by djaps
      • Please help me with repositioning my MS Exhange 5.5 Mail server in Active Directory Corporate Network. At the moment the Exhange server is located on the same member server with DNS server, and this machine is on PUBLIC ADDRESS and NOT behind the firewall!!! DNS should stay alone on this machine with public address, but Exchange should be set up on different machine behind a firewall. All clients
  • 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
  • i cannot play a game
    by Ismaila Tunkara
    1 Replies
    Last post by MS ISV Buddy Team
      • whenever i tried to play a scrabble game, it says scrabblecomple.exe has encouter a problem (application problem). once i put my tiles on boaed. if i hit play this error report appears and it closes the game window. it is driving me crazy..i need help on how to fix this issue. thanks
  • run an exe file in excel using VB
    by mambo5
    5 Replies
    Last post by mambo5
      • Hi, I want to run an exe file in excel using VB, any simple coding for that Thanks.
  • Multi-column List Box with data not from excel spreadsheet
    by JBNV123
    2 Replies
    Last post by JBNV123
      • Hi, I am trying to create a multi-column list box with data that is NOT from an excel spreadsheet. For example, I would want to make a 2 column list box with someone's last name next to their first name: Smith Joe Baker Jeff Jones Bob etc. I want them in two columns but i want to be able to select a single person by selecting a row, ie so that the last and first name are considered a single unit
  • Use of InStr() function
    by une
    3 Replies
    Last post by Andy Pope
      • Can you use InStr() to determine the position of the next character in a string that is not equal to one of a number of options. If so, how For example, what would be the syntax of an expression that returned the position of the next character that was not either a "t", space, tab or return character Would you have to use ascii representations of some or all of these characters in th
  • error report
    by vicki1957
    1 Replies
    Last post by Andreas Johansson
      • What can I do to stop error reporting. When I close my internet I get an error message stating the windows must close etc. iexplorer.exe error
  • Service application crashing without WER dialog
    by Hossein Mirarab
    2 Replies
    Last post by Saar Picker - MSFT
      • I created a C# windows service and to crash my service application I run from elevated console following command: threadhijacker.exe /crash:av /tid:[thread id of service] /debugpriv It inject Access Violation to service and crash it, this cause cpu rich 100% and a dw20.exe process run in task manager but no WER dialog showed (Note: Vista error reporting Setting configured to show
  • Office Communicator Login Problems
    by Elie Sidawi
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi, I am facing a problem while logging in to Office communicator , every time i login to my PC the office communicator login normally but my status remain UNKNOWN. and i am not able to contact anyone and i am always as offline for other users. does anybody can assist in solving this issue. brgrds\Elie