User Profile

Collapse

Profile Sidebar

Collapse
sunridge
sunridge
Last Activity: Feb 21 '07, 08:10 PM
Joined: Feb 2 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sunridge
    replied to Option Group in Reports
    in Access
    It worked! Thanks Mary.

    Val...
    See more | Go to post

      Leave a comment:

    • sunridge
      replied to Checkboxes in reports
      in Access
      Yes you did. Somehow I got off on another tangent.

      Thanks again...
      See more | Go to post

        Leave a comment:

      • sunridge
        started a topic Option Group in Reports
        in Access

        Option Group in Reports

        I have a database that has some Option Groups. In the Report it displays the option as a number (1, 2 or 3) but I want it to display the text instead. I was told to use the Choose function as follows:
        =Choose([YourField], "Text1", "Text2", "Text3")

        Where do I type this in?

        Val
        See more | Go to post
        • sunridge
          replied to Checkboxes in reports
          in Access
          I found something that works (in a Microsoft Office discussion group). In the Detail section of the Report (in design view) go to Properties and On Format. Put in the following code:
          Me.checkbox1.Vi sible = Me.checkbox1
          Me.checkbox2.Vi sible = Me.checkbox2
          Me.checkbox3.Vi sible = Me.checkbox3

          etc. etc.

          It seems to work.

          Thanks for your help and patience....
          See more | Go to post

            Leave a comment:

          • sunridge
            replied to Checkboxes in reports
            in Access
            I want to produce a Report from a Table. The table has check boxes. In the report I only want to show the check boxes that are checked off. In other words I want to hide blank check boxes in the report. I was told to make a Query and indicate "True" in the Criteria section of the fields that are check boxes. From there I got totally lost....
            See more | Go to post

              Leave a comment:

            • sunridge
              replied to Checkboxes in reports
              in Access
              In the Report I only want the checkboxes that are checked off to show. I don't know how to say that in SQL....
              See more | Go to post

                Leave a comment:

              • sunridge
                replied to Checkboxes in reports
                in Access
                Here it is:

                Code:
                SELECT [Registration Number],[Address],[Builder],[PO#],
       [Model],[Expected Completion Date],[Registration Date],
       [Heated Ceiling (w/attic)],[Heated Ceiling (w/o attic)],
       [Exterior Walls],[Basement Walls],[Overhanging Floors],
       [Ventilation],[Duct Sealing],[Fireplace],[Windows1],
       [Windows2],[Windows3],[Windows4],[Patio Doors],[Heating],
       [Water
                ...
                See more | Go to post
                Last edited by NeoPa; Feb 5 '07, 03:50 PM. Reason: Tags and Layout for Viewing

                  Leave a comment:

                • sunridge
                  replied to Checkboxes in reports
                  in Access
                  I have several check boxes so I have typed True into the Criteria section of each one. Then I go into SQL View and copy all that's in there? Where do I paste it?...
                  See more | Go to post

                    Leave a comment:

                  • sunridge
                    replied to Checkboxes in reports
                    in Access
                    I'm afraid I'm totally lost. I made a Query using the wizard and then went into Design View. I can't find a Control Source here only Criteria....
                    See more | Go to post

                      Leave a comment:

                    • sunridge
                      replied to Checkboxes in reports
                      in Access
                      I want the entire record to not be shown so I will use ADezii's solution.
                      I entered True into the Criteria of the checkboxes (in Design View) and then ran the Query. The resulting table was empty. I'm sorry, I don't know what SQL is (I guess I have some learning to do!)...
                      See more | Go to post

                        Leave a comment:

                      • sunridge
                        replied to Checkboxes in reports
                        in Access
                        Where is the On Render event?...
                        See more | Go to post

                          Leave a comment:

                        • sunridge
                          replied to Checkboxes in reports
                          in Access
                          I made the query as you said. But when I ran the Query the resulting table came up empty....
                          See more | Go to post

                            Leave a comment:

                          • sunridge
                            replied to Checkboxes in reports
                            in Access
                            Thanks, but I don't have a Query for the Report.
                            See more | Go to post

                              Leave a comment:

                            • sunridge
                              started a topic Checkboxes in reports
                              in Access

                              Checkboxes in reports

                              Hi everyone,

                              I am fairly new to Access and have only set up simple databases. The database I am working on now has check boxes. In the Report I only want the check boxes that are checked off to show. How do I do that?

                              Thanks
                              See more | Go to post
                              No activity results to display
                              Show More
                              Working...