Answer Questions

• mahima 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

• Noldona read line from table cell for vba in ms word

  Hi, I need to read a line in ms word table cell. There are 3 line in a cell and I'd like to read line by line and put a line in a string variable. Would anyone be willing to help me here I'm so desperate with the answer since I tried everything and none are working. What I did so far: If (Mid(theTable.Cell(caseStartRow, 2).Range.Text, 1, _ Len(theTable.Cell(caseStartRow, 2).Range.Text) - 2)) = chrs$(13) Then objFile.WriteLine ("") objFile.WriteLine ("") End If Please help. Thanks so much!! Here's an example of code that will do this: Option Explicit Public Sub main() Dim strCellText As String Dim strCellTextLines As ...Show All

• GoDaddy Call Excel macro from Access

  Does anyone know how to call an Excel macro from an Access VBA module I am connecting to Excel using the Excel Automation object but cannot seem to access anything but the assigned startup excel macros. Any help would be apprecited. Jody – If you’re massaging data in Access only, my approach would be to export the macro from Excel and import it to Access. That’s the simplest case. If you’re trying something else, please elaborate. ...Show All

• Juliano.net call addin's userform

  I have creadted a .xla file, it have a userform in it. i have loaded the xla addin. now in my new spreadsheet, through vba maros can i display the userform which is in that .xla file any help or ideas on how can i achive such a thing would be appreciated nrupesh hi there, create a public method in your addin that displays the user form. You can then call this method using... Application.Run ("myAddin.xla!ShowForm") It's important that a) you check that the add in has been installed and b) that your addin does not have any spaces in it's filename, otherwise the Run() method won't be able to find it. Use the Addins("myAddin").Installed = True to determine if the Addin has been installed H ...Show All

• PEng1 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. Hello, I have the opposite problem. I have users who have had the icon for the Office Document Image Writer deleted under Printers and Faxes. You mention above that it is easy to reinstall the virtual printer. Could you point me to the directions for reinstallation plea ...Show All

• Pete Schnettler Application.Tasks contains 16 tasks for 1 instance of Excel

  Hi, We are using the property Application.Tasks in Word 2003 to try and find all the open instances of Excel, so we can display them as a list for the user to pick from when importing tables and charts. When the user selects one of the instances, we use Task.Activate() to give focus to the open Excel window. This works fine, except in the case of one system (IBM T43 Thinkpad, WinXP SP2, Word 2003 SP1), where for one instance of Excel open, there are 16 tasks reported by Word. Any suggestions or comments would be appreciated. Regards, Angelos Petropoulos ...Show All

• Blackuke read only file opening

  well, a good way of making sure that the application doesn't hang up on errors is the on error resume next -statement in the beginning of code that may result in errors... you could put that in the "slaves" and then check for errors in them. Another thing is that inputboxes return an empty string "" when the user presses cancel on them and that can screw up your variables, if you don't check the returned values.:) I'm not quite sure I understand what you're trying to do, but I wrote a little test of a Master-file opening slaves that in turn open inputboxes and MsgBoxes: ' on error resume next makes sure the application doesn't halt on an error... error checking with if err.number <> 0 then and the actions    ...Show All

• LaoZeng personalized command bar disappears when minimizing excel

  This is my first message in this forum, so please be patient. I have programmed a makro for an excel workbook. one part of this makro creates a command bar. when the excel workbook is started i make all the regular command bars disappear, only mine is left. Works wonderful. Well, i have put a button into my command bar to minimize the application. However, when i restore the workbook again from the windows taskbar, my commandbar is vanished, and the normal command bars (like standard and format and also the formula bar) are suddenly there. The command bar is still there but not enabled/visible. The problem exists on many computers and also on differnet excel versions i tried (97, 2000, xp) I do not know if that is a bug or not. Now is it p ...Show All

