Microsoft ISV

Page 188




  • Topics
    Replies
    Last post
  • Error 380: Invalid property value:Help Me Please
    by OS*Bomzer
    1 Replies
    Last post by extremeb
      • Im working on some coding for an assignment i was given and i neede help as fast as possible. I have been recieving an error message that reads as follows: Run-time error: "380" Could not set the Value property: Invalid property value Ive used F8 in attempt to locate the problem and i have highlighted where i believe the problem is in the coding below: Dim Row As Inte
  • 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
  • Is there a better way to debug.
    by SHolst22
    2 Replies
    Last post by Andy Pope
      • I learnt all of my programming in Java and used to use the command prompt/debug window extensively to print information out to. I could use this to check flow and determine when things were executed, the order and more information about the workings of the code. In VB I have been using Msgbox along with the Str() command. This is rather intrusive to the operation of the system. It also ma
  • Display a value in a looping status
    by Victor_TanTW
    1 Replies
    Last post by Jade_Emeperor
      • Hello. I am working on a program that requires me to generate a status of the program I am writing. Up to now I can display every string values out onto the txtDisplayText box but except that last one which the value was generated from the serial port Code Snippet Dim sRx_Buffer As String Dim sRx_Msg As String commSerial.Output = stringValue sRx_Buffer = commSer
  • Excel Macro
    by ramkshetty
    0 Replies
    Last post by ramkshetty
      • Help needed for the code in excel Marro... I have a backend excel file in LAN server, which acts as main database... and n numbers of fronend excel file with n numbers of users...... I have written a code where data will be submitted from frontend to backend in a click of a button.... I want to check if the backend excel file is open somewhere/anywhere before executi
  • Subscript out of range with a simple sql :-( [newbie to VBA]
    by Maximus
    14 Replies
    Last post by Andy Pope
      • Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers! Code Snippet Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
  • VB code in Access forms
    by CatherineS
    1 Replies
    Last post by Bruno Yu - MSFT
      • Hi, i'm a beginner in the VB code world but enjoy making things happen in the rare instances that they do! I'd really like some VB code / help for the following: I 'm designing a database with user input forms and am stuck on how to use VB code to make it do the things i want it to... I want code to do the following: For each new record i only want the parent form to be acces
  • Run-time error '13': Type Mismatch
    by whateveritis
    2 Replies
    Last post by whateveritis
      • i always get this error when i try to run...does anyone know what's the problem Code Snippet Option Explicit Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "R
  • ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
    by Claus Brod
    12 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
  • Access Data Project, form bound to Sproc, need to update, etc
    by Computermike
    2 Replies
    Last post by JKnow
      • I have an Access Data Project. SQL Server backend, access forms. I have a form bound to a stored procedure. The storede procedure is based on two tables. The form needs to update and delete records in one of the tables. I set the Unique Table property to the table I need updated. When I try to update a record I get the error'This recordset is not updateable" It worked fine when the
  • Conditional Formatting Problem/Bug?
    by FaV1105
    8 Replies
    Last post by FaV1105
      • This is my first time in a forum. I have mostly found all the answers I could but I can't seem to find the answer for this: I don't know if this is a bug in excel or if I am doing something wrong. I start a new Excel application from another workbook and apply a conditional format that uses an array formula for its condition (I have read that conditional formatting always formulates
  • Creating new table in Access 2003
    by Tantani
    2 Replies
    Last post by Tantani
      • Dear, I would like to pick up few rows from existing table in Access 2003 and put them into new table via VBA. Any solution Thank you in advance!
  • Justifying text in message box
    by une
    2 Replies
    Last post by une
      • Is there a simple way to justify text in a messgae box Consdier the following text; The number of lions = 23 The number of tigers = 2 The number of monkeys = 34 I would like the words and the equals signs to be left justified in the message box and I would like to right justify everything to the right of this. This would mean the numbers would all be right justified and line up
  • Problem with events
    by Keithyboy1
    3 Replies
    Last post by Keithyboy1
      • I have created a customised control in a class module, which works in a similar way to a combo box. It consists of a label, on which I have a button. When the button is clicked, a frame control appears below in a similar fashion to a combo drop down pane, on which I have various check boxes which a user can check or uncheck as required. The button click event basically sets the visible property of
  • 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
  • CRM 3.0 Error: Subreport could not be shown
    by RSorenson
    2 Replies
    Last post by AnonAG
      • I have a user that is getting the error "Error: Subreport could not be shown" when doing a report for a quote. She can do a report for an order but just not for the quote. I tried logging her in with different computer and get the same result so I think it is at the server level. Please give me some direction on what to do next. Thanks
  • sending emails from MS Word with variable subject line
    by gve2002
    9 Replies
    Last post by Andy_F
      • Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code (    .Subject = "New subject"   ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
  • Easy msgbox Query
    by jaxgev
    8 Replies
    Last post by Andy Pope
      • Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
  • ThreadHijacker and WER report
    by DHON
    2 Replies
    Last post by DHON
      • Hi, In my application I introduced AV thru code and getting a proper report. But, when I introduce AV using ThreadHijacker, GetModuleHandleExW() is unable to find the module handle. Report looks like as shown below. Problem Event Name: APPCRASH Application Name: Appln.exe Application Version: 4.5.0.0 Application Timestamp: 46b0270c Fault Module Name: unknown
  • How to turn OFF Simple File Sharing via Policy Editor in Server 2003
    by TheTom
    2 Replies
    Last post by 1222256
      • We are in the process of rolling out Sophos AV. One requirement is that you must turn off Simple File Sharing on clients (XP Pro). As we have 100 desktops to deal with, we'd like to do this via Policy Editor. I can NOT find any entry that will accomplish this in the editor. Any help out there Thanks! TheTom
  • update cell value using loop
    by Alen cappelletti
    1 Replies
    Last post by Spidermans_DarkSide - MSP, VSI
      • Hi, I try to develop this script but now I have a brake. What I must do I got an array of column like C, E, F, T,... and I must update all cell setting above everyone the char '. Example: my cell have the value of sun...I must update like 'sum. This for a problem of import values into integration services of SQL server 2005 (SSIS). But the loop must be run untill the last
  • Automating PowerPoint
    by Jenise
    4 Replies
    Last post by Andy Pope
      • I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday. Can you please suggest how I can automically execute my vba code to run thank You!
  • Using Autofilter in VBA with a range of criteria
    by jabodaddy
    3 Replies
    Last post by Joe Dawson
      • I have working code to autofilter the list I'm interested in for a single criterion in several fields. However, I can't find anything anywhere that shows how to write the object model fields so that I can use a date range. ie. I thought that I would be able to use RangeObject .AutoFilter(Field:=1, Criteria1 > Date1, Operator:=xlAnd, Criteria2 < Date2) I'm not sure that it's poss
  • Need Urgent Help from the good people
    by keilah
    3 Replies
    Last post by Rong-Chun Zhang - MSFT
      • Hi People I am having trouble with a excel spreadsheet. I am pulling in live data from a MS Access database, that has datatwo sets of portfolio IDs. In Col A the Portfolio Id are shown as individual (separated) in Col (say) G, the Same IDs are conbined (as shown below) for example: ColA ColG Barclays1 Barclays 1+2 (shown as) Barc
  • 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