Microsoft ISV

Page 91




  • Topics
    Replies
    Last post
  • How to override windows settings using macros in excel-urgent help
    by arunnc84
    3 Replies
    Last post by arunnc84
      • Hi guys, i had written a macro to get a date value and convert it to the date format which i need using the below code. date = Format(tempworksheet.Cells(1, 1).Value, "yyyy-mmm-dd"). it is getting converted fine when the regional language is US(English).When i change the language to czech it is not getting converted fine.The month is taken as date and date as month i.e if i enter 06/05/2
  • aggregate functions: problem with SELECT SUM()
    by Maximus
    4 Replies
    Last post by Cringing Dragon
      • Hi there, I wonder why the function below returns 0 (it should return 4335) * the conn to the db is ok (this function works with diff parameters, it has somthing to do with the SUM) * I check the SQL code on the db - and the return result is not 0 Code Snippet Function test3() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row Set objDB = DBConnect()
  • How to Get Position of Scribble line's Points?
    by Sstar
    4 Replies
    Last post by Sstar
      • I have scribble line object in my Ms Word document. Shape.Type = msoFreeform Now I want to get position of the controls points and change it slightly. How can I get the controls points' position in the first place. I noticed that Shape.ShapeNodes.SetPosition ( index, x, y) helped me to set position of each node. However, no ShapeNodes.GetPosition functio
  • 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
  • Out of Memory
    by James Simm
    4 Replies
    Last post by Jamie Bates
      • Hi there, I'm working with an Excel application, and I've written a .Net C# wrapper to it, to allow me to interact with an Oracle DB. Whenever I run the following code, I get the error "Out of Memory": Code Snippet Public Function Create(ByVal marketID As Long, ByVal ws As Worksheet) as Boolean Dim colDetails As Collection Dim xlName As Excel.Name Dim iRow%, iRow1% Dim iCol%
  • code for binary to decimal conversion in access vba
    by Anonymous555927
    0 Replies
    Last post by Anonymous555927
      • Help... I need to convert a string of binary numbers to decimal using vba code. Tried the cdec function in access but no good.
  • Does Winqual accept WER reports from Vista systems?
    by Claus Brod
    14 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
  • Obtain Unique Work Units via SQL
    by AlDeb
    14 Replies
    Last post by AlDeb
      • Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals. I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits. In the example below on on
  • A question from a beginner...
    by meisaka
    6 Replies
    Last post by meisaka
      • Hi all: I am new to the programming world, and I am interested in learning VBA. So, please provide some tips where should I start Thanks in advance.
  • Querydef Conundrum
    by Fred Morstatter
    0 Replies
    Last post by Fred Morstatter
      • I have a QueryDef Object that executes a stored procedure on SQL Server. My problem is that I cannot get the QueryDef to see the following Stored Procedure as an action query, rather than a select query: Insert into TempTable Select * from myTable; This works just great out on SQL Server, but when I run it from within access I get the following error: Runtime error '3065':
  • referenced memory error
    by rham
    2 Replies
    Last post by rham
      • hello people. I have an error in my computer that I don't know how to fix. IT says instruction at "0x269e7875" referenced memory at "0x269e7875". The memory cannot be "read". click ok to terminate program.
  • Sum of columns
    by Sreeja561936
    1 Replies
    Last post by Keithyboy1
      • hi, I want to get the sum of a perticular column.. however the column range may differ .. so first i need to check the no. of rec in the column and then add them .... pls help
  • SharePoint 2007 Zone Tab Work Around?
    by Hummell
    0 Replies
    Last post by Hummell
      • Hey everybod, i'm totally noob here, I know. I've got a question that i'm hoping one of you might be able to assist me with. My company is in the process of migrating from the MOSS 2003 platform over to MOSS 2007. I think it's fantatstic because of the additional functionallity offered in MOSS 2007. However, I do have one MAJOR concern. Currently, I am responsible for reporting on our opera
  • Cannot Find Library
    by HowDoIComeUpWithAUniqueName50
    8 Replies
    Last post by HowDoIComeUpWithAUniqueName50
      • I developed an application in VBA for office 2003. I tested and sent it to a client. Works fine on my machine but compiling or running it on their machine give the error "Cannot Find Library". It then highlights the function LCase$. I tried using LCase$ in the immediate window and it gives me the same error. I open the object browser (F2) and browse VBA. The String library shows as does
  • Saving a pic
    by Edday
    7 Replies
    Last post by Andy Pope
      • hey i really need help with this, i have posted in tons of forums and the descussion groups, no replies! gar lol, well i have this macro in excel 2003 and it has a userform and there are a few elements (3 pictures, 3 text boxes) that get modified during the macro then i need to kinda merge them and save it as one picture, can a macro do that any help would be great thx
  • Microsoft Office Document Imaging Printer Missing in Office 2007 (RFP) (86)
    by rjo2
    11 Replies
    Last post by andria72
      • Can anyone tell me how to install Microsoft Office Document Imaging Printer in Office 2007 (RFP). Although the Imaging program installs, the Printer does not, and the Microsoft Office 2007 Professional (86) Installer say that it is not an available feature.
  • How to copy combobox value to active cell in excel worksheet Automaticaly vba
    by abkarino
    5 Replies
    Last post by abkarino
      • Thanks for help . I Make a userform with combobox and make the row source but How do I get the highlight value from my combobox to active cell in excel worksheet automatically. Using Excel 2003. Pls.help me thanks
  • run-time error '1004' Method 'Range' of object '_Global' failed wen using refedit
    by MarkH001
    1 Replies
    Last post by Andy Pope
      • I have looked around the web and cannot find a solution .. hope somebody can help.. I consistantly get run-time error '1004' Method 'Range' of object '_Global' failed when I hit the Range command. The refedit contanis text somthing like (select a range of cells with my mouse) 'Sheet1'!R5C2:R15C2 But I cannot turn that into useable information. My code is launched from a command bu
  • Is there a way to abort during runtime
    by ke wenzel
    5 Replies
    Last post by JoAnNaT
      • Hi, If I am running a VBA program in MS Access 2003 that has a programming error such as an infinite loop, is there a way to abort the program without killing Access from the task manager (and losing any unsaved changes) KW
  • column headings in a combobox
    by CaRecycler
    2 Replies
    Last post by CaRecycler
      • I have a VBA application that fills a combo box from an array and I'd like to display column headings as well. By using columnheads = true I can reveal the headings but getting a value into that heading space is proving tiresome. Any ideas
  • Clearing a manually created indent for a paragraph
    by kkrishna
    3 Replies
    Last post by Andy Pope
      • I am testing the process of removing indents from headings. I created a manual tab indent (pressed Tab and created an indent for the heading text). Now I want to remove this indent by code. I tried the following: oPara.Outdent oPara.TabIndent(-1) oPara.TabStops.ClearAll The above codes were tried individually and collectively. I was not able to clear the indent created. Ho
  • Compatibility Issue Excel 2000 and Excel 2003
    by rcash864
    11 Replies
    Last post by Jon Peltier
      • I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I liv
  • 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
  • Help to convert file (delimited)
    by DBrooks
    2 Replies
    Last post by magicalclick
      • I have an application that produces a comma delimited text file (that¡¯s the only option). I have another application that requires this file to be in tab delimited format. My staff does not know how to do this automatically (through program). Is it possible to write a vb script to automatically convert the file from comma delimited to tab delimited Would this be an easy task, or woul
  • Macro picture question
    by dblakely
    2 Replies
    Last post by JoshZ
      • I had written a macro (V11) that would strip out pictures from a vendor's price sheet and perform other cleanup functions. Now, it leaves the pics in when I run it in V12! Is there some coding that will allow me to a) select a pic in each sheet in a workbook and b) delete it I've been searching around and cannot come up with a solution. Thanks in advance. -Frustrated If y