Answer Questions

• BabuMan Run-time error '3085' - Undefined Function in expression

  I have an intermittent problem with an Access database. I have a function defined in a module shiftletter, which takes two parameters. This function is used by a query. Nine times out of ten the query called by VBA works. But occasionally I get the above error, to make the query work I have to reboot my machine. Opening and closing the database does not help. Running the same query in the query window works. I have tried moving the functio ...Show All

• Dario Galvani Named range in another open workbook

  Can I refer to a global named range in another open workbook from a worksheet module within the active workbook   I have not been able to figure out how to do this. First create a workbook called "farbook.xls" and define a named range called "farname" and in the farname cell enter a value and save and close. Then enter the following in another workbook: Sub GetFarValue() Dim oW ...Show All

• Bilal Haidar - MVP Business Score Card Accelerator Server

  Can anyone assist with a deployment architecture recommendation for Business Score Card Accelerator Server I have a deployed sharepoint server, connecting to a 2005 instance. But when trying to install BSCA on either box, the installation fails because it is looking for a local instance of Sql server to be installed on the sharepoint server. Hi, Actually, your best bet would be to post this question to the BSM newsgroup as t ...Show All

• Cllee Outlook tasks - how can I see them?

  Hi everyone, I was wondering if there was an easy way to connect to MS Outlook and get a list of the users tasks... Any sample code would be greatly appreciated. I think I need to add a reference to Outlook 11 object library... or is there a totally different solution to this. Any help is appreciated. Thanks. Hi Brenda. Thanks for the post, I tried it and it gave me an error saying the Outlo ...Show All

• Kache4 Access report using VBA

  Hey All! I have a problem. I am creating a screen that includes persons first_name, last_name, phone_number (this is a fields in access) Now I have created a command button and I want that when user clicks on the command button the information in those fields would go to excel page. Sincerely, Boris Good answer! Maybe you can help me for a further more complex question: How can I parametrize Docmd.TransferSpreadsheet ...Show All

• realism Outlook email information reader/extractor

  Hi, I have a server that emails me some a couple of numbers, whenever an assembly process changes.  The emails are always in the same format.  I would like to run a macro in Outlook that would extract some of the numbers in the email, and put them into an excel spreadsheet.  How would I go about having a macro read an email to extract some numbers. Thanks for your help! Per the s ...Show All

• Mike Martos macro doesn't run on open

  i have a macro that does not run when the excel worksheet that contains it is opened. i have tried Private Sub Worksheet_Activate() and Private Sub Workbook_Open but neither will fire when i open the excel spreadsheet. my code is contained within the Subs what else do i have to do Creating a Sub Workbook_Open() procedure within the ThisWorkbook Container should do the trick. ...Show All

• Khaled Hussein Per-user connections in Business Scorecard Manager

  Hi, Have implemented stricter security around A.S (have removed the Everyone from roles and have added specific users to have access to A.S) When I go to BSM and try to edit / test the connection to the existing datasource, it does not return anything. Found a website that said it might be an option the change the web.config files and set ConnectionPerUser = TRUE, where it's currently ConnectionPerUser = FALSE. Now, sharepoint's brea ...Show All

• drS Excel Keyword search

  Hey folks I hope someone can help me. I am using excel 2003 and have written a VBA code to search about 10,000 hidden lines and unhide them when they come acorss a keyword. What I can't figure out is how to get it to run through the database once and stop. Anybody have any ideas. Thanks Hi Echo, You need to know the end row and the current row. Once the current row = the end row then its time t ...Show All

• Dascalos Superscripting in PowerPoint

  Does anyone know how to Superscript part of a datalabel in PowerPoint from Excel VBA. The following code works. With oGraph.SeriesCollection(rowX) For colY = 1 To .Points.Count .Points(colY).DataLabel.Caption = .Points(colY).DataLabel.Caption & "ABC" Next End With But I am unable to Superscript the "ABC". Hi, The support engineer needs some additional ...Show All

• Matt Bond Update document properties on MS site server

  Hello, I hope that this is the right place to ask my question about MS Site Server. After the migration to new user accounts I want to change the ownership of the documents in our content management system. With this code “Select owner FROM ContentManagement..SCOPE(' ""D:\Inetpub\trnintranet\publishing"" ') Where…. “ it is possible to show all documents from a specific owner. I tried to make an update statement ...Show All

• Marc Allard Authentication schemes in LCS ?

  Wanted to know how it is possible to register with LCS from a SIP client which doesn't support NTLS or Kerbaros authentication schemes Can HTTP Digest Authentication be forced to be used if Authorization header is added in advance in the initial SIP REGISTER request Is LCS interopearble with 3GPP IMS SIP clients Thanks in advance !!! Hi Deepak, Here's some info from the LCS team: ·  &nb ...Show All

• Sandeep Prabhakar MODI Port

  I have some questions: 1.- How to distribute MODI Port with my application 2.- Found MSM (module merge) 3.- How to install "Microsoft Document Imaging Writer Port", without CD office 4.- That files use the MODI 5.- The files .MDI is better of PDF ! Tks a lot, Per our support engineer: I did some research over the case and was able to understand the context of mos ...Show All

• dustbin1_uk Source Object as a query

  Hi i have a form that contains 2 text box's and a subform what i really want to do is to run a query and not have an input box popup i would like the dates entered into the 2 text box's to be used in the query of the subform and display a table that shows all records that are between date 1 and date 2. SQL code: PARAMETERS [First] Text ( 255 ), [Second] Text ( 255 ); SELECT Equipment.* FROM Equipment WHERE (((Equipment.[Date Installed])>[Firs ...Show All

• Steve Boyd "Custom" properties of office and other files...

  I have been trying to figure out how to access the "Custom" properties of office documents from other programs. The exact thing I am trying to do is automatically gather the info from the custom properties within a pile of files. some of the files are office documents, others are actually SolidWorks files, but both have the same "custom" tab on the file properties dialog from windows explorer. In the ideal world, I would like ...Show All