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 Mike Lewis 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. tmtompkins

    Append current record only

    I’m actually just setting this system up and am looking for the best way of doing it. What I have are 7 different buildings in the district that use a system of inter-office mailing hard copies of work orders from teachers and staff to a building computer coordinator for approval and initial...
  2. tmtompkins

    Append current record only

    Thanks for the info, I'll check it out and let you know how it's going or get back with you with any other questions. Thanks again, Terry
  3. tmtompkins

    Append current record only

    I need to send one record ( a work order ) from one databse to another, for approval, and then on to a master database. What would be the easiest way to set up an append query or macro to only send the current record up the line? Thanks, Terry
  4. tmtompkins

    Value from combo box?

    Jeremy, Pardon my thick headedness, but I need a little further help. I have the report doing what I want except for this text/number problem. In reading your instructions I got confused. If I bring up the report in design view and then bring up the properties of the class text box, what do I...
  5. tmtompkins

    Value from combo box?

    Jeremy, thanks for responding. OK, my original problem was I was needing to make a subreport from the table and when I do I end up with the ID numbers, which won't help my users much. Have I got something set wrong? Thanks, Terry
  6. tmtompkins

    Value from combo box?

    I know this has to be simple and I'm just not seeing it but, I have a combo box in a form from a table called classes. The table has an ID field and the class name field. My problem is I get the form combo box populated with the text of the class name but the table the form is based on populates...
  7. tmtompkins

    Command button skipping duplicate data in field

    Thanks much, I knew it was something simple and was probably staring me in the face. It's working just fine know.
  8. tmtompkins

    Command button skipping duplicate data in field

    I have a form and subform working off a query. The query gives me a list of students and attendance records. I would like an easy way of skipping records in the form to the next record where the name changes. Any ideas? thanks
  9. tmtompkins

    Parameters on a report with sub-reports

    Thanks for the help, it set me in the right direction. I set up a parameter form and and directed my query to it. Now when I run the report it only ask for the parmeters once. Thanks again. Take Care. Terry
  10. tmtompkins

    Parameters on a report with sub-reports

    I have a main report that has three sub-reports. The sub-reports are all from the same Query. The Query has criteria of, Between[Type the Beginning Date]and[Type the Ending Date]. How do I get the report to only ask for the parameters once instead of the 3 times it ask now?

Part and Inventory Search

Back
Top