Answer Questions

• DaltonF ADO Recordsets

  I have a routine in Excel, which pulls data in from a SQL Server database into two ADO Recordsets using two seperate queries. These recordsets contain only 1 field, being customer ID, each with in excess of 65,000 records. I need to compare these two recordsets to establish how many customer IDs are present in one, but not the other and vice versa. Is there some clever way of looping I could use to achieve this The only other thing I can think of is a local query within my module on the two datasets, but is this possible Cheers for any help! Keith Derek Smyth wrote: There is no way to run a query over your two recordsets because there needs to be a relationship between the da ...Show All

• Rob Wilson CRM 3.0 Outlook Client

  I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Microsoft CRM requires cookies to use the Web client. To enable cookies, see the online Help for your browser" "An error occurred loading Microsoft CRM functionality. Try restarting Microsoft Outlook. Contact your system administrator if errors persist." I have allowed all cookies in IE 7, and still get the first error. When I i ...Show All

• Bill Calkins find current path in VBA macro word

  I have a macro in word. In this macro I have need of a function that find the current path. try CurDir To get the activedocument path, use ------ Msgbox Activedocument.Path ------ -bvr Try this Application.path which return the current working path. check out msgbox application.path ...Show All

• NeptuneTech Error starting Live Communication 2005 Archiving

  Hi, I have installed LCS 2005 SE SP1 on 2003 R2 with SQL-Server 2000 SP4 in a live environment and a test environment on the same server. In the test environment the Archiving service starts successfully but in my live environment I get a few errors of which the main culprit is: Event ID: 30619 Live Communications Archiving Service failed to start because a schema version mismatch was detected. The service will not start until this problem is resolved. Resolution: Ensure both the Archiving Service and backend were installed or modified by the same installation package. I am 99.9% sure I used the same installation package. I uninstalled and re-installed the Archiving service but no luck. I am consulting with Microsoft Sup ...Show All

• leclerc9 Get Current Slide Number And Insert a New Slide

  I've recorded a macro to perform certain formating to slides in a ppt 2003 show. I would like to enhance it by having it insert a new slide after the current slide (as the standard action with CTRL+M) When I record the macro, however, the slide number being inserted is hardcoded - I want the macro to insert after the now current slide. When I record inserting after slide #2, the applicable macro line reads: ActivePresentation.Slides.Add(Index:=3, Layout:=ppLayoutText).Select How can I get the macro to determine the "current" slide # and change that index:=3 to the apprpriate numebr (or variable containing that number TIA Have a look at this page, which includes ...Show All

• Worf what is wrong with this formula? *9 Views & no one knows?*

  =IF((Weeks!D(B1+6))="",1,2)   whats the error with this D(B1+6) is ment to respresent a cell with D    = the value of B1+6   what am i getting wrong If This Helps The Cell Forumla is Going to Be used this way Sub NamesDropDown_Change() ' check for already inputted data For x = 1 To 7 Cells(x + 2, "K").Forumla = "=IF((Weeks!D(B1+6))="",1,2)" Next x End Sub But currently this formula is not working Not everybody who reads/posts here is working in Excel VBA. If people view and don't reply, they could be just thinking of an answer, or they might simply not be familiar with your problem. Complaining about not getting an answer won't help bro Hello M ...Show All

• jandrhub Excessive Lag with VBA APP

  Hi all; I am a developer for an organization, tasked with writing a password generation program. In access I run a query to get the correct population and save it to a new table. I then (with VBA), open the recordset and append on a unique user ID and a randomly generated password. The program runs great however it takes 6-7 minutes, and sometimes locks up the computer. I was wondering if anything in the code stands out as a red flag. The population I am working with is about 11,000 people -----Code Follows------ Function CreateUser() 'Variables for loops and text Dim num As Integer Dim intloop As Integer Dim encode As Integer Dim cypher(62) As String Dim pass As String Dim pick As Integer Dim count As Long Cons ...Show All

• Rafael Soteldo SQL Server 2005 Resourse Kit exception

  Hi, When i try to view any of the webcasts by clicking "play", i get the following Visual Studio just in time debugger error: An unhandled win32 exception occured in iexplore.exe[4624]. I can also see the following error in the winnt application error log. I am running winxp with sp2. Event Type: Error Event Source: Application Hang Event Category: (101) Event ID: 1002 Date:  25/08/2005 Time:  7:08:50 PM User:  N/A Computer: INSPIRON Description: Hanging application iexplore.exe, version 6.0.2900.2180, hang module hungapp, version 0.0.0.0, hang address 0x00000000. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Data: 0000: 41 70 ...Show All

