Microsoft ISV

Page 96




  • Topics
    Replies
    Last post
  • iexplore.exe does not respond
    by herman_hhh
    1 Replies
    Last post by Gwendelyn
      • Hi: I just got a new desktop and ie7 was installed when running windows update. It didn't work well and I decided to uninstall it. ie6 was back. However, ie6 now slows the pc significantly. When I close ie6, I can still see iexplore.exe running in the task manager. Plus, when I want to turn off the computer, it says that iexplore.exe doesn't respond and I have to press "End now" 2 to 3 t
  • 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
  • Projects, objects & modules
    by une
    14 Replies
    Last post by une
      • I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named
  • Worksheet_Change event and dropdown list
    by ADG
    4 Replies
    Last post by x_centric
      • Hi all In Excel I have a cell with validation set , (restricting input to values in a range), and a dropdown list for the user. When the user changes this cell by using the dropdown list it does not seem to trigger the worksheet change event. I want the change of cell to trigger an event to collect data relating to the selection. Any ideas why the drop does not trigger the event as expected
  • Performing a spell check on the contents of a userform field
    by rabbitoh
    2 Replies
    Last post by rabbitoh
      • I want to run a spell check on the contents entered by a user into a field on an active Form. This can be either automatic as user types or manually activated via a button on the Form itself. Can this be done and if so, what code would allow this to take place.
  • vlookup
    by Namrata Prashar
    14 Replies
    Last post by Namrata Prashar
      • Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata
  • Stuck on logic for Excel problem...
    by Scott Boyd
    6 Replies
    Last post by Scott Boyd
      • Hi I am stuck on the logic for the following problem. I have a list of employees and each has a manager attached. I want to write a macro that will loop through all the employees on the sheet and compile a list of the managers with all employees reporting in to them. I've attached an example as this may be hard to visualise! http://i102.photobucket.com/albums/m82/sc0ttb_2006/Sheet1.jpg htt
  • Combo Box Headache
    by Techgrrl
    4 Replies
    Last post by Techgrrl
      • I have a combobox control embedded directly in a word document. I have added items as such: cboResults1.AddItem "text", 0 Why is it that when I put in the indexes, the control doesn't work
  • Event Procedure
    by Access Keen User
    4 Replies
    Last post by Access Keen User
      • I want to set [Event Procedure] as I have set so many Event but one of my form, shows me following message. Code is simple DoCmd.OpenForm"My Form Name" Where is the fault, if some one help me. The expression On Click you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure ha
  • Updating Database on Server from multiple databases on C:\ with MS Access
    by sqglmrflover
    0 Replies
    Last post by sqglmrflover
      • Here is the problem: On everyone's C:\ is an MS Access database that is linked to our MRP system JobBoss. I have created a custom program for producing inventory labels. I need to capture each part that is labeled in a central database so I can monitor progress, check for problems, etc. I am unable to update the database on the server. I do not get any error messages. Simply the table on the serve
  • DOS Command Question
    by okieflier
    3 Replies
    Last post by Derek Smyth
      • Im sure this is easier than what im trying to do, but any help would be great. The following code is from my .bat file, the problem is I have numerous file names that change on a daily basis, that I know I can programically change. Im not sure how I can send the dos command though from MS Access/VB. I don't want to use a .bat due to having to change file names. The following is what is in my .b
  • VBA and Excel - If and Find expressions
    by Ronan OK
    2 Replies
    Last post by Ronan OK
      • Hello I am trying to use an If statement to find an piece of text and then go to the cell that contains that text. I have, as part of the if statement, an else statement that just cancels the expression and does something else if it cant find the iece of text. However, the expression doesnt seem to work when VB cant find any cell with the specific text and it just comes back with a run time err
  • 3 consecutive periods = 1 character
    by une
    3 Replies
    Last post by une
      • I am using VBA under MSWord 2002. It seems that MSWord 2002 often treats 3 consecutive period characters as a single character. This is causing me grief as I am trying to write code to count punctuation marks in text. Thus my code counts 3 consecutive periods as 1 period. How can I get around this
  • protect cell containts
    by Abhijeetkadam
    1 Replies
    Last post by Bruno Yu - MSFT
      • Hello, I have office xp . i am not well versed with visual basic in excel programming. i have one sheet where i have created a macro which returns current system date by pressing ctrl + o i need two things 1) i have 15 lines in A column wich contains list box . user have to select a option from that list box and next to that option by pressing "ctrl + o" record
  • adding a non-adjacent cell to a named/defined range
    by bilo_krewol
    2 Replies
    Last post by Andy Pope
      • I have a set of data in a spreadsheet that I want to run a macro through that will: 1. test each cell against specified conditions; 2. depending on what conditions are met, add that cell to a specific, named range; and 3. run statistical analysis on the named ranges. #1 and #3 I am OK on, but #2 - I have not been able to figure out how to resize the range to add a specific, non-adj
  • Creating Excel File Error
    by CoderMike
    2 Replies
    Last post by CoderMike
      • Hello, I'm trying to create an Excel file using ADO. I can read from an Excel just fine, but creating it has been more of a problem. When I try to open a connection to a file name, I get "object not found" error. According to the MS article I read, the workbook should be created automatically when I create my first table in the workbook. However, I can't see how I can do this if t
  • Using Inet to download an FTP File
    by Dudeman
    4 Replies
    Last post by Jack_II
      • I am creating a macro in Access VBA where I need to retrieve a text file from an FTP site and store it on my c drive. The code seems to be working fine but it does not do anything. It should be creating a file on my local computer, but no file ever comes back. Please advise with any suggestions that could get this code to work. Sub FTPCheck() Const cHost = "ftp://ftp.xxxxxx.com/xxx/xxxxx
  • Creating and Editing Microsoft Access Reports using Visual Basic
    by bennymacca
    3 Replies
    Last post by bennymacca
      • Hi, I am trying to create a report based on the selection from a combo box in a form. i have some data, of which one of the fields is callled "projects". the combo box selects selects a project, and i would like to be able to open a report showing the data that belongs to the specific project on the click of a button. i have written the code below, but the report is only ever bl
  • WER Dialog not showing up on Vista
    by Jerry Noll
    7 Replies
    Last post by Claus Brod
      • What should a managed application do in order to have the WER Submit report dialog appear We have a managed client application that is subscribing the App domain's UnhandledException event. When this occurs, we log the exception, stack trace, and inner exception to the Application event log. We would like to report this event to WinQual. However, we are not seeing the WER dialog appear. Do
  • Add additional value axis gridline to msGraph.Chart.8 object
    by Bunglemutt
    2 Replies
    Last post by Bunglemutt
      • MS Access report with embedded msGraph.Chart.8 object. Graphing the series based on the rowsource to my satisfaction, but would like to add a pass/fail reference line to illustrate passing/failing datapoints. Can I simply add a value axis gridline with the appropriate value and a custom color to illustrate the pass/fail reference line If not - can I fake doing that by plotting another se
  • A question from a beginner...
    by meisaka
    6 Replies
    Last post by meisaka
      • Hi all: I am new to the programming world, and I am interested in learning VBA. So, please provide some tips where should I start Thanks in advance.
  • email using CDO (Collaboration Data Objects)?
    by MyLady
    3 Replies
    Last post by Andy Pope
      • Hey, How do I, from Excel, send email using CDO (Collaboration Data Objects) Best Regards Cathrine
  • Help needed: Retrieve tables in word and copy them to Excel
    by Rz1986
    3 Replies
    Last post by bi-lya
      • Hello everyone, I have been assigned a task at work to write a VBA for automation. We have many word documents in a folder that have hundreds of tables within them. I want to create an automation program that is going to retrieve tables from the word document specified and go through the document table by table copying these tables into a separate Excel sheet named after the document itself
  • Creating LookUp/Filter Command Button In Access 2003 using VB
    by KaysWeb
    3 Replies
    Last post by Cringing Dragon
      • I'm trying to create a LookUp/Filter Command Button using VB. I am not a programmer so I tried using what I found on the internet. My Field Name is: Last Name My Table Field Name is also: Last Name The code that I am using is as follows: Me.Filter = "Last Name = "" & me.Last_Name & "'" Me.FilterOn = True When I click on the Command But
  • Office 10 \ winword.exe runtime error
    by Kdean6869
    14 Replies
    Last post by Jyh-Cheng Chen
      • I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe.