Answer Questions

• Senthil Ramadoss Office Communicator 2005 sign-in name, auto populate after install somehow?

  Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users probably wont take the time to enter their info when I have it set to auto start/connect on windows start up. Thanks Hi There, The script work great except my organization uses firstname_lastname@domain for you e-mail address but lastname first initial for the user name. is there any varible like %username ...Show All

• Brian Pound 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

• Ravi Awasthi How to show dates in forms by the order of time?

  Hello, all, I have a little database which deals with patients paper work. I have two tables. One is patients' basic information like name, race, age, and so on. The other is the patient's paper work including the date when the patient finishes the paper work. So I have two forms. One if for the patients' basic information, the other form is a subform of it to show the paper work information of the patient. My question is, when I try to see one patient's all paper work, say, 2 records, they are shown by the order of number, but not time. e.g. The first record will be paper work on 10/24/2006, while the second record will be paper work on 12/6/2005. I hope the records can be shown by the order of time. I mean, when I check the s ...Show All

• schmod54 error message when closing ie7

  The computer administrator profile is not having this problem only the other users on my home computer. Upon closing the browser this pops up: iexplore.exe Application error The exception unknown software exception (0x0eedfade) occured in the application at location 0x7c812a5b We have ie7. Can someone help The best place to get help on IE7 is http://www.microsoft.com/windows/ie/support/default.mspx There is a newsgroup dedicated to IE issues and discussions: microsoft.public.internetexplorer.general I'm sure that someone has had the same issue and has a solution or a workaround. When you post something up there, be sure to clue them in to your operating system and which version number ...Show All

• milicica IsError function from VBA6.3 to v6.0

  Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000. The following code works fine in the later version: For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else Y = Application.VLookup(Range(vString).Value, vRange, 31, False) End If ' write the result to the active workbook Cells(i, 31).Value = Y Next i But won't work in the earlier version as there's a type mismatch at the If Iserror ... line. Any ideas why or thoughts on a workaround Thanks, Steve. ...Show All

• abigail.tseng # recipients, subject, body of a Mail not recognised

  HiAll I have added a control to the new mail window. Problem is, is in my code (vb6,outlook XP) i have the following code My problem is that I doesn't recognise the recipients as well other fields of mail (subject, body). and MsgBox ("To= " & mTo & " Cc=" & mCc & " Bcc=" & mBcc) shows nothing in TO,CC,BCC etc. Please have a look at mycode & suggest me what is wrong there Thanks in Advance Private Sub myOlInspectors_NewInspector(ByVal Inspector As Outlook.Inspector) On Error Resume Next Dim myInsp As Outlook.Inspector Set myInsp = Inspector If myInsp.CurrentItem.Class = olMail Then Set newMail = myolApp.CreateItem(olMailItem) 'MsgBox ("in new mail") myInsp.CommandBars.Item("Standard").Visible = T ...Show All

• humberto molina Automating TOC

  Hi, I am generating the Table Of Contents(TOC) of a document by pointing the Range to the BookMark which i had placed manually on the start of page2. But if my TOC fills only half the page, then actual contents start from the very same page below the TOC. Is there any way to check if the TOC and actual contents are present in the same page and if so can we manually include a Page Break Could it be Something like this If so is there a syntax to get the page number of the selection If( PageNumberOf(TOC) == PageNumberOf(Actual Document Contents)) { Insert Manual Page Break; } Or is there any other way to handle this -Amrish ...Show All

• Joe H how can you call a report from reporting services within access 2002?

  is there an easy way to display a reporting services' report in pdf format within access 2002 without going through Internet explorer report server is sql server 2000 ...Show All

• Petknep Automatically send attachment in email with a submit command button in word

  I have a huge problem if anyone out there is able to help; I have tried to create a submit command button to email off a document as soon as the user hits submit; however i am new to this and my macro does not seem to be working. Does anyone know where i have gone wrong and if possible can you please help rectify the problem. Thank you Sub CommandButton1_Click() Dim Email As Object Dim Attachment As String Set Email = CreateObject("Outlook.Application") 'Assign Outlook application to variable With Email.CreateItem(olMailItem) .to = "<>" 'email address .Subject = "Incident Report" 'Something for the subject Field .body = ActiveDocument .Display = Attachment Options.SendMailAttach = True End Wi ...Show All

• achalk Runtime Error '2001'

  I am using the following code to use an unbound text box to display the PM Name associated with the PM Number but for whatever reason, I keep getting the Runtime Error '2001' when I run the code. Private Sub Combo59_AfterUpdate() Dim StrName As String Dim strPM_Select As String strPM_Select = "[PM Number]=" & Me![Combo59] & "" StrName = DLookup("[Plan_Center_Name]", "Plan_Center_EPMC", strPM_Select) Me![PM Name] = StrName End Sub Please help. An explanation of the error would be great or if some one can tell me what it is that I am doing wrong that would be fabulous. Thanks! Code Snippet Private Sub cmdViewReport_Click() Dim strSQL As String Dim strQueryName As Stri ...Show All

• GSReddy OK Trying Again - A Simple Very Simple Routine

  Could somebody debug the following for me. It is very simple. I need to loop through and open Excel worksheet processing each row until eof/ empty row. The WS contain 5 fields. 5 new fileds are created and appended to the row they were derived from. Sorry VBA is more complicated than I had expected. So.... do until eof loop ' reset counters Team_Member = 0 Team = " " Time_Played = 0 JB_Total = 0 CK_Total = 0 KK_Coach = 0 Total_Time = 0 ' select fields Date Time Team_Code Score Points ' from open worksheet row by row from ' c:\hamish's\matches.xls Date.Select Time.Select Team_Code.Select Score.Select Points.Select ' strip out 3 fields from Team_Code Team_Membe ...Show All

• rocky_don MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Microsoft recommendation to solve the issue is: Rename MDIMON.DLL Remove OFFICE DOCUMENT IMAGING Restart Install OFFICE DOCUMENT IMAGING Restart I just change the repice: Rename MDIMON.DLL Remo ...Show All

• dfox mxyzptlk Egg Money problem with Explorer error message

  I manage my accounts through Egg Money and continually get the error message sitting right over the "view" box. I have ticked the box "do not save encrypted pages to disk" as told to do my Egg, but this doesn't work. Iexplore.exe Appvet 6.0.2900 ModName wlextension.dll ModVer 3.0.1.2038 Offset 0000d4c7 Help please ...Show All

• Drew Marsh ASP .NET 1.1 fails at install, but not .NET Framework 1.1

  Hi there, My Scorecard Manager 2005 installation finds that I do not have ASP .NET 1.1 installed, but it finds .NET Framework 1.1 installed. I could not find a download for ASP .NET 1.1 outside of the .NET Framework 1.1. Can anyone explain in a few words what is the difference between the framework and the asp .net To note that when I try to install the .NET Framework 1.1, which I cannot see installed in my programs, the installation is failing due to product already installed. I am a little confused. The OS is Server 2003 SP1. Thank much. I found the solution, actually: when installing the Applications, under Add/Remove Programs, Add/Remove Windows Components, I didn't select the Details but ...Show All

• Pedro Ferreira dll's in VBA

  Currently in my VBA programs, I'm finding myself repeating a lot of code and functionality across different projects, and it would be great from a maintenance point of view if I could create something similar to a .dll, that I could import into a project and use. Furthermore, if circumstances change and I need to change how a sub-routine works in the .dll for example, all projects using it will benefit from the updated code. I know that you can export modules and class modules and then import them into other projects, but this seems a bit limited. First, if i wanted to change how a sub-routine worked in either the saved .bas or .cls files for example, how do I do that Second, how would projects that use either of these two files benefit ...Show All