• calvin_mayo VBA Outlook - File Stream issues

  I am trying to write a script triggered from an Outlook email to parse the email (as a text file) and then update an excel spreadsheet with specific data extracted from the email. The email is a form email delineated by a "/" for field breaks and "//" for end of line. However, when I create a text stream to read in the data, the returned string does not include these delineations. Here is a copy of the code I am currently using to open and read the file. I don't want to open the entire email as a new workbook, so I can't use the workbook function. Set fs = CreateObject("Scripting.FileSystemObject") Set ts = fs.OpenTextFile("file.txt", ForReading, TristateTrue) check = True Do s = ts.Readline endlinepos = InStr(s, "//") Do While en ...Show All

• Al Christoph Trying to create a global variable

  I am trying to create a global variable in a user form within Microsoft Excel. I know the variable must be in the General area. So I type: bt = Sheets(10).Range("G25").value then I click play(run), but that highlights "G25" and says : Compile Error: Invalid outside procedure I tried just typing: bt="hello" And then I hit play(run), and it highlighted "hello" and gave me the same error. What am I doing wrong Hello Anas. You need to define global variables in a module and they need to be public. Public myGlobalString as String Variables placed in user forms are created and destroyed as the form is displayed and then closed again so their scope cannot be global. Hey Derek, ...Show All

• gracias Command Buttons (Delete, Run, and Close)

  Ok I have a userform that asks if you would like to calculate now. There are two command buttons on the form, one says Yes the other says No. I need the form to automaticlly open when the user opens the workbook. When the user clicks on No I want the form to close. When the user clicks on Yes I want it to delete the last worksheet in the workbook and then run a process (called process). One is this possible (I know the No button is) and two how do I get it to work Thanks for any help or ideas. Perfect!! Thank you so much! I used the first bit:- Private Sub WorkBook_Open() Userform1.Show End Sub > but it dodnt work for me! Comes up with ...Show All

• mcnamaragio Word: How to you determine the current cursor position

  For one of my macros to run, I have to ensure that the cursor position is not in a table or in a frame when the user activates the macro. How can I find our the current cursor position Once I can determine that the cursor is positioned in a table or a frame, I can then code a message box to instruct the user where to put their cursor to run a certain routine. Hi, Cursor position Selection.Range.End This will check whether currently in a table or frame. Dim lngTableCount As Long Dim lngFrameCount As Long For lngTableCount = 1 To ActiveDocument.Tables.Count If Selection.Range.InRange(ActiveDocument.Tables(lngTableCount).Range) Then MsgBox "In Table" Exit For End If ...Show All

• jasmine pham Sum of hours using select statement & VBA

  Hi - ok here is my question: I have an activity recording form that records hours logged against a company. I have added a field called 'sumactivityhours' to the table and the form.  what i would like to do is when a user selects a company from the drop down list (thanks derek and duck thing for your fantastic help with that problem) it automatically populates the 'sumactivityhours' field with the total number of hours worked thus far with that company  so that the user can see the total hours and then writes that information into the 'sumactivityhours' field in the table. as i gradually begin to learn a little more about VBA im guessing that i should create an on exit event on the companyname combo box that re ...Show All

• Simon Gittins Newbie Help: All caps to Title caps

  Hi I need to create a macro that will start at the begining of a Word document and select all sections of text that are in ALLCAPS. It then must change the instances of all caps to title or proper caps. However there are specific two letter codes that must remain as all caps. Is this possible Basically, a mail merge that uses a database query as the datasource is importing address and name details in allcaps. To maintain professionalism, it is desired that these items are in proper caps. However, the letter contains two letter 'class codes' that must remain in all caps (eg. BI, FH, LF, NM). I am only just learning VB and can only get the macro the select the whole document and change it to proper caps. Manually selecting the r ...Show All

• ilatzis API Used in VBA

  Hi Friends, I want to know what APIs acn be used in VBA Programming. Can U help me Thnaks Ideally, All VB6 API Functions should work with VBA also. I have tried many and it works fine You can use API Viewer in the Addins tab of VB and get to know the APIs available. You can also add more API Functions to the input file You can use any APIs in VBA that you could use in VB6. If you know which one you want, search google using the API name and VBA or VB6. I'm not sure if .Net versions are compatible, but those are worth a trip to google too. (Google is one of my favorite programming tools, BTW.) See www.allapi.com ...Show All