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 Chriss Miller 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: dmoran
  • Content: Threads
  • Order by date
  1. dmoran

    Update query from form

    Can the "Update To" cell be defined by user input from a form? I have 30 records in tblmembers where I would like to be able to update the "dues" field on all records from an update query that runs and is defined from a form - Thank you-
  2. dmoran

    Calculate Hours Between Two Dates

    I have a form with three fields - [begintime], [endtime],and an unbound [totaltime]. I am trying to use DateDiff to give me a total in hh:nn format but it doesn't seem to recognize the dates. In other words, I'm OK until 23:59 total time. My formatting is 99/99/00" "00:00;0;_ Does anyone have...
  3. dmoran

    Counting multiple fields

    I'm drawing a blank for what I'm sure is an easy solution - I have a report where each record has 5 fields labeled "med1" through "med5". These 5 fields may/may not contain the name of a medication. All I want to do is display a total count of entries in the report footer for all meds entered...
  4. dmoran

    Compare mileage in same field

    I can't seem to find an answer in the forum yet - I have a form where a vehicle number is selected from a combo-box and then a current mileage is added in the next field. Is there a simple way to compare the mileage added to the previous mileage entered to make sure the new number makes logical...
  5. dmoran

    Search multiple tables

    I have a co-worker who wants to query two tables using a unique control number as criteria. These tables are identical(one is an archive)in structure and have thousands of records each. Could someone please help me with a way to search both tables for a record? Thanks, David
  6. dmoran

    Clear fields in a form

    I know that this has been a subject here before, but I could not find a solution applicable to me - I have a DB where 1 person enters records. I then have users on a network who are linked to the table. The form gets its record from a single combo box entry - easy enough. Because the...

Part and Inventory Search

Back
Top