Microsoft ISV

Page 74




  • Topics
    Replies
    Last post
  • DoCmd.OpenReport for report based on a query
    by starspike
    2 Replies
    Last post by starspike
      • I've used the DoCmd.OPenReport with the WHERE-clause for some time now. My reports where all based upon a table in my database. But now I have a report that's not based on a table but on a query. The problem is that my report opens, but it just doens't seem to hold my WHERE-clause in account. For example: I have two (linked) tables: Locations (two fields: LocationID & LocationName) Transaction
  • Function InStr with Japanese Windows: strange return value
    by gcsman
    2 Replies
    Last post by gcsman
      • Dear all, I have found a strange behavior of VBA InStr function in Japanese language in Japanese Windows. (WinXP Pro SP2, Office 2003 Pro) InStr function: InStr ([ start , ] string1 , string2 [, compare ]) While a Japanese Katakana character with "tenten" or "maru" appears in a string1, InStr(string1, string2) returns a wrong result: sTest="
  • 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
  • Adding alt text, name, and hyperlink to pasted images from another worksheet.
    by jrc1378
    5 Replies
    Last post by Andy Pope
      • I have a workbook with the following sheets: Display (Sheet1) Data (Sheet2) Images (Sheet4) My sub is built to read reference data from Data! that tells it to copy a certain picture from Images! and paste it onto Display! at a certain location. It also grabs a label name from Data! and puts it to the left of the image just pasted. All of this works fine, but I also need
  • calling sub within function. works fine as sub, but not in function
    by pacificwaters
    11 Replies
    Last post by pacificwaters
      • Using VB 6.3. Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work. But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
  • Data Fields from e-mail templates?
    by NemanjaTheLost
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi everyone, i'm writing an outlook app that connects to the crm database and extracts custom entity information. i need help however, with determining how data fields in e-mail templates are extracted by crm i see that the info is stored as xsl code in the database and that there's a select field which gets queried and the data extracted. and the format of that is "view_name/fieldname
  • Problem with checkbox
    by RuizJ
    11 Replies
    Last post by Sumerdai
      • Hi. We are having a weird problem with the checkbox control. We are using an access project (.adp) to connect to a SQL Server 2000 database and the visual basic editor that comes with Access to create the form, macros and reports that the system runs. We don't use third party tools and its purely just the default settings that MSAccess gives We use checkboxes in the project forms linked to fie
  • WER and file version differentiation
    by Joel Stein
    3 Replies
    Last post by Joel Stein
      • When mapping files against version numbers, does WER (and the watson servers) compare all four version_info fields For example, I have mapped version 4 of my application, for example, MyApp.exe, which has version 4.0.6192.0. As bug fixes are done for this application, the last integer gets bumped...now we are up to 4.0.6192.27. Do I need to remap the application, and/or upload a new map
  • New Combo Box problem
    by Techgrrl
    2 Replies
    Last post by Vamsi025
      • Well, here I am again.... Problem this time is, here is my code: Private Sub ComboBox1_Change() ComboBox1.AddItem "No leaks detected" ComboBox1.AddItem "No leakage or adverse damage detected" ComboBox1.AddItem "The entire contents of the packaging were retained" End Sub With just these 3 entries listed to add in the cbo, It is duplicating, o
  • LCS Snap-in opens empty (trial)
    by Evaldo Santos
    0 Replies
    Last post by Evaldo Santos
      • Hello nice people out there, I am getting used with LCS, so i decided to create a lab environment and deployed a TRIAL of LCS 2005 SP2 Standard Edition. The communication among the users works great. Users can chat with each other, share desktop... no problems. The only and BIGGEST problem am facing is that the LCS 2005 Snap-in, opens empty. I can in fact configure nothing. Al
  • Setting ChartObjects Properties throws Run-time Error '1004'
    by Kigol
    3 Replies
    Last post by Jon Peltier
      • I have been trying to figure out what is wrong with this macro for a month now. Can someone please help me, I give up I have columns of data ranging from A to EK and 352 rows of data for each. Each column will be a new dataset and therefore a new chart. Each set of 5 columns is a group so after I go through 5, I offset the output column for the charts by 7 and start a new group. It throws rea
  • Help with SQL in Access
    by ADG
    0 Replies
    Last post by ADG
      • Hi all, I have a table which stores start and end date for financial periods, and a transaction table. I cannot link the dates in a query as there is no field to join on. In my database I have written a function which looks up the period description. All is well until I need to use the query with Crystal reports. Crystal reports does not allow me to use the query because of the function. I
  • some mp3 play some others don't
    by moisesvallejos
    5 Replies
    Last post by moisesvallejos
      • I have a powerpoint presentation and inserting an mp3 files to play across the slide, but for some reason my mp3 file would not play at all. that mp3 was created by a windos media player and will not play in powerpoint at all, but play just fine in my windows media player. if I create the file with soundforge then that mp3 will play fine in powerpoint. can anybody tell me, what I'm doing wrong
  • Making a MSSQL Query within Word?
    by Haoest
    1 Replies
    Last post by Shlizar Axis
      • Hi, I am new to VBA. I am looking to make a query to MSSQL server for raw data, then I would apply format to the data. How would I make a query Is there any good tutorial sites on the web
  • How to configure CER with no dialog?
    by John Brown
    14 Replies
    Last post by Claus Brod
      • I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
  • OEM and Vista Tendencies
    by Starcondor
    0 Replies
    Last post by Starcondor
      • We've ISV company with 2 products development in VB6. We want to migrate this applications to .Net Framework 2.0, but we are planning this migration for two years. We need to know, what is the tendency for latinamerica (Especially for Mexico) to the OEM's, with the system operative of Windows Vista version. A according to the strategy of Microsoft, What version of Windows Vista is going to come in
  • 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
  • About importing access tables
    by Drek01
    1 Replies
    Last post by Drek01
      • hi its sounds so simple yet couldnot get it right. i am trying to import access tables into( browsing access database in hard drive and placing in list box)sql server database( my back end) and i used the code as below. it thorws an error saying " the expression you entered is wrong data type" i know the refrence is correct and database is access. so can anybody help
  • Dynamically add controls with events at runtime
    by LSF
    6 Replies
    Last post by Anonymous3461
      • Hello, I want to add new buttons to an existing userform at runtime and link event handler to them so that the buttons do something. I've tried several ways that I've found online and managed to create the button and to programmatically add the code for the click event but when i click the button nothing happens. The button and click event sub code is created fine. I have adde
  • Macro to add jpg to header of spreadsheet
    by GB Allan
    4 Replies
    Last post by GB Allan
      • Hi, I have a macro which formats a spreadsheet and adds a pic to the header. It works fine; but the problem is that it uses a specific path to locate the image file. If someone else wants to use the macro on their PC, I have to "tweak" the code by changing it to their file path, so the macro will locate the image file. Is there code I can use that will find the image, as long a
  • 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
  • Master Detail in MS Access
    by Paul.Prasanta
    0 Replies
    Last post by Paul.Prasanta
      • Hello Frnds, Can you please help me regarding the following problem I am having one .mdb file, which contains only tables and queries, and another .mdb file, which contains only forms. Also I have two tables with one-to-many relationship. Student ======= StudentID StudentName Marks ========== StudentID Subject Marks
  • Bundling OA2007 Express with our product
    by Kathleen_H
    1 Replies
    Last post by MS ISV Buddy Team
      • Our company is interested in bundling a free Microsoft product (Office Accounting Express) with our solution. This means that we will include a copy of OA2007 Express in our installer. Is this possible Iif so, is there any website/resources you can recommend for me to get more information about this process I understand that since OA2007 Express is free, it is not part of the ISV licensing p
  • 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
  • Inserting text into a word document
    by jdc
    1 Replies
    Last post by jdc
      • Hello, I am using a VBA macro in MS Excel to create a Word document based on the content of the Excel spreadsheet. The macro consistently inserts text at the end of the Word document, but it varies the style associated with the text based on the information coming from the Excel spreadsheet. The code that I am using is something like: While (LEN(TRIM$(Sheet.Cell(currentRow, curren