User Profile

Collapse

Profile Sidebar

Collapse
imz
imz
Last Activity: Mar 27 '07, 11:38 PM
Joined: Feb 21 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • imz
    replied to Record count help
    in Access
    It works! Thanks for the help.
    See more | Go to post

      Leave a comment:

    • imz
      replied to Record count help
      in Access
      There is an "#Error" message that appears inside the textbox when I open it on form view. I should mention that there are no fields on my form, so i'm guessing that's why your method does not work.

      I'm trying to make the record count appear on the main menu screen and unless I put the query fields on the form I think they won't work. I don't want to do that because I want another record count and I can't put 2 different query...
      See more | Go to post

        Leave a comment:

      • imz
        replied to Record count help
        in Access
        Doesn't work, it gives me an error message in the textbox.
        See more | Go to post

          Leave a comment:

        • imz
          started a topic Record count help
          in Access

          Record count help

          I am trying to count the records of a query result and place the answer into a textbox on a form. I have found the DCount function in the help files and tried the following code:

          = DCount("[MonthlyFeeID]", "Monthly Fees Query")

          I keep getting an error about placing something before the equals sign, but I don't know what to put there.

          Thanks
          See more | Go to post
          • imz
            replied to Adding numbers in forms
            in Access
            Thanks, it works perfectly.
            See more | Go to post

              Leave a comment:

            • imz
              started a topic Adding numbers in forms
              in Access

              Adding numbers in forms

              I am trying to add the values I type in two textboxes on a form and i want it to display the answer in a label. I tried this code:

              Code:
               
Private Sub cmdCalculate_Click()
  FATotal.Caption = Str(Val(FA1.Text) + Val(FA2.Text))
End Sub
              But I keep getting an error saying "You can't reference a property or method for a control unless the control has the focus.

              Can somebody please help? Thank...
              See more | Go to post
              Last edited by MMcCarthy; Feb 22 '07, 07:24 AM. Reason: code tags
              No activity results to display
              Show More
              Working...