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 Wanet Telecoms Ltd 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: 10TR
  • Content: Threads
  • Order by date
  1. 10TR

    Getting the number of days from two dates

    Hello, I am try to get the number of days only from two dates in an Access query. I need the days to calculate depreciation for an asset. It works fine in Excel but I am getting the wrong number in Access. DATEDIF(C9,$B$4,"md" = 5 Days Date1 = 7/26/2008 Date2 = 3/31/2011...
  2. 10TR

    Dim empty records in a report

    Is it possible to dim a record in a report if it is null?
  3. 10TR

    Open Form to see specific records

    I am using seven forms to enter information about a venue.The active form contains the primary key record that is also carried to the related second. example: (frm-room.roomId (primary) to related frm-presenter.roomId.) I have been using this code to open forms, set values, and close forms...
  4. 10TR

    Update table record

    I have a table named tblroom with a field named theater. I want to update the table field from a calculated field called theater in the form called frm-room. The record in the form creats a sum from a calculation. I need to have it populate the record theater in the table. I have done this...
  5. 10TR

    Set Value With a Command Button

    Here is my goal: I have two forms with an command button on the primary that opens the secondary form with the current record ( "roomId" ) on the primary and secondary. The primary form name is: "frm-room" with roomID as the primary key. I want it to set a value to the secondary form...

Part and Inventory Search

Back
Top