User Profile

Collapse

Profile Sidebar

Collapse
David1129
David1129
Last Activity: Oct 26 '06, 11:19 AM
Joined: Oct 24 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • David1129
    replied to Make a Report Display the Current Record in a Form
    in Access
    Here's a snippet of code that should do the job for you.

    /CODE/
    Dim stLinkCriteria As String
    Dim stPrintOption As String


    If Me![cboReportOutput] = REPORTOUTPUT_PR EVIEW Then
    stPrintOption = acPreview
    Else
    stPrintOption = acNormal
    End If

    stDocName = "rptSystemInfor mation"
    stLinkCriteria...
    See more | Go to post

      Leave a comment:

    • David1129
      replied to Using the On Click event on a tab control
      in Access
      In place of the Page On Click event, use the Tab On Change event, such as

      /CODE/
      Dim bytTabNow As Byte

      bytTabNow = Me!TabDetail.VA LUE
      /CODE/

      where the Tab Control is named "TabControl ". The VALUE returned will be the "Page Index" value of the page that was clicked.

      Dave
      See more | Go to post

        Leave a comment:

      • David1129
        started a topic Access 2007 and Filtering
        in Access

        Access 2007 and Filtering

        I'm working on testing a large application with Access 2007. It has been running under 2003 and XP with no obvious errors.

        However with 2007 many forms seem to have lost the ability to filter. When the form is loaded, the record source specifed, a filter applied, and filtering set to on, either no records are displayed, or ALL of the records displayed.

        Click on the "Toggle Filter" on the ribbon and voila, the...
        See more | Go to post
        No activity results to display
        Show More
        Working...