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: 10TR
  • Order by date
  1. 10TR

    Getting the number of days from two dates

    I am using this calculation within a query. I don't know where it was getting that number. I was able to make a change and use DatePart and get the results needed. DatePart("d",[DepreciationDate])-DatePart("d",[DateAcquired]) The numbers are coming out correct now. Here is the rest of the...
  2. 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...
  3. 10TR

    Dim empty records in a report

    Sorry this is hard to explain. I have a report that gives information about meeting rooms. Things like Room number, Presenter Name, Meeting Title, and Meeting Type. Meeting Type is usually populated with something like, Breakout Meeting, General Session, and State Meeting. However when Meeting...
  4. 10TR

    Dim empty records in a report

    For example: The room combo field usuall has a record like "205 206" or something like that. If the room can't be combined then the field is empty but it's still displayed on the report.
  5. 10TR

    Dim empty records in a report

    Is it possible to dim a record in a report if it is null?
  6. 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...
  7. 10TR

    Update table record

    I figured it out. Don't perform the calculation directly in the field but use After Update in the field being calculated and have it post.
  8. 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...
  9. 10TR

    Set Value With a Command Button

    I had to add one more line of code on the first line. I was getting an error message concerning relationships in the database. Refresh.Me corrected the problem. Thanks again for all your help. Private Sub Open_Presenter_Form_Click() Me.Refresh DoCmd.OpenForm "frm-presenter", acNormal, ...
  10. 10TR

    Set Value With a Command Button

    That works perfect!!! Thanks
  11. 10TR

    Set Value With a Command Button

    I received a compile error on this line. Any idea what wrong? Forms!frm-presenter!roomId.DefaultValue = Me!roomId
  12. 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