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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. striker83716

    Conditional Sum query or module

    I am trying to create a crosstab query that will sum hours between dates, based on system failures. In the table below, the first three columns are from the table, the last two columns, is the data as I would like it to appear. I am posting here, because I believe I will need some VBA for this...
  2. striker83716

    VBA to create table with date range

    Thanks for your help jedraw!, After walking away and thinking about your reply, I realized you were right. I now have a query giving me the results that I need. Thanks again, and have a star!
  3. striker83716

    VBA to create table with date range

    Thanks for your recommendation, and I agree that doing this is not the normal practice. But because of the complexity of this project, I must do it this way. By the way this is a temp table that will be deleted and replaced every time the code is executed/report is needed.
  4. striker83716

    VBA to create table with date range

    I have an access table that has two date fields. These fields are titled StartDate and EndDate. They represent a range of time. I am simply wanting to put these ranges into a new single column table using VBA. The range needs to include the StartDate, EndDate and include every date that is in...
  5. striker83716

    Change Graph Recordsource and Format Graphs

    I have tried the AfterUpdate of the list box to change the recordsource of the graph as well as the code above, which is also triggered by the afterupdate of the listbox. In both cases If I select a value that has a series collection of 1, then select a value that has a series collection...
  6. striker83716

    Change Graph Recordsource and Format Graphs

    I am struggling with a access database I am working on. I have a form with a graph and a list box. After update of the listbox I would like to update the graph's recordsource. The recordsource will not be based off of the same table or query. I have this somewhat working, however when I...
  7. striker83716

    Simple Total Problem

    3 text boxes. Name them txt1, txt2, txt3 The control source of txt3 = [txt1] - [txt2] Hope this helps
  8. striker83716

    Creating a Template in Word

    This is still a great option. Just instruct the managers/leaders that are performing the evaluations, to save the .dot file to their hard drive. Then, when they are ready complete the evaluation they need to open the file by double clicking on the icon in explorer. Or if the file is saved on...
  9. striker83716

    Creating a Template in Word

    Gerry, Gave you great advise, put a table on you form get it all set up the way you want it then make the color of all of the borders of the table that you do not want to see white.
  10. striker83716

    Creating a Template in Word

    It is possible to make a template in word. First create the document that you want, but be sure to use the form toolbar, insert controls that the end user will complete, such as a text boxes where the end user will put the fax number, the receipent etc. Name: TextBox Phone: TextBox Fax...
  11. striker83716

    what happened to binders in MS office?

    Binder is still available in Office 2003. It, however, is not installed by default. If you insert the setup disc, and selct custom install you can selct and install Binder.
  12. striker83716

    Open a clean form rather than #1 and then go to clean

    Try this, Open the form in Design mode, change the property "Data Entry" to Yes, save and close. Now when you open the form it will always be a new record.
  13. striker83716

    Find the date of Anniversary

    Woo-Hoo it works. Thank you So much for your help. It does give me more then one record for each employee but I can easily create a "min" on the date column. Thanks again for your help. Rob
  14. striker83716

    Find the date of Anniversary

    2003, happy to convert If i need to. If so tell me which version you have.
  15. striker83716

    Find the date of Anniversary

    here I get "Enter Parameter Value dialog box asking for the "Duration"? sorry to be such a pain but I am really struggling here.
  16. striker83716

    Find the date of Anniversary

    PH, If I paste the sql statement you suggested I get a "Enter Parameter Value dialog box asking for the "5th Anniversary" Can you tell me what I am doing wrong? I really appreciate your help.
  17. striker83716

    Find the date of Anniversary

    PH, tblEmployee does not have any dates. all dates are in the tblEmployment
  18. striker83716

    Find the date of Anniversary

    Let me state this question another way. I want to know the 1825th day of these ranges if they were all related to 1 person, starting with the earliest range. StartDate EndDate 8/15/77 2/19/78 3/31/80 9/19/82 4/24/83 6/25/89 The result in this case would be 4/28/85 StartDate...
  19. striker83716

    Find the date of Anniversary

    Only 2 problems with that. 1st he did not work for us on 6/24/1986 and secondly 5 years employment with us would have been 8/15/82
  20. striker83716

    Find the date of Anniversary

    You are probably right there since it has happened in the past, however in addition to the 5 year anniversary I am modifying the query to show the 1,3,5,10,15 & 20 year anniversaries. This is going to then be used to distribute to the employees for their evaluation as we transistion from...

Part and Inventory Search

Back
Top