• tee_user5 access2003 code modules can not be read after a compile and compact and repair

  after finishing up some code behind a form in access 2003 I compiled the database then compacted it. After that I could not access the code modules. I would get an error that the module did not be opened. Any help would be good downard26@msn.com Have a read of this http://archive.baarns.com/excel/develop/vbaperfm.asp especially the bit about opcodes an excodes. I think something has happened to your project relating to these codes, meaning the code might be lost. There could be a repair tool that might fix it or maybe a decompiler. Can you export You got a backup I can not import and forms that has code or modules. I have not created a MDE. I did get and error when it was compiling but ...Show All

• Teeravee Sirinapasawasdee Ms Access to SQL server Through ODBC

  I have a microsoft access Database that I upsized to SQL server 2005 now all of the tables in the access front end are linked tables through ODBC. When the user opens up a form thats connected to one of these linked tables, it promps the user for the SQL Server password, What I would like to do is, make it so that the user never has to enter the password. I would like the password to be entered in the background when the database loads. How can I do that I need as much detail as possible. ...Show All

• Corey C. vlookup

  Finding closest value in a column I tried using: x=vlookup(strStartDatumArray(1); rng(1); rng(1); False) where straStartDatumArray(1) contains the date that I want to find. I want to find it below the cell rng(1) and I want to return that very value (rng(1)). rng(1) is a position in an array that is given like this: rng(k)=Worksheets(varWorksheetInfoArray(0)).Cells.Find(varWorksheetInfoArray(k), LookIn:=xlValues) If you have any idea how to make my code work I would be most grateful for your assistance! Thank you very much! Hi AndersBank Since you haven't gotten a response yet, try asking the Excel specialists in the Excel programming newsgroup, here: http://msdn.microsoft.com/newsgroups/default.aspx ...Show All

• B Barr LCS 2005 Users Staus issues

  Hi we have been installing LCS 2005 standard and have twice come up against this issue, Im sure its simple but we cant fathom it out We both login with Office communicator but it shows us as status unknown, we are both reg with the server. even though we are both online i cant msg him and we both show unknown to each other thanks Tobez, I have escalated this to a Microsoft Support Engineer. Please contact us at budsup@microsoft.com with the following information: It seems to resolve this issue someone should look into partner’s servers and installation. Please ask partner’s contact no., availability, name and email so if I dispatch a subcase to expert team, someone can contact hi ...Show All

• Jessica Alba SELECT syntax in VBA for retrieving information

  Hi - this is coming as a modification from one of my previous posts that were solved - on an activity screen the user who is logged in can only select companies that have the 'active' tickbox ticked and where the 'leadofficer' value must equal the value of the user logged in. this is achieved by the following VBA Private Sub Form_Load() Me.companyname.RowSourceType = "Table/Query" Me.companyname.RowSource = "SELECT [companyname] FROM [tblcompany] WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'" End Sub where loginname is a global variable held in a module and stores the name of the user currenty logged in. However i now need an additional leadofficer field - 'leadofficer2' which ...Show All

• Fibaoptix Question: How do I hide the Title Bar?

  Howdy... I'm writing a program in Excel and I was wondering how to hide the Title Bar. The one with "Microsoft Excel" and the min., restore, and close button. If that's not possible, is it possible to deactivate the close button I'm not working with Forms....I want to hide the application title bar. Hi, Have a look at Stephen Bullen's FunForm workbook. http://www.oaltd.co.uk/Excel/Default.htm I know his code is designed to apply the formatting to a userform. But by changing the code in the class to use the application window handle rather than the userform the effects still work. But be very careful when playing around with application setting. Make sure your code returns the enviroment to the same state you found ...Show All

• Lakshmi N Running a macro if new mail if from a specific address

  Hello, I'm currently trying to write a macro that is run when new mail is received in Outlook 2002 (possibly XP not sure though) I would like the macro to check if the new email is from a specific address (in this case sales@falcontrunking.co.uk ), delete the email, and display a message saying "There is a new message in the Sales Inbox". I know how to run a macro when a new message is received and I know how to show a message box saying "There is a new message in the Sales Inbox" but I don't know how to check if the new message has been received from a specific address. Can anyone help me Thank you very much! Sorry, I didn't make it clea ...Show All