Microsoft ISV

Page 120




  • Topics
    Replies
    Last post
  • Excel VBA: Copying from file to file
    by rodcon
    3 Replies
    Last post by Peter Mo.
      • Thank you Mr. Dawson for your help with copying formats using Excel VBA. But I still cannot copy from a workbook that is part of a separate .xls file. The code works between worksheets of a workbook in one .xls file. If I try to copy from one file to another I get an "Error '9': Subscript out of range". This occurs even if I specify the path. Anyone have any thoughts 'refe
  • Getting The Content Of A Word Document?
    by KAMACI
    7 Replies
    Last post by KAMACI
      • How can i get my ActiveDocument's content
  • Deleting Rows From a dataset
    by NutoVBA
    1 Replies
    Last post by Peter Mo.
      • I am trying to delete a range of rows from a dataset. The rows that I am trying to delete conatin account numbers with the first three characters = 231. My account numbers are in column b and l is defined as a row on the worksheet. The code I am trying to use is as follows: If Left(Range("b" & l), 3) = 231 Then Rows("l").Delete I do not know why it will not wor
  • VBA macro to replace
    by sree
    5 Replies
    Last post by sree
      • Hi I have two worksheets in a workbook, In sheet 1, i have columns Sector level 2 and 3, for some enterprises In Sheet 2, i have columns sector level 1, for the same enterprises, I wish to create a macro, which would look for corresponding enterprises which is the only common element in both sheets and then it should replace corresponding sector level 2 with sector level 1
  • Using a Check Box in Word
    by aburnett
    1 Replies
    Last post by Shasur
      • I was reading the post regarding the check box in excel and I was curious if it is possible to put a check box in word to copy a range of data from an excel document to a word document If so, how would the code change from the code displayed in the "Check Box in Excel" post
  • .mdmp files not being created
    by David Ching
    14 Replies
    Last post by JPSA
      • Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
  • Building dynamic forms in Access
    by nbert
    3 Replies
    Last post by RhysDavies
      • I need to make dynamic forms in access. For example i have a query that selects a user and 3 jobs he has. So the result in the query has 3 lines. Now i want for those 3 lines 3 different textboxes. Is this possible in VBA or not I already searched the help of access it self and i cant find anything about it. thx for your help in advance.
  • Need help
    by RUSKIE
    2 Replies
    Last post by Andy Pope
      • Hi All, I am building a macro and would be grateful if you could help me out. I cannot figure out a way how to make this work: ------------------------------------------------------------------------------------------------------------------------------------------------- b = 0 Do i = 1 + b Do While Sheets("Box Pivot").Cells(2 + i, 2).Value <> ""
  • Determining size of Access database and assigning to VBA variable
    by Agent Dagnamit
    1 Replies
    Last post by Andy Pope
      • I want to assign the physical file size of my database to a VBA variable (to stop some code running if the database increases in size by, say, 50%) I'm trying to use: application.currentdb.properties(x) Is this right, and if so, what is the number or name of the particular property that returns the file size Thanks Stuart
  • how can I count # of columns between two specific columns?
    by lyp_sj
    3 Replies
    Last post by lyp_sj
      • Hello, How can I count # of columns between two specific columns such like, how many columns between column A and column D Thanks so much! B.regards/Yaping
  • Corrupted Error Report?
    by Optical10
    3 Replies
    Last post by Optical10
      • Hello Whenever computer recovers from a serious error after restarting the Windows error report is corrupted so I get this message in the Explorer responds page, ”°Corrupted Error Report Unfortunately, the error report you submitted is corrupted and cannot be analysed. Corrupted error reports I rare. They can be caused by hardware or software problems, and they usually indicate a serio
  • API and Excel validation-lists
    by JoshZ
    0 Replies
    Last post by JoshZ
      • Hi, I've been trying to create an excel sheet with a validation list that shows pictures when the mouse cursor is on a list item. The problem is that I can't know which item the cursor is on, because validation lists don't give the index... so, the question is, does anybody know of a way (API or not) to get the index number of the item the mouse cursor is hovering on Alternatively, does anybody kn
  • Making a Automatic Updatable Hyperlink List
    by Clarence j
    7 Replies
    Last post by MyLady
      • Yes Hello Everyone and thanks for looking at my Thread I am currently trying to Develope a Small Database of Student and Would like After I make a New Worksheet Named After Each Student Example "Sarah Lee" "Michael Jordan" "Bill Cosby" That on the Worsheet Named "Student List" which is in the same workbook Will Make a List of all the w
  • Workflow Post URL in CRM 3.0
    by Kartini
    2 Replies
    Last post by DavidJennaway
      • Hi, I want to use Post Url Wokflow in Ms CRM 3.0 with passing parameter. I had do that with select the field to post into a url (in the OnCreate Order). For example the url is "http://localhost/Default.aspx" and the selected field is Order ID. I try to Request.QueryString ["Order ID"], but value of the order id not filled. How can I get the value of the field which the crm post
  • variable types?
    by gr44gs
    1 Replies
    Last post by Andy Pope
      • My "File" variable returns exactly what I want, the problem is the Query doesn't reconize it. When I watch "File" this is the result "W:\Work\BFI\BFIResults\Copy2of05455100b\N1.BFI" I think it is the quotation marks because when I just type the path, without the "", it works the Macro uses many files within the certain directory so typing in the
  • Help with a formula
    by TigerPhoenix
    14 Replies
    Last post by Derek Smyth
      • I need to write a formula for Excel that calculates the amount of fuel that is in a tank. Here is what it is for. We have cylinder tanks that lay horizontaly. Each month we put a dipstick into the tank to measure how many inches of fuel is left in the tank. I need a formula that will take that and calculate it into gallons. Here is the formula I have to work with. / -1 r - h
  • 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 to write a query In VBA for Arc Map applications
    by Kris18d
    0 Replies
    Last post by Kris18d
      • I have a table with a number of fields and I need to display the data of one field called 'Fdate' which is of type 'Long' The field 'Fdate' contains data ina a column as follows 19350601,19350602..... where 1935 is the year and 06 is the month and 01 is the day.So I need to obtain the data from the year 1935 to 2006 for the months of June 01 to Aug 31.So I have written a query but I
  • How to create a chat room on Communicator 2005
    by Marco Antonio Ribeiro
    6 Replies
    Last post by MS ISV Buddy Team
      • Hi fellows!! Is it possible to create a chat room, or a meeting room, whatever, in Communicator 2005 I'm trying to keep a chat window with my friends for all day long, but it closes every 10 minutes.... I wanna keep this persistent for all time that members are logged in. Thanks for any help!!! Regards, Marco
  • checkbox and enabling text fields
    by StuartB10
    1 Replies
    Last post by Rick
      • I am truly a novice when it comes to VBA and hopefully someone can help. I am trying to write some VBA code in Word 2003 for a document / form that contains a check box and a text field. All I need is for the text field to be enabled once the checkbox has been checked. I cant seem to get it to work. Any help would be appreciated So far I have come up with the following but it doesnt work If Se
  • Microsoft Office 2003 "word" not working properly after copying transferring hard-drive info via DiscWizard by Seagate
    by zebaztianz
    4 Replies
    Last post by Harpreet Singh Khandiyal
      • Microsoft Office 2003 "word" not working prperly after copying transferring hard-drive info via DiscWizard by Seagate. I got a new SATA Seagate hard-drive and used their DiscWizard program to copy/transfer all the entire "OS" files. PROBLEM Windows Office 2003: when opening office 11 . . . the program trys to 'install' itself again and giving the message "sour
  • Exception has been thrown by the target of an invocation
    by vvstenley
    0 Replies
    Last post by vvstenley
      • Hi, I have been working on a Dektop Application developed in .Net. There is a print option in this application. When i click the print option using Microsoft Office Document Image Writer it opens the Microsoft Office Document Imaging interface and i can see the content to be printed. Now the problem is when i try to close the Microsoft Document Image Writer interface or i try to browse any
  • When I change the color of a letter, the color of the rest of the letters changes too.
    by Lady Excel
    0 Replies
    Last post by Lady Excel
      • Hi In the active cell I have this: The _hite _one is _uried _ehind the _ardrobe I have three buttos (button B; button V and button W) to put one letter each time I clic one button. When I clic one button, it fills the first dash with the letter of the button (b, v or w) and then I call this code to check if the clicked letter is ok or not. When I clic again, it fills the sec
  • Windows Authentication for custom built application
    by Highflier64
    1 Replies
    Last post by Navajo
      • Hi all, I have this application that I am building using Access with an SQL server Backend (adp). What I want is to use the windows user authentication mode to give users access to application. I know ther are different ways to achive user acces like creating a table and assigining user names and passwords. What I am trying to do is to take the windows user name, which I have achieved and th
  • Outputting to a Listbox
    by UniRyan
    7 Replies
    Last post by Andy Pope
      • Hi; I have a list of data, and need for values outside a lower and upper bound to be flagged up to the user. I was thinking of outputting to a listbox, but cant get the code to work. I was wondering if anyone had any ideas for possible code, or a better way of outputting to the user. Ryan