Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hamburg18w
  • Content: Threads
  • Order by date
  1. hamburg18w

    Task Host is Stopping the Shutdown

    I am running Windows 10 and recently when I shutdown my computer, the blue screen appears with this message: "Task Host is stopping the shutdown (\microsoft\windows\applistbackup\backupnonmaintenance). Can anyone help me. I searched the internet for information about what this is, but did not...
  2. hamburg18w

    Counting dates in a time period

    I am running Excel 2010 and have a sheet with a list of names, dates, and active columns. I am trying to make a formula that will tell me how long people have been active (i.e. 6mths, 8mts, 12mths, etc) What I need the criteria to do is determine if people are active (column I) and how long it...
  3. hamburg18w

    Run report from form by selecting critiria base on query

    I have a form with a combobox, which looks at data from a query. The query gets the information from a table that has multiple activities listed for each entry (organization). When I select an organization in the form, it has multible listing of the same organization. Is there a way to make it...
  4. hamburg18w

    Using a combo box to run a report

    I work with Access 2007 and want to run a report by selecting a specific criteria. The database has a list of organizations and specific activities performed in those organizations. I have a report that produces a list of all the organizations and activities performed in each of them. What I...
  5. hamburg18w

    If with multiple criteria

    Can you help me build the following formula: if f6:j6 = Either: "Of" or "Hm" or "Grp" or "Ph" = Result: Yes
  6. hamburg18w

    Less then and more than formulas

    I am running MS Excel 2003 (Windows) and need help with building a formula. I am a cell (H31) that in itself has a addition formula and need to build the following formula: if h31 is less than 14 return 1 if h31 is greater than 13 and less that 17 return 2 if h31 is greater than 16 and less...
  7. hamburg18w

    Printing Multiple reports at the same time

    I am using Access 2007 and have built a number of reports based on quiries that I run on a weekly basis. Is there a way I can print all the reports at once rather than printing them individually? I searched through similar questions other people have asked but could not make it work. I must be...
  8. hamburg18w

    Data Validation Linked to another File

    I am running Excel 2003 (win) and have a "Medication Schedule.xls". I would like to be able to select from a list of names in Column A and those names would come from the "Client List.xls" file, which has a long list of names. Is this possible? If this is possible, I would like Column B, C...
  9. hamburg18w

    Nested IF formulas with more than one result

    I am running Excel 2003 (win) and need help with a nested IF formula. I will try to describe what I am trying to do: If F8=8540 and O8="*" the result should be facilitator If F8=8540 and O8=1 the result should be Co-facilitad If niether of the above criteria is true, the cell should be blank...
  10. hamburg18w

    Embaded If Formulas

    I am running excel 2003 and need some help with embaded if formulas. Let me try to describe what I need. Column E is a tropdown list of codes Column H has the if formula Example: if column E is 8550 or 5486, = 3, if column E is 8510 or 8520 or 8540, etc. = 1 Please help. Juan
  11. hamburg18w

    Workdays between two dates

    I am using excel 2003 (win) and want to calculate how many workdays after due date a particular report is turned in. I am using NETWORKDAYS function but it gives me the wrong number of days. The following example illustrates my dilema: =networkdays(a4,a5) where a4 equals 5/3/10 and a5 equals...
  12. hamburg18w

    Reference Formula locked on a cell

    I am running MS Exel 2003. Sheet1 has a list of roling names and dates, meaning the names on top get deleted and new names get added on the bottom. Sheet2, 3, 4, etc. point to specific cells in a specific row on sheet1. I am looking for a formula that would stay locked on a specific cell in...
  13. hamburg18w

    Calculating weekdays between 2 dates

    I run Excel 2003 and would like a formula that tells be how many workdays (Mon-Fri) between two dates. Please help! Juan
  14. hamburg18w

    Data Validation

    I run Excel 2003 and want to create a way to simplify making up a schedule of clients to be seen on a given day. The problem I encountered was that the datasheet has multiple lines in a raw and when I use data validation on input sheet, it comes out as a single line. Is there a way that the...
  15. hamburg18w

    Advance Formulas for Excel

    I am running Excel XP and need to create a formula that would look for a specific criteria in two separate columns and return the results. For example: Column 1 Column 2 Column 3 Frank Yes Yellow Mary No Yellow Isaac Yes Blue Etc. Etc. Etc. I...
  16. hamburg18w

    wild card in Access Queries

    I am running Access XP and wonder if I can use wild card (* or ??) in the queries. I need to made a query that will produce a all the dates for a specific month, regardless of the year. Can anyone help me? Thanks.
  17. hamburg18w

    Complax Excel Formulas

    I need to build a formula that would like up specific names in Column A and return a corresponding time spend on the project from column G. Example: Col A - List of Activities (I want to be able to include more than one specific activity in the formula, but the activities in the formula will...
  18. hamburg18w

    ODBC Driver Manager error

    I am running Windows XP with MS Office XP and recently started to get the following error message when I wanted to open a third party program. The error I get is: SQLSTATE = IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Can someone help me...
  19. hamburg18w

    Insert Picture into a Form document

    I have MS Word XP and have designed a "form" document, but in to be able to import a picture into the form without unprotecting the form. Is there something that I can do to make in possible to import a picture without unprotecting the form? One other piece of information, the form could be...
  20. hamburg18w

    Table Calculations

    I run WordPerfect 10 and have a document with two table (Table A and Table B). Table A calculates de values in the columns but table B does not. The formula in table B is "+SUM(B3:B15)" and I have tried "+SUM(Table B.B3:B15)" but neither calculates the values in the cells included. Can...

Part and Inventory Search

Back
Top