User Profile

Collapse

Profile Sidebar

Collapse
edgalljr
edgalljr
Last Activity: Nov 19 '09, 09:06 PM
Joined: Sep 15 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • edgalljr
    replied to Apply Filter to Form & Subform
    in Access
    That screaming you hear is me! That works perfectly and I think I now understand the concept! Thank you so much!
    See more | Go to post

      Leave a comment:

    • edgalljr
      replied to Apply Filter to Form & Subform
      in Access
      Actually, I want a single button on the main form. When I click the button, I want to know all of those people with No Duty Station. This will mean that either A) there is a linked record but Duty Station Is Null OR B) there is NO linked record.
      See more | Go to post

        Leave a comment:

      • edgalljr
        replied to Apply Filter to Form & Subform
        in Access
        This database contains 2 relevant tables. "tbl Master" contains all personal information (Person ID, Name, Branch, count, etc.) and a second table called "tbl Rank Rate Location" contains only Person ID, Rank, MOS Rating, and Duty Station. Person ID is common and links the two tables.

        On the form I am working with, all of the information from "tbl Master" is displayed on the form "frm Master Tracker"....
        See more | Go to post

          Leave a comment:

        • edgalljr
          replied to Apply Filter to Form & Subform
          in Access
          ChipR... Thanks for the response. When I run the script I get an "Enter Parameter Value" for both "Duty Station" and "Me!sub Rank Rate Location.Form!D uty Station"
          See more | Go to post

            Leave a comment:

          • edgalljr
            started a topic Apply Filter to Form & Subform
            in Access

            Apply Filter to Form & Subform

            I have a Button on a form that filters on 2 fields using the following code:
            Code:
            Private Sub cmd_NavyDue_Click()
With Me
.FilterOn = True
    DoCmd.ApplyFilter , "[Branch] = 'NAVY' And [Count]>1"
    Me.OrderBy = "[Person ID] DESC"
    Me.OrderByOn = True
End With
End Sub
            This works fine. However, I also want to filter on a field in a Subform when no record exists (or Is Null)....
            See more | Go to post
            Last edited by NeoPa; Nov 18 '09, 12:14 AM. Reason: Please use the [CODE] tags provided.
            • edgalljr
              replied to Close An Open Excel Spreadsheet from Access VBA
              in Visual Basic
              Thank you for the code.. it does work. However, I actually want the spreadsheet to remain open after it is created. I want to close any open spreadsheet before the 'DoCmd.OutputTo ...' is run and leave the resulting spreadsheet open until the code is run again.
              See more | Go to post

                Leave a comment:

              • edgalljr
                started a topic Close An Open Excel Spreadsheet from Access VBA
                in Visual Basic

                Close An Open Excel Spreadsheet from Access VBA

                I have Access 2000 programmed to run a very simple code to run a query and OutputTo an Excel spreadsheet:

                DoCmd.OutputTo acOutputQuery, "XLS Applicants", acFormatXLS, "C:\My RMBC Reports\Applica nts.xls", True

                If, however, the user attempts to run the code a second time, without closing the Excel spreadsheet, they get a Runtime Error. I need to know how to close the spreadsheet (if it is opened)...
                See more | Go to post
                No activity results to display
                Show More
                Working...