Answer Questions

• coronaride VB Script Crashes Access When Exporting to Excel

  I am trying to solve a minor problem for a small school running Access 2000 on a network. The program runs well with several forms and reports. The problem is that one of the reports is exported to Excel. This works fine except when the database is moved off the network, the export process either produces an error message or crashes Access. The database filename is AA92603.MDB. When it is copied to the C: drive on a computer off th ...Show All

• gpalmer43 Question reg BeforeDoubleClick event in Excel

  A user doubleclicks in a cell and if the cell contains a certain value, i want to move the user to another cell. When you doubleclick you enter the cell and can type a value to the cell. Tried to use activecell but it seems when in 'typing mode' you can't move from that cell unless user hits ENTER or clicks another cell. Can this be done in code Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)    If ...Show All

• M. Aamir Malik Access and VBA application in the mdb file

  Hello, We have an old software running on a touch screen computer. The software uses DAO for operations on a .mdb database file. It connects to the database before each transaction and disconnects after that. There is another program writen in VBA, runs in the .mdb file. Some people accesses that program by openning the .mdb file stored on this touch screen computer from a remote computer. As soon as someone opens the .mdb file, MS Access locks ...Show All

• j_o_h_a_n_n_e_s checking for existence of a form

  From a button click event on a form ("FormA"), another form ("FormB") is opened. In the onload event of FormB there's a reference back to FormA. This is fine, except if FormB is opened directly from Access. When that happens, we get Error 2450 ("...can't find the form referred to in a macro or Visual Basic code"). To avoid the error, I want to add code to FormB to prohibit opening it except in the context of Form ...Show All

• StephenT Thanks Buddy

  Started by bgmajor at 03-27-2005 4:05 PM. Topic has 0 replies. 03-27-2005, 4:05 PM bgmajor Joined on 03-27-2005 Posts 1 Thanks Buddy Just wanted to give credit to my Buddy, Howie.  He has contacted me and I've  contacted him so the "buddy system" is great for me.   Regards Bernie ...Show All

• Ashirwad Per-user connections in Business Scorecard Manager

  Hi, Have implemented stricter security around A.S (have removed the Everyone from roles and have added specific users to have access to A.S) When I go to BSM and try to edit / test the connection to the existing datasource, it does not return anything. Found a website that said it might be an option the change the web.config files and set ConnectionPerUser = TRUE, where it's currently ConnectionPerUser = FALSE. Now, sharepoint's brea ...Show All

• J J Dialog Box, Searching for keywords in an Excel Workbook

  Good morning, afternoon, evening... I need to create a little macro in an Excel workbook, that woud allow the user to type a keyword or a phrase, and check if this phrase or keyword exists within the same workbook or another (I guess I would just need to change the path of the work book). The rule is the following: - If the text entered is in one of the cells of Column A of each worksheet, the returned result will be the content of each ...Show All

• JVidal Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Chris Tacke webservice toolkit and complex types

  Hello I've created a .NET webservice that will return an array of complex type like: public class User{   string FirstName   string LastName } [WebMethod] public User[] FindUsers(string lastname){     User[] user = new User[10];     ....     return user;  } When i add a reference to the webservice using the toolkit addin, there's no proxy class created for the User Class. What should ...Show All

• chf1 How long this forum exists?

  Hi everyone, My company is trying to integrate VBA into our application. I had some contacts with Summit software ( Microsoft's partner for VBA licensing) some years (2-3) ago. Because we didn't finish our application yet and we're still in process of developing and testing we didn't purchase a license of VBA, but we're going to do it as soon as we finish. The person from Summit software who had contact with me, sent me VBA 6.2 SDK. But I know ...Show All

• Nathan from VBA to C#

  Hi! How I can get value of VBA -variable from C# Or How I can run C#-method from VBA Sorry my english. Per one of our support engineers: Based on my understanding, our buddy wants to have cross language interoperation. He wants to call VBA in C# and call C# in VBA as well. Here’s my update. 1.        How to call VBA in C#. ‘Microsoft Script Control 1.0’ component is ...Show All

• kissinger VBA Visio 2002 and OpenEx

  Has anybody else experienced that the flag argument to the Documents.OpenEx method have no effect in Visio 2002 I try : Call Documents.OpenEx(FileName:=MyFileName, Flags:=vizOpenDontList + vizOpenMinimized) But I see that the Visio document opens maximized and it also appears in the history list. What am I doing wrong (I see that the Object Browser calls the argument Flags , while the help file calls it openFlags ) Thanks in adv ...Show All

• KeithMescha opc

  I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it When i try add an Opc group, i get te following error message: Opc Server add group failed with exception: Unable to cast object of type 'OpcAutomation.OpcServerClass' to type 'OPCAutoma ...Show All

• JBJBJB Office 10 \ winword.exe runtime error

  I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe. Thank Alan It's very helpful THANK YOU ~ ...Show All

• EricA_MSFT About Error:"Unable to Set Visible Property PivotItem class" ----- Workaround does not work

  I find the workaround suggestion in following topic does not work. My workaround suggestion is: Setting the sorting of the pivot field to "Manual" before setting its pivot items visible. I would like Microsoft engineer to confirm my workaround suggestion. With ActiveSheet.PivotTables("PivotTable1").PivotFields("field1") call .AutoSort(xlManual,"field1") .PivotItems(" ...Show All