User Profile

Collapse

Profile Sidebar

Collapse
Tempo
Tempo
Last Activity: Apr 7 '20, 08:42 AM
Joined: Jun 10 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tempo
    replied to Counting Specific Records within a Table
    in Access
    You're absolutely correct, Mihail, brackets are necessary when numbers, spaces, or some other character is used in Object and Control names.

    When you included the expression I sent I could clearly see my mistake. A small, but critical one at that. Are you ready? The domain is "tblCheck" not "tblChecks" .

    There you are...problem resolved. Much thanks goes out to you and "Hats Off" to Rabbit as...
    See more | Go to post

      Leave a comment:

    • Tempo
      replied to Counting Specific Records within a Table
      in Access
      I was experimenting with different bracket and quote positions, but none of my combinations appear to work. Here's the last failed attempt:
      Code:
      =DCount("[ChkAmt]","tblChecks","[ChkAmt]>50")
      See more | Go to post
      Last edited by zmbd; Jun 20 '13, 01:16 PM. Reason: [z{placed required code tags}]

        Leave a comment:

      • Tempo
        replied to Counting Specific Records within a Table
        in Access
        Hi Rabbit! Thanks for responding. I modified the expression to
        Code:
        =DCount("[ChkAmt]","tblChecks","[ChkAmt]>50")
        and
        Code:
        =DCount("[ChkAmt]","tblChecks","[ChkAmt]">"50")
        . In both instances the result was #Error. Does the solution have anything to do with whether or not I'm using brackets and quotes appropriately?.

        I would have responded sooner, but was searching...
        See more | Go to post
        Last edited by zmbd; Jun 20 '13, 01:15 PM. Reason: [z{placed required code tags}]

          Leave a comment:

        • Tempo
          started a topic Counting Specific Records within a Table
          in Access

          Counting Specific Records within a Table

          Using Access 2010, I would like to count all check amounts greater than $50 within a table. So far I’ve used the expression
          Code:
          = DCount("[ChkAmt]","tblChecks","txtChkAmt > 50")
          , but this expression results in “#Error”. I believe I may have a problem with the “Domain” part of the syntax. The Objects and Controls I’m using are: tblChecks (a Table); ChkAmt ( a Field); and txtChkAmt (a Text...
          See more | Go to post
          Last edited by zmbd; Jun 20 '13, 01:17 PM. Reason: [z{placed required code tags}]
          • Tempo
            replied to Return to The Same Record After Closing a Form
            in Access
            Hello again Rabbit,

            Problem resolved. Discovered some overriding code in "frmMember" 's On Activate Property.

            Once again, I'm grateful. Your response motivated me to dig a little deeper. Thanks! And the best of success in life for you.
            See more | Go to post

              Leave a comment:

            • Tempo
              replied to Return to The Same Record After Closing a Form
              in Access
              Hi Rabbit,

              Thanks for the response. "frmMembers " remains open as indicated on the "Tab Control" and "frmViewReports " opens on its own "Tab". It's just that when I close "frmViewReports " it appears to automatically perform some type of requery action and ends up displaying the last record in the recordset.

              I can't understand it unless I have an unknown procedure in one or...
              See more | Go to post

                Leave a comment:

              • Tempo
                started a topic Return to The Same Record After Closing a Form
                in Access

                Return to The Same Record After Closing a Form

                I have a form named "frmMembers " with a command button that opens another form named "frmViewReports ". Whenever I close "frmViewReports ", "frmMembers " automatically goes to the last record (Member) in frmMembers.

                I would like to be able to return to the same record that was displayed prior to opening and closing "frmViewReports ).
                See more | Go to post
                • Tempo
                  started a topic Convert Currency to Text
                  in Access

                  Convert Currency to Text

                  I would like to create a module in Access 2010 to convert currency to display a text string as follows:

                  Convert 543.27 to display Five Hundred Forty-Three and 27/100

                  Thanks to anyone willing to assist in this matter
                  See more | Go to post
                  • Tempo
                    replied to Partial Display of List Items
                    in Access
                    Hi Guys!

                    This is to say a "Big Thank You" to both Mihail and NeoPa for each of your responses to my question. The code snippets are definitely a step in the right direction.

                    Not sure what I need to do to close this thread, but it's a done deal.


                    Thanks again, Tempo
                    See more | Go to post

                      Leave a comment:

                    • Tempo
                      started a topic Partial Display of List Items
                      in Access

                      Partial Display of List Items

                      I have a list box control on an Access 2007 Form called "lstReports ". I would like to populate this list box with report names like: rptMaintParts, rptMaintWorkord ers, rptMaintParts On Order, etc. However, I do not want the "rptMaint" part of the report name to display in the text box. I once had the code to provide this functionality, but that was many years ago.

                      I would appreciate it greatly if someone would lead...
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...