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 Rhinorhino 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. tempclerk

    More issues with Dates

    Is ACCOUNT.LETTER a date field? Looks like text. Try: WHERE ((([ACCOUNT Query].MAJCOM)=&quot;PRIMARY&quot;) AND (CDate(ACCOUNT.LETTER)<DateAdd(&quot;yyyy&quot;,-1,Date())));
  2. tempclerk

    Override Force New Page?

    Need each department's data to start on new page. Setting Department Header Force New Page to Before Section leaves first page without data. Setting Department Footer Force New Page to After Section forces Report Footer to new page (undesirable, especially when the report is limited to one...
  3. tempclerk

    How to get record to auto tab to new record

    Have you double-checked your tab order? Can you get to a new record via navigation buttons? I've added a &quot;next&quot; button at the end of a form before, but there was some other specific reason for that.
  4. tempclerk

    Syntax for IIf Statement

    Nothing equals Null. Try IsNull([IncidentDescription]).
  5. tempclerk

    Trying to Trim unwanted characters

    Look at the InStr function. You probably want something like: Right([fieldname], Len([fieldname])-InStr(&quot;>&quot;,[fieldname])) (check all syntax - I'm a little out of practice)
  6. tempclerk

    There MUST be a way...Please help! Subreport Troubles!!!!

    Are the Section's CanShrink and CanGrow properties also set to yes? Try decreasing the spacing between subreport controls until they all touch, no white space between and no overlap.
  7. tempclerk

    tabbing thru Tab Control form, keep from advancing to next record

    Don't know about tab controls, but your form has a Cycle property you can set to Current Record.
  8. tempclerk

    How Do You Archive Records In a Database??

    You can link to all your tables, and use a union query if you want to use them all together again. Why do you need to keep each year separate, and how else were you thinking of accessing them again?
  9. tempclerk

    Date criteria from Monday to Date()

    Good point, Michael. I took the question literally and figured it wasn't going to be used on Monday.
  10. tempclerk

    Making new table when data changes from original

    Why in the world would you want to do that?
  11. tempclerk

    Date criteria from Monday to Date()

    Between Date()-weekday(Date(),vbMonday) And Date()-1 should do it; got help from the immediate window.
  12. tempclerk

    Date criteria from Monday to Date()

    How about Between Date()+1-weekday(Date()) And Date()-1? Or tell the weekday function that Monday is the first day of the week (don't use the function, but have heard it can be done) and skip the &quot;+1&quot;.
  13. tempclerk

    Combining text fields to create a date field

    Have you tried something like CDate([month field]&&quot;/&quot;&[day field]&&quot;/&quot;&[year field])?
  14. tempclerk

    Retreat event On Format of report

    Apparently, the Retreat Sub wasn't running, so I moved the code up into the Format sub. This works now, so I'm posting in case it helps anyone else out. Option Compare Database Option Explicit Private Type CodeStatusType Branch As String CodeRt As String End Type Dim CodeStatus As...
  15. tempclerk

    Retreat event On Format of report

    In attempt to undo the calculations performed in the first pass of the format event, I added the following sub: Private Sub Detail_Retreat() 'back up before second formatting If StatusFlag = &quot;+&quot; Then 'If it's a duplicate, previous was the same...
  16. tempclerk

    Multiple IIF statements

    Um, yeah. Concatenating would be simpler than nesting.
  17. tempclerk

    Multiple IIF statements

    You would need to nest your IIfs, more like: IIf([Local School Districts]=-1,&quot;Local School Districts&quot; & IIf([Academic Educators]=-1,&quot;Academic Educators&quot;,&quot;&quot;),&quot;&quot;) IIf(condition1, truepart & IIf(condition2, truepart & IIf(condition3...
  18. tempclerk

    Retreat event On Format of report

    The following code marks claim numbers in a report if they are duplicates of the previous claim number printed or if there is a gap in sequence between the current and previous claim numbers. Michael Red got me to the point that this works, except that when the list goes on to a new column or...
  19. tempclerk

    REFERING TO TWO FIELDS IN 2 DIFFERENT FORMS

    If your LoadingCity is Not In List of a combo box, try Forms![PreviousForm]![LoadingCity].text
  20. tempclerk

    Date Range to Display in Report

    What in your macro is calling for the dates? Your query doesn't need to be open before the report, but the form does, otherwise Access has nowhere to look for the dates and will ask you for them.

Part and Inventory Search

Back
Top