Microsoft ISV

Page 53




  • Topics
    Replies
    Last post
  • Migrate code from VBA to VBScript
    by Fra_Down
    0 Replies
    Last post by Fra_Down
      • I would like to migrate scripts written with VBA in a third party tool to scripts written with VBScript in another tool. Do you know a web site explaining the differences between these languages or a tool allowing to migrate from one language to other
  • Visual basic training
    by Judy40la
    2 Replies
    Last post by JohnWein
      • Hello, I am new to visual Basic we used it in our Access Database for work. Is there a training program that I could take online to learn it fairly quickly for Access I downloaded VB 2005 at home and would like to use it to learn the total concepts of VB for access. Can anyone point me in the right direction Judy
  • Debugging
    by une
    2 Replies
    Last post by une
      • I can watch the execution flow of code in VBA under MS Word 2002 using the F8 key. How do I take a step backwards I want to watch a small section of execution flow again without starting from the beginning.
  • VBA String manipulation problem.
    by OM
    2 Replies
    Last post by Andy Pope
      • (i orignially posted this message in the vb forum... but was told to post in here instead.) I'm trying to code for an Excel spreadsheet. Very new to VBA. I want to replace all comma characters with a newline character. And then get rid of all whitespaces. So far, I've got this: Worksheets("Summary").Cells(i - 4, 1).Value = Trim(Replace(StrConv(Worksheets(&
  • when to call Uniscribe api??
    by VNAHATA
    2 Replies
    Last post by VNAHATA
      • Hi, While reading GDI commands from an emf file,when should we be calling Uniscribe functions.Is it for every ExtTextOut command or just when we see the ETO_GLYPH_INDEX set in ExtTextOut.Is ETO_GLYPH_INDEX the only indication that the text'll contain complex scripts or with other options too,we may require to call Uniscribe Itemize function Please help. Regards, Vinay
  • Excel Macros Loop Help
    by Thundermocos
    3 Replies
    Last post by MyLady
      • I am trying to figure out how to create an Excel Macro that will loop through worksheets and stop running when there are no more worksheets. I need to collect data from each tab "worksheet", so I want it to collect the data move to the next worksheet, collect the data.. etc until there are no more worksheets and stop. Thanks
  • Using a formula as the default value in an inputbox (EXCEL)
    by OTG
    3 Replies
    Last post by Andy Pope
      • I currently have this: Code Snippet NewValue = InputBox("Please enter a new value for the cell:", "User input required", Range(ACell).Value) That works fine, except for cells in which there are formulae, where only the result of the formula is displayed. I want the user to be able to edit the formula using an input box. I've tried Code Snippet
  • Select/cut/insert
    by Bluzdude
    4 Replies
    Last post by Bluzdude
      • I need to select all rows in an Excel worksheet in which the value in cell "F" is not blank, cut each of those entire rows and insert them in another worksheet at row "4".
  • Hello!!! I want to know how to find a string in a Cell
    by JGttttt
    3 Replies
    Last post by JGttttt
      • I am Importing .csv file into a spreadsheet. There are certain text string values within a column and muliple rows. I need to check to see whether or not that value is there and then use that value to move data in other columns. I am running a Do Until loop that cycles through all the data on the sheet until a null value is found. I'm then running If then conditional statements that checks to see
  • Macro in excel
    by Paul Ked
    1 Replies
    Last post by bi-lya
      • Hi I could do with a bit help. I have created a macro in excel that is basically this; Sub auto_open() ThisWorkbook.Worksheets("Aftersales").OnEntry = "DidCellsChange" End Sub Sub DidCellsChange() Dim KeyCells As String Dim cells, tmpStr As String cells = range("A38").Text Here = ActiveCell.Address MyColumn = Mid(Here, In
  • Access 2007 and Vba
    by Anonymous_34857345
    0 Replies
    Last post by Anonymous_34857345
      • Hi I have a problem with Access 2007 and Vba I have a mask; in the mask there are 2 controls: a listbox and a textbox. The source of the Listbox is "Select cat_name from Category1" I would that at the event click of the listbox the source property of the textbox was: "Select cont from content where cat_nameFk = @cat_nameFk" @cat_nam
  • Office Communicator 2005 sign-in name, auto populate after install somehow?
    by markm75c
    14 Replies
    Last post by Mike@ALS
      • Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users prob
  • How to copy cell value from formula bar in VBA
    by Howard Reit
    1 Replies
    Last post by Sabaawy
      • Hi, I am trying to transfer Excel info into a web based form. For some reason a simple copy/paste does not work. The only way to move the data is highlight the entire selection in the formula bar and then copy. When I paste into the web form this works. How do I do this in VBA Appreciate any help on this Howard
  • 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
  • Calculation based on hidden text fields on WORD form
    by christy c
    3 Replies
    Last post by ke wenzel
      • MS Word 2003.... I have a few text fields on a Word form. When the user clicks on TEXT_1, A macro popups a UserForm for user to select data. When the UserForm is closed, I display the user's selection in TEXT_1 and store a numeric value, such as "10" in TEXT_2 field. TEXT_2 is a hidden field (via font). The user do that a few times -- click on TEXT_3 and store numeric value in hidden TEX
  • About FileCopy
    by YaelS
    1 Replies
    Last post by Peter Mo.
      • Hi, How can I do this: Code Snippet strFile = "myfile.doc" ' check if this this file exist in C:\MyDir ' if not copy this FileCopy strFile , "C:\MyDir\" & strFile Thank's, Yael
  • 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
  • ISV Software Requirements
    by jk_0321
    2 Replies
    Last post by cUtEpInKbUnNiEs
      • Hello all, Sorry I'm new here and was unable to find an answer to my questions using the search feature. Because Microsoft requires several MCPs to satisfy their non-ISV competancies, I need to take the ISV route to get Certified Partner status. If I was to go for the ISV Competancy, what kind of application are they expecting me to develop I read on the lionbridge site that games and of
  • Posting Excel File Online
    by kd24
    0 Replies
    Last post by kd24
      • I have an excel file with vba code and macros behind it. Is there any way to put the file online on a website so that the macros and vba can be run Thanks.
  • Access - VBA Script
    by phpx2pperl
    1 Replies
    Last post by mnptl
      • I have a sub form which needs 2 fields updated one is numeric and the other is text both are using text boxes as the control source. I have searched the web and my book references but stuck on getting the input from the user for these two fields and updating the input at my target table. One question is can I update my target table using the dynaset and form I used to build my resultant query You
  • Obtain formula value in VBA
    by DinnerPlates
    3 Replies
    Last post by Andy Pope
      • Hi all, I have created a macro (thanks once again to the help of Andy) which looks like this:
  • Excel Command Button - Hide multiple sheets based on IF statement
    by suznal
    9 Replies
    Last post by suznal
      • I have a sheet in a workbook that acts as a sort of table of contents. All of the sheets in the workbook are listed in a column and the column to the left of each worksheet name is either blank or contains an ¡®X¡¯ depending on whether the sheet was used on a particular occasion. I have a command button on the page that will hide a sheet if a particular cell is empty. Currently this only wor
  • using keyDown event to stop non-Hex input in Access form textbox
    by .ken.
    3 Replies
    Last post by .ken.
      • Trying to only allow hex input into a text box. I just started to learn visual basic a few days ago and it is all very neat how powerful it is. My code doesn't work, but any help would be appreciated. or any other ways of only allowing 0-F into a text box would work as well. Doesn't necessarily have to not allow G-Z into the box but needs to stop the program from running if it is entered.
  • Overflow (error 6)
    by une
    5 Replies
    Last post by Keithyboy1
      • I have code that executes fine 99% of the time. The other 1% I get an overflow error (error 6) that relates to the following line; startTime = Year(Now) * 365 * 24 * 3600 + Day(Now) * 24 * 3600 + Hour(Now) * 3600 + _ Minute(Now) * 60 + Second(Now) startTime is declared as a double; Dim startTime As Double The value of startTime at this line (according to debugger
  • A couple of questions regarding the Windows Error Reporting Program
    by Straightwaytech
    2 Replies
    Last post by Leighton
      • Hello, Recently I discovered that the Microsoft Windows Error Reporting program is open to all developers free of charge if two requirements (more or less were met). The first requirement was that upon signing up for the program, the candidate company must send a unique Verisign certificate that represent's their organization's identity (about $100). The second requirement was that the applic