25 Unanswered Topics
Remove Filter  | |
| | Hi, When I use the code below, the data is written to the detail section, but only shows in the design mode. How do I get the data to display on the report? Dim stDocName As String Dim db As Database Dim rs As Recordset Dim rs2 As Recordset Dim … |
| | Hello! I've been debugging this VBA program that computes the root of an equation using Newton Raphson method and with the use of the UserForm. The user will type the equation, the initial guess and the number of iterations. I was able to search on automatically differentiating the equation unlike … |
 | Hello, can anyone provide me with some sample code? VBA access. I need an insert into statement where form.control.value = some_column and another.form.control.combobox.value = some_column can anyone help? thanks |
| | I have a text file that I open and attempt to read the individual lines. I have used the same code before on other files with no problem, but for some reason, this particular file is strange. When I do the following command; Line Input #1, read_string the string read_string … |
| | Good Afternoon, I have 2 senarios to which I need some clarification. I have an Access 2010 frontend with linked tables to mySQL using ODBC. Senario 1: I need to add a few fields to the main table and the software is used 24/7 if I add new fields will … |
| | Hello. I would like to ask for a help. I deal with excel spread sheets and very often I need to amend specific column. The whole steps look like this: Step 1. Find the column name, Step 2. Mark the all populated rows in this column, Step 3. Proceed with … |
| | Am having this piece of COde, but whenever am trying to execute this , Dim tsf As TestSetFactory - > error user not defined appears. pls help Dim tdc As TDConnection Sub UpdateStats() 'create QC connection QCconnect_silent "URL", "DOMAIN", "PROJECT", "USERNAME", "PASSWORD" 'process tests getMetrics 'disconnect QCdisconnect End Sub Private … |
 | Working in Word 2010, I have a long document with many formatting changes to be made. To start with, throughout the document I'd like to replace "Click OK" with "Click [B]OK[/B]", so the OK will be bold but not "Click". I also need it to be case insensitive, as some … |
| | I am trying to add a button to outlook's tool bar using a Macro.The problem is that the button appears but on clicking it nothing happens,I suspect I am supplying parameters wrongly to the OnAction method. The call[CODE]Call AddToolbarButton("My very own button", "Click here", "!<Sub/UserForm>")[/CODE] The method it's self: [CODE]Function … |
| | Hello, I'm still trying to work out the same problem: how to process data from an Excel sheet (above all sort through it but in groups; will explain further down) to use in a Cluster Chart without storing it as data in an Excel sheet. The problem at hand: I … |
| | Hello All, Could you please help me with the following VBA code that I have to understand (but I am not aware of VBA) [CODE]Public Function ErlangB(Servers As Single, Intensity As Single) As Single 'The Erlang B formula calculates the percentage likelyhood of the call ' being blocked, that is … |
| | HI everyone... i`m working on access 2007. i have two table called USER, and USER_PRIVILEGES i created a form with bound text boxes and bound check boxes. the text boxes are for the user information(first name, last name , ...etc) the bound check boxes are for (print report, delete, modify … |
| | Hi all and thanks for reading this..... I have a question that I cannot seem to find an answer for, out there in the big ol ether they call the internet, it involves a three stage procedure on a button pressed within an Access form ... [B] stage 1 : … |
| | Hello I have a problem with my vba collection object. When I run the code below I get the "out of stack space (error 28)" message. It seems to me that my collection shouldnt take up so much memory as the each object in it is just a set of … |
| | I am trying to develop a subroutine that will send an IM to a user. The idea being if the user is online, the code sends an IM to the user via communicator. If the user is offline, it sends an email. The code does work, in that it does … |
| | Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I … |
| | First of all I know this has been asked several times before but I cannot get mine to work. Anyway, on the developer computer I have created a Class Library that contains COM classes. I have also created an Excel 2003 Addin that references the .tlb file that is created … |
| | I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" … |
| | Can someone explain to me how to write the VBA Code that will close another Access Application/Database? I have two Access Programs running. The first Access Program, called Main Program. It is the primary program which contains numerous tables, records, et cetera. I have created a second database, called Employees … |
| | Hello Friends, I am trying to automate PowerPoint using VB6. I want to dynamically create an organizational chart in Powepoint, from a VB6 application. I have Office 2003. I am getting error on the following line, when i try to add a node in the Organizational Chart. ppSlide3.Shapes.AddOLEObject 100, 150, … |
| | I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x … |
| | Hi, I'm trying to connect to a web service using excel. I have currently no issues logging into the web service and also fetching data using one of the methods. But the two other methods, I get the error that states that it had run into an error restoring data. … |
| | I have perceived that I can get a significant performance boost when reviewing all items of an Outlook contacts list by using "Restrict". (I am looking at over 13,000 contacts). In spite of a lot of digging and reading I am having difficultly in getting my mind around what this … |
| | Hey guys, im new here and i was wondering if some people could help me out? ive recently been employed in an IT company, and although i am quite familiar with c++, i have been asked to work on making a custom Ribbon in Excel (creating a new tab for … |
| | Hi everybody I have've been asked to do something but I can get only to a point and I am now stuck. Please help. I have written a Sub in VBA for Excel 2003 (see below) in which the top cell of a range (WorkRange) is initially set at Cells(1,2), … |
The End.