Answer Questions

• sibot13 Optimise VBA for Multi-Processors

  How do I tell my VBA it is allowed to do several things at once I am moving my project to the server, which has 4 CPUs. I know that sections of my code have no interaction with each other, and do not work with the same cell ranges. Imagine my code is as such: Main Routine Call Task 1 Call Task 2 Call Task 3 End This is programmed in linear code, so I know that it won't start Task 2 until it has finished Task 1. I need some way of te ...Show All

• Zeon219 BSM with SSRS(2005) on a different box

  Could anybody help provide some information about installing BSM with SSRS 2005 My installation needs to have SSRS running on a different box than the BSM server. There are 2 issues involved here: The BSM Server.msi by default looks for Reporting Services 2000. But I need to have the complete installation based on SQ ...Show All

• neutroncore Adding minimize button to userform in design mode?

  Hey Having terrible trouble trying to get the minimize button displaying on my userform. This should be relatively simple but i can not get it no matter what i try! I got this of Google: Visual Basic forms can be made non-sizable by setting the borderstyle property to 0, 1, 3 or 4. However, that also means that the user cannot minimize the form to the taskbar. I only have the option to choose between 0 & 1. Does anyone know of any w ...Show All

• sanishcp How to build this??

  I'm VBA beginner programmer. I'd like to execute a query in Microsoft Access and then save the result in an excel file with a given name in a given sheet. Is it possible How Running this in Access always put records in A1 cell. strSQL = "SELECT * INTO [Excel 8.0;Database=C:\book1.xls].[Sheet1] FROM Employee" CurrentDb.Execute strSQL Read records in DAO.Recordset in Excel and Range.CopyFromRecordSet can ...Show All

• Sime24 How do you find out the Windows User Name from VBA

  We log onto our network with a three letter user name e.g. ADG. Can I return the user name of the person opening my Access Database with VBA I want to customise the options available to the user without using the security features built into Access. This will provide you with the information you desire. I use it often in the default value of a field. (Environ$("Username")) ...Show All

• Jamie MacLennan ListParagraphs collection in table

  When I run this code on a simple doc containing bullet list paras, some of which are in a table and some not, only the list paras outside the table are found. The first red line counts only list paras outside the table. The second count (in a table cell with a list) finds no list paras. Any ideas how I can rectfy this Cheers, Mark If vTab.Cell(1, gReqIdCol).Range.Characters.Count > 2 Then temp = Application.ActiveWindow.Do ...Show All

• freda123 Business Score Card Accelerator Server

  Can anyone assist with a deployment architecture recommendation for Business Score Card Accelerator Server I have a deployed sharepoint server, connecting to a 2005 instance. But when trying to install BSCA on either box, the installation fails because it is looking for a local instance of Sql server to be installed on the sharepoint server. Hi, Actually, your best bet would be to post this question to the BSM newsgroup as t ...Show All

• edallica VBA eBook

  Apparently, there was a free eBook on VBA available a short while ago. Can someone point me where to download it Thanks, Antonio http://msdn.microsoft.com/archive/default.asp url=/archive/en-us/office97/html/web/FULLTOC.asp It's for Office 97 but still worthwhile reading if your using a newer version. Derek, That is very helpful. Thank you again. I could not find for ...Show All

• jradi programming changing of property

  1. as i know it's possible programming to the Visual Basic Editor. i.e. add module and procedure through the VBE interface. is it possible to change property of UserForm through the VBE interface i'd like to change property of textboxes (checkboxes) during develompent of code. 2. in fact i've got following task: there is a MultiPage with 4 Pages. each page has 15 controls (textboxes, checkboxes, labels, listbox). total 60 controls. users wil ...Show All

• Shalabh BIndlish Multithreading, Callback & VBA in PowerPoint 2003

  Hi, I'm currently trying to get to work a VBA application which uses an external DLL (which I program parallely). The DLL starts a separate worker thread which calls a previously registered VBA callback function. This works perfectly (e.g. I can do a MsgBox "I was called with argument " + str(arg)) but if I try to change a slide in my slide show, PowerPoint says that "Hyperlink ^0" doesn't exist and crashes. At the end of ...Show All

• Edimilson Simionato Form Requery

  I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD No sure this is the answer but try a ...Show All

• HallCrash accessing another program from Excel

  Hi How do I access another program from Excel What I'd like to do is click on a line in Excel with information about a journal and have Excel automatically go to another program, paste one of the fields from the line and send a search request. The other program is a Windows XP program. The other programs are library catalog client programs (not the actual library catalog program itself), one is used for acquisitions, ordering and paying fo ...Show All

• Subasree Data Monitoring Application...

  I have been developing a windows forms application that monitors and controls industrial processes(ie. temperature, humidity, flow). My app needs to dynamically display data to the user in a graphical format. I thought SVG was my answer. I have spent the last 6 month developing my app around the Adobe SVG active X control. It was perfect, I could directly manipulate the SVG dom, and it would automatically change the graphic on the screen. Well, ...Show All

• Michelotti21 Excel to PDF

  I want to ask if anyone knows the code to detect if Adobe Distiller is installed on the machine, using VB. I'm new at this. All I know I need to write codes to see if distiller exist. I have further questions: Does Distiller comes with Adobe Reader, or do you need to have Acrobat to have Distiller I'm not working with the server version of Distiller. Do I need a Printer driver that converts Excel spreadsheet to PostScript and then call Distil ...Show All

• Aidin Command Buttons

  Hello Friends.. There are 5 command buttons in a form... Each command button reads dat from serial port... My problem is...When we press a command button while it is been processing..mean while if the user presses other command button it should not function or activate...But I'm not able to do that... Please any one help me abt this... Bye suma You could also try locking or disableing the form ...Show All