Answer Questions

• MaximumBob autocomplete

  Hi all, I have a form with several combo boxes. I would like the users to be able to start typing in the field and it automatically completes the box. Can someone tell me how to get my form to autocomplete Thanks Hi, You can use AutoComplete* properties to accomplish this task. If you want to give your own list for suggestion use AutoCompleteCustomSource, You can also set mode either suggest or change by setting AutoCompleteMode, There are also few builtin Source you can set them by setting AutoCompleteSource. Now for example you add two values in collection of AutoCompleteCustomSource Saml and Martin and set AutoCompleteSource to CustomSource then when you type S it will suggest you Saml if your AutoCom ...Show All

• Neotech CRM 3.0 : Changed Contact view under customization but CRM do not reflect

  Changed contacts view in advanced find, lookup, active view, my active views under settings: customization but CRM did not reflect the changes anyone can help to resolve Thanks Hee Teck You need to publish any customisation that you make. For that whenever you are done with your customisation, normally you are on the Entity view screen. Just Click on Actions > Publish to publish the single entity customisations. Also when on the customisation entities list page, you may select one or multiple entities that you have customised and in the grid toolbar click on Publish. If you are not sure on what you have just customised or you have done several custimisations at once, Also when on the customisation e ...Show All

• BerndMei How to stop a never ending loop

  Hi, Is there a command to stop a executed function. It happends that I sometimes created loops that countious for ever. I have so far had to quit excel to make it stop. But I guess there some command to stop this process. Anyone that knows this Thanks in advance. \Jonas Thanks Derek, Ctrl + Break did it. Kind regards \Jonas Thanks for your replay. But it wasn't the problem. I meant if I execute a macro and it's, off course by mistake a never ending loop in that macro how can a stop that macro At the moment I'm using Ctrl+Alt+Delete to end Excel but I'm sure that it has to be a way to just stop the macro. In matlab for instance I think it's Ctrl+c. \Jonas I think Ctrl-Break does what your looking for.. ...Show All

• sangeetha shanmugam Move sharepoint web front-end

  Today we have a single farm sharepoint solution (Web, Search, Index & Jobb on the same server). We want to move the web front-end to a another server. Anyone know how to do this or where I can get help Thanks in advance Neisen, Did you ever figure out how to do this I would like to know how. ...Show All

• Confused..x append excel data to text file

  I am going to have multiple excel files feeding one text file (each file will only append one line of data). Any suggestions Thanks The data in your XL file can be in a cell, or an autoshape, or a chart etc. Because you did not specify where that data lives, I assume you have it in cells. To get the text from a cell using VBA you write something like this: ActiveWorkbook.Sheets(idxSheet).Cells(idxRow,idxColumn).Text ,where idxSheet - index of the sheet you have the data on idxRow - index of the Row idxColumn - index of the Column Another option is not to use VBA at all: if indeed the data you have is only on Excel cells, you can add the excel document as an ODBC provider and connect to it as to a regular databas ...Show All

• Prudhvidhar paste into next blank column

  hi.. i need a VBA code that can paste data column by column.. i have the code as below: If CheckBox1.Value = True Then Sheet7.Range("Time").Copy Destination:=Sheet4.Range("A2") End If If CheckBox2.Value = True Then Sheet7.Range("Input").Copy Destination:=Sheet4.Range("B2") End If If CheckBox3.Value = True Then Sheet7.Range("Output").Copy Destination:=Sheet4.Range("C2") End If If CheckBox4.Value = True Then Sheet7.Range("Cycle").Copy Destination:=Sheet4.Range("D2") End If this is an ideal case if i click all the check boxes and as a result the values will be pasted in sheet4 side by side. but what if i just check check boxes 1 and 3, how should i paste them next ...Show All

• kcdclan Updating text in a text box on an Excel Graph

  I am automating a spreadsheet, designed by someone else, which has 18 graphs on a worksheet. Most of these graphs have a text box on them which indicates the week commencing that the graph refers to. The text box appears to be a shape object on the chart. I want to loop through each chart on the sheet, then loop through each shape on the chart, and change the text if the shape is a text box. Can anyone put me on the right track, I did try using the macro recorder to get me started but this code does not work in my VBA module. Many thanks Duck Thing, just the job If the text you want to update is the title of the graph, it's pretty simple... here's a quick piece of ...Show All

