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 TouchToneTommy 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: wx5chr
  • Content: Threads
  • Order by date
  1. wx5chr

    Adding by years

    This should be an easy question, but I can't remember how to do it for the life of me. I have a field [Rev_Pub_Date] which is formatted as a date. I want another field [Next_Rev_Date] to be automatically set two years later. Right now I have Next_Rev_Date = Rev_Pub_Date + 730, but this...
  2. wx5chr

    Object Required on EOF

    I am getting an "Object Required" error on the line marked below. Any ideas why? Dim dbTemp As DAO.Database Dim rsTemp As DAO.Recordset Dim strSQL As String Set dbTemp = CurrentDb strSQL = "SELECT T_Dates.Rev_Pub_Date, T_Dates.Current FROM T_Dates " & _...
  3. wx5chr

    Too few parameters on OpenRecordset

    Larry DeLarvelle is looking at this with me, but I wanted to see of anyone else had any ideas. Can someone tell me why I get an error "too few parameters. Expected 2." at the Set rsTemp = dbTemp.OpenRecordset(strSQL) line in the following code? My field types are as follows...
  4. wx5chr

    Automatically uncheck box

    I have a subform which is datasheet view. I would like to have the database automatically uncheck the previous checkbox when a new record is added. What I'm doing is using the check box (CurrentCk) to determine which record is current. example: Amdt 5 12/25/03 CurrentCk = Yes...
  5. wx5chr

    UCase not working

    I have a field (ST) in the main form. Pressing TAB from this field puts the focus into a subform. I want to ensure the state abbreviation is uppercase, so I tried all of the following in the OnLostFocus Event: UCase (Me.ST) UCase Me.ST UCase ("[Me.ST]") Any ideas why none of these...
  6. wx5chr

    Can you count textbox if not part of a table

    I have a dynamic textbox on my report with the following control source: IIf([Next_Rev_Date] < Date(), &quot;OVERDUE&quot;, &quot;&quot;) The textbox name is &quot;Overdue&quot;. Overdue is not a part of any of my tables. I want to count each &quot;OVERDUE&quot; and place it in the Report...
  7. wx5chr

    Counting on a report based on visibility

    I have a report with a hidden field (VIS). This field's .visible property is set to True when it is past due and False when it's not. I'd like to count the number of Overdue items on the report and place it in the Report Footer.
  8. wx5chr

    Selecting which record for a report

    I am trying to show only the most current record in the detail section of my report. I have ABC, Version 1, effective 12/9/1993. I also have ABC, Version 2, effective 12/25/2003. I only want the record with the most recent effective date to be displayed. Here's an example of the layout...

Part and Inventory Search

Back
Top