Microsoft ISV

Page 13




  • Topics
    Replies
    Last post
  • compile error: invalid quaifier
    by CarlaCruz
    3 Replies
    Last post by CarlaCruz
      • Hi! I'm a portuguese school teacher that uses vb 6.0. The error mentioned occurs here **: Public Sub introduz() i = 0 Do While i <= 20 VF.Nr(i) = Val(InputBox("Introduza o numero de cliente", "Numero de cliente")) ** VF.NomeCliente(i) = InputBox("Introduza o nome do cliente", "Nome do cliente") If VF.NomeCliente(i) = ("XYZ") Then
  • more than character count.
    by M. Nicholas
    3 Replies
    Last post by M. Nicholas
      • We use several custom made templates in Word 2000. I need to write a VBA subroutine in each template that will fill a variable with a character count of the document when prompted by a button. Along with the normal (obvious) characters, I need to count such things as spaces, bold-on and bold-off, carriage return, tab, underline-on and underline-off, etc. I know that if you turn on al
  • opc
    by ksona
    14 Replies
    Last post by MartinBrasil
      • I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it
  • Stop Macro
    by djfNW
    0 Replies
    Last post by djfNW
      • I have an input form in Access. When the user is done entering in data, I run a script to check for blank fields. At the end of the script I want to put in a command to stop the macro that is running the code. Is there a way to do this I tried creating a new macro with the command StopAllMacros and then ran that macro from VBA but it didn't work.
  • FindNext returns "Nothing" when doing iterative lookups, though data to find is in the cells
    by damienm38
    5 Replies
    Last post by Andy Pope
      • Hello, I am implementing a lookup Method to find translation matches in XL tables. For example, if I call the Method: Translate("world") in the following cells: A | B -------------------------------------------------------------------------- hello world | bonjour le monde world | monde
  • Excel Checkbox - Multiple controls-only one may have value of true
    by suznal
    10 Replies
    Last post by suznal
      • I have checkboxes on a sheet of which, the value of only one may be true at a time. (By the way, I am not allowed to use option buttons on this workbook). I have figured out the basic code to use if there are only two checkboxes involved, but each instance I have involves a minimum of three and sometimes five checkboxes. The code I have works well (for a pair of checkboxes) provided I supply it
  • Auto fill on a form in Access
    by ACayouette
    2 Replies
    Last post by RhysDavies
      • I am done wracking my brain on this one, so if anyone has an answer I would be most grateful! I am trying to format a form in Access where users could check off a box and have an address auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. This would be similar to the "checkout" function on some
  • Access 2003 Workspaces
    by Toblerone
    7 Replies
    Last post by LCarato
      • Hi all, I have an app in which I need to create forms and controls on the fly (A form that designs itself from table data). That part i have solved and it works perfectly. The problem i'm faced with is not being able to create forms once the db is compiled and converted to .mde I have been reading about workspaces. My idea is to create a workspace and generate the forms in that. None of the forms
  • Windows Error Reporting - handling unanticipated errors
    by John Blight
    7 Replies
    Last post by John Blight
      • For Vista certification, is any handling of unanticipated errors prohibited (other than throwing them) Let's say an application has to process a large number of files. If an unanticipated error occurs when processing one of those files, I wouldn't want that to prevent the application from processing the rest of them. Could we report the error through WER, but also handle it
  • Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
    by remitdlo1944
    5 Replies
    Last post by bbenz3
      • I was working on another problem and reset my advanced options. After all my jpeg and gifs now are fuzzy when displaying in only internet explorer 7.0.5730.11 all other programs display normal.
  • WSS 3.0 "This stock feature has been retired."
    by bafadam
    14 Replies
    Last post by cis365
      • What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently. Anyone have any clue with this could possibly be referencing
  • Disable "Unprotect Document" button in "Tools/Options/Security" tab
    by VeeraMuthiah
    0 Replies
    Last post by VeeraMuthiah
      • Is it possible to disable "Unprotect Document" button in "Tools/Options/Security" tab of MS Word using VBA This button is available in only Word 2003 and higher. We are accessing and modifying documents in Java using JACOB. If the document is protected we are unprotecting the document and doing modifications. But if the document is protected using a password there is no wa
  • Newbie need help... Thank U.
    by &amp;#124;OREO&amp;#12
    4 Replies
    Last post by Cringing Dragon
      • Hi all, I'm new to VB and currently, I've to assist my mates with a project. Below is what's happenin. Hopefully the seniors could assist Thank U. Aim: To design a VBA form in Excel which will take 3 or more values off a .csv file, display it on the form, and then using the values to plot a graph. The steps I've taken so far in assistin. Steps: 1. Form created. 2. Buttons for a regular update imp
  • algorithms vba or c++
    by magellan90
    3 Replies
    Last post by magicalclick
      • i've been asked an opinion on number-crunching using algorithms - the question was whether c++ or vba was more adaptable and effective. i have used vba to construct algorithms in excel and have no technical knowledge of c++ to really evaluate the difference. essentially we're looking for conversion speed from mass data input. thanks for any response.
  • How to create a .zip file with VBA in WindowsXP without any third party software?
    by iopcj
    4 Replies
    Last post by Bruce Scherzinger
      • WindowsXP can open and create a zipped file. How to zip and unzip a file in VBA Thanks for ur help.
  • Powerpoint VBA check if shape at specific location on slide
    by Fishj
    1 Replies
    Last post by Peter Mo.
      • Hello I am a bit of a VBA begginer, and a complete powerpoint VBA novice. I am trying to write my first powerpoint macro and need a bit of assistance getting started. Can anyone tell me how i check if there is a shape at a certain location on a slide, and if there is, then do something (send slide to back) as well as get text in the shape A mroe full explanation is below.
  • CRM 3.0 Authentication Error
    by BabaFree
    0 Replies
    Last post by BabaFree
      • I'm using the CRM 3.0 Laptop client. It works fine while on the network, but when I synchronize with the "Go Offline" button, I get the following error the next time I try to access the information offline: Microsoft crm could not log you on to the system. Make sure your user record is enabled and that you have been assigned at least one security role. For more information, contac
  • About string split
    by YaelS
    3 Replies
    Last post by Andy Pope
      • Hi, I have this string: "C:\MyFile.doc#C:\MyFile.doc#" I want to get this: "C:\MyFile.doc" How strLink = Split(strLink, "#")(0) It's good Thank's
  • First Web Site Loading Problem
    by Ron Hall
    0 Replies
    Last post by Ron Hall
      • I just got done creating my first web site in VB.net 2005 Visual .net web site. When I published it, I found that I have to address it with www.(mywebsite).com/(mywebform).aspx because IE won't recognize an aspx file as the starting file. How do I create a Home.asp or Index.asp, etc. to allow clients to enter the website with just www.(mywebsite).com Also, I noticed that the pictures on the web s
  • need help appending an excel sheet
    by nasrudheen_k
    1 Replies
    Last post by ska67
      • hi im new to the programming world i have written a code to open an excel file and add certain items. the first cell in each row should be the date. i have done that with date function (date). i need some of details like name and serial number in that row i have done that also but the challenge is where i have to append if i entered todays date in cell a1 and other details in row b1 to g1
  • Word 2003 AutoOpen Macro doesn't run if Outlook 2003 is open.
    by aliank
    5 Replies
    Last post by bi-lya
      • Good day experts, I written a word template with AutoOpen macro in order to load an object that will update footnote of the word document when user save the document. It works well when outlook is not loaded. But once outlook is loaded, the AutoOpen macro did not run anymore. If I open the document without opening outlook first, then automacro is working fine. But if I open the Outlook and then o
  • How can I see the stack trace from the .mdmp file?
    by Vedratna
    14 Replies
    Last post by Vedratna
      • hi, everbody we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i
  • Subtract a date
    by F&amp;#38;&amp;#35;225
    6 Replies
    Last post by Fábio Nobre
      • Hi, I'm creating a aplication whith Visual Basic and I need to subtract dates, now I'm using a simple method: Subtract a Month: --------------------- If optmes.Value = True Then (DateValue(Now) - 30) & " " & TimeValue(Now) Subtract a Year: --------------------- If optano.Value = True Then (DateValue(Now) - 365) & " " & TimeValue(Now) But this met
  • Visual Basic in Excel - variable chart source data
    by jk2880
    1 Replies
    Last post by Andy Pope
      • I am attempting to create a macro that automatically creates charts for columns of data in a different sheet. I would like to replace the "hard coded" range property with a variable range(cells,cells) in order to cycle through several different columns of data. With the following line of code, I receive the error "Run-time error '1004': Method 'Cells' of object '_Global' f
  • VB vs. VBA
    by ram121
    1 Replies
    Last post by sjoo
      • Q1) What is the main difference between VB and VBA I want to be able to learn how to work more with Modules, which involves the VBA language (correct ). Q2) Does anyone have helpful resources or suggestions regarding this I currently have a VB book by Deitel and a Mastering MS Office Access 2003. Are there any other helpful rescources or suggestions