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!

Recent content by JimUK

  1. JimUK

    Time query help

    Duane, Thanks for the input. I'll start with that and see where it leads me. Jim
  2. JimUK

    Time query help

    Whoops sorry! They both contain date and time in the format 12/02/2005 13:00:00 Example: Date of Entry: 12/02/2005 11:10:30 Date of Closure: 12/02/2005 14:00:00
  3. JimUK

    Time query help

    Duane, Thanks for the response. Table name is tblWOLog and their are 2 time fields, DateofEntry and WOClosedDate. Other fields that I'm pulling to make the log entry are, Problem, EmployeeName, Actiontaken and WOStatus. I check both the date fields in my query as there are 2 types of entries...
  4. JimUK

    Time query help

    I have a report that I have been using the DateAdd function to query the last 12 hours for a helpdesk log and that works no problem. Our shifts run from 7am to 7pm (days) and 7pm to 7am (nights). What I would like to do is make a query that would look at the time when generated and only grab...
  5. JimUK

    Report problem

    I am trying to make a report that will act as a logfile of work done in the last 12 hour period. I have no problem with the time and setting up the query. The problem is that I want to see any field that is changed(edited)in that period as well. Is there an easy way to do this? The problem...
  6. JimUK

    Memo field question

    Thanks Duane, I'll give it try. Thanks for the input! Jim
  7. JimUK

    Memo field question

    Duane, I think you hit the nail on the head. I didn't think about this when I designed it. So, what would be the proper way to setup this new table so that entry would create a separate record for every entry into this field? Table name is tblworkorders, field name is fldActionTaken? Jim
  8. JimUK

    Memo field question

    I have a report that I made for a workorder database. This report prints out daily entries made on workorders. As it is now it prints all entries in the memo field, which may be days or weeks worth of work. My question is that I would only like to print the last entry made in a memo field...
  9. JimUK

    Report Grouping

    Crew is field. I figured it out on my own, silly as it was just used the group option with crew<number> and it works fine thanks for response. Jim
  10. JimUK

    Report Grouping

    I'm trying to group on part of a text field in a report. Column will have the following: Date Location 29April2005 Station A 02May2005 Station B 06May2005 Station B 07May2005 Station C What I want is a group header based on the A, B or C in...
  11. JimUK

    Combo Box Problem

    Bob, That's the ticket, works like a charm! Thanks for all your help as I got a little twisted around the axle as they say. Jim
  12. JimUK

    Combo Box Problem

    Update to my last entry. After further testing, the only time the combo's get it right is when there is only one possible system for the title. Some of my PMI Titles will have up to 5 possible systems, some may have only one system. The only one that will show up right is one that has only one...
  13. JimUK

    Combo Box Problem

    Bob, It works great the first time but then screws up after that. Let me try to explain: When Title and System are chosen the second time and there after (until form reopened) it seems to display things right in the comboboxes but FindFirst seems to go to the first "system" that it finds in the...
  14. JimUK

    Combo Box Problem

    Okay, got 2nd combo figured out and it works fine now. All possible selections automatically drop down when selecting title in first. Had to change cboSelSys Rowsource to the following: SELECT DISTINCT PMI.system FROM PMI WHERE (((PMI.title) = [Forms]![PMI_Signoff_Test1]![cboSelTitle])); SO...
  15. JimUK

    Combo Box Problem

    Okay, 1st combo is working fine and typing in works great thanks! The second one comes up blank though. Is this because we don't have an AfterUpdate yet (I took mine out). Jim
See more

Part and Inventory Search

Back
Top