• TomWardill Can you tell me why Int(1.4 * 100) = 139

  Can someone help me to find solution: Int(1.3 * 100) = 130 Int(1.4 * 100) = 139  (also  Int(1.38 to 1.49  * 100 ) ) Int(1.5 * 100) = 150 (VBA:Retail 6.0.874) Thanks in advace Haven't verify this. But I think if you declare the variable with proper type should save you from the problem. Try to avoid variant type if you can. Dim d as double d = 1.2 Debug.Print Int(d) Hi magicalclick , thank you for replay. It seems CInt() is not "totally fine". Try this: CInt(1.455 * 100) = 146 CInt(19.455 * 100) = 1945 Any ideas You can use Int() or Fix()function, they act as a truncation to the floati ...Show All

• SQL Novice how to connect two locations to better communication

  How to connect two locations to better communication We have offices at two locations, and i m looking for VBA (outlook) to connect two locations for updates, (more than email). Pls let me know your ideas.. ...Show All

• B M E Error handling problem

  Hi - i have an end of month routine that will run - however it brings up error 3021: no current record.  this occurs if the user presses the command button where they have not entered any activity that is greater than the 'datelastsubmitted' date because the form loads with the following code: Private Sub Form_Load() Me!officer.SetFocus officer.Value = loginname Me.submit.Enabled = False Dim rsdbase As Database Dim rstemp As Recordset Set rsdbase = CurrentDb Set rstemp = rsdbase.OpenRecordset("SELECT SUM(activityhours)AS [availablehours] FROM [qryavailablehours]WHERE [loginname] ='" & CStr(Me.officer.Value) & "'") With rstemp     .MoveFirst     Me.availablehours = Format(Nz(!availablehours, ...Show All

• lingga automatically saving word doc versions every 5mins

  Hi - I'm new to VBA and have no idea how to go about this. I can get as far as writing a macro that creates a Version of a specific Word document on command - but I also want it to automatically do this when the document is opened and then every 5 minutes until it is closed. Thanks for any help! does this save it as a separate doc I want to save separate copies of the document every 5 minutes (I know it sounds strange, but there's a good reason!). I thought saving versions would be better as it woud take up less space. Hello, Use the Application.OnTime method to schedule when your code should run. Here's the example from the help, runs Macro1 in 15 seconds time. ...Show All

• Will Merydith Excel VBA help file gives answers in German--but not always

  Help please! This is making me crazy! Some of the entries in my Excel VBA help file always show up in German rather than English, as I wish they would. Here's what I've tried to solve the problem: 1. Set Microsoft Office 2003 Language settings to US English 2. Deleted and reinstalled vbaxl10.chm and vbaxl10.aw 3. Asked a friend to send me his vbaxl10 files (which are all in English) and installed them 4. Removed the 1031, 1036, and 3082 folders from C:\Program Files\Microsoft Office\OFFICE11 (thus leaving only the 1033 folder None of this has worked. An example of one of the topics that is in German is "SendKeys statement (Visual Basic for Applications)" An example of one that shows up in English is "Sen ...Show All

• Bruno Kovačić Setting a global variable and referring to it from a private sub routine?

  Hi, I am basically wanting to improve my code and make it more user friendly and error proof! Ok, so currently its based around a single user form which toggles on and off from a set command buttons which allows the user to view the from and select certain buttons which automate a lot of the tasks necessary from within the workbook. I have a different amount of records/rows in it each month and I display a pop up msg box asking the user to input the number of employees to be processed each time they click a button. This is grand and works fine but is not very user friendly and if they put in too many it messes up the data! So I got some feedback from these forums a while back saying that I should redo it and instead of ask ...Show All

• Muhammad Saeed Iqbal Protecting formulas in cells

  Hello, Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten Thanks Chrstdvd Chrstdvd, this may be of interest to you. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1279113&SiteID=1 Check this out, you would be able to create your spreadsheet and use it with VB Express and the only way someone could erase your formulas would be if they were hackers. It would even prevent you from erasing what you don't want on accident. Well Andy, I mean that I have a macro that has code like this Range("H22") = "=Sum("A5:A16")". I ...Show All

• charlestek Problem with Connection Strings

  Hi All, I have an excel spreadsheet, which I want to use like a database table and access using ADO from another spreadsheet, but whenever I attempt to assign my connection string to the ActiveConnection property of my ADODB Recordset, I get the following error: Could not find installable ISAM. Below is the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Le09\kpl_biskra\personal_biskra\ksmith\Reporting\Weekly\Christmas Analysis\DataFile.xls;Extended Properties=Excel 8.0;HDR=Yes; Can anyone help Many thanks! Keith Just to add to this, it has something to do with the fact the SQL I'm passing in my previous post is a crosstab. If I pass a simple SELECT query, like tha ...Show All