User Profile

Collapse

Profile Sidebar

Collapse
Mac rod
Mac rod
Last Activity: May 5 '11, 07:38 AM
Joined: Mar 15 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Mac rod
    started a topic if statement problem
    in Access

    if statement problem

    hi,

    i want a text box to show "change" if the value of total is less than zero and "balance" if the value is greater than zero. i tried this code on the afterupdate event but it won't work. please help...

    Code:
    If Me.txttotal < 0 Then
Me.txtchange = "change"
ElseIf Me.txttotal > 0 Then
Me.txtchange = "balance"
Else
    ' do nothing
    
End
    ...
    See more | Go to post
    Last edited by NeoPa; May 1 '11, 02:12 AM. Reason: Added the missing CODE tags. Please remember them in future.
    • Mac rod
      started a topic calculate sum in table subform then show in mainform
      in Access

      calculate sum in table subform then show in mainform

      hi everyone,

      I want to build a simple invoice database where i can put a date, and on that date i can put the particulars, quantity amount and sub total and in my main form the total (sum of sub total) where i can deduct the cash at hand if there's any so the total will display the amount the client has to pay. i'm having a problem on making the form or subform where i can input my data, like the particulars and amount where i don't...
      See more | Go to post
      • Mac rod
        replied to select case not working
        in Access
        I found it!!! Thanks to you rural guy! I tried and change the 2nd month as well and found that i messed a lot since i only copy, paste and edit it so, it ended up that some of them have the same name. I should be more careful when coding. aside from the fact that i'm using the field name. Thanks a lot again!!!!!
        See more | Go to post

          Leave a comment:

        • Mac rod
          replied to select case not working
          in Access
          i see the control now i did that also but i didn't change the code. that's why.
          See more | Go to post

            Leave a comment:

          • Mac rod
            replied to select case not working
            in Access
            the 1st month returns the values correctly now
            See more | Go to post

              Leave a comment:

            • Mac rod
              replied to select case not working
              in Access
              Actually to all the data i placed there already, the 1st month returns the best answer. Can you try the 2nd month? and also where do i change the control name?
              See more | Go to post

                Leave a comment:

              • Mac rod
                replied to select case not working
                in Access
                Still it doesn't show the correct values. have you seen the code? i think i did it correctly? the problem is that for example in the code <= 6.99 should be "short" but after i pressed the button it shows "Normal" or "big". and the thing is "big" is in the other "if" statement.
                See more | Go to post

                  Leave a comment:

                • Mac rod
                  replied to select case not working
                  in Access
                  Actually they were numbers before general number and double. Then i tried text, the results were the same.
                  See more | Go to post

                    Leave a comment:

                  • Mac rod
                    replied to select case not working
                    in Access
                    Yup, when it is in the afetupdate event. but the code is in the button. and if ever it updates it returns the wrong values. Different to those that i wrote on the code.
                    See more | Go to post

                      Leave a comment:

                    • Mac rod
                      replied to select case not working
                      in Access
                      Yup! From the form view, the value that pops out when i clicked the results button is already wrong, that's the same value that comes when i hover in the code view. Here's my DB, I really appreciate this man....
                      See more | Go to post

                        Leave a comment:

                      • Mac rod
                        replied to select case not working
                        in Access
                        Nope. It displays the value that i see in the form which is wrong.
                        See more | Go to post

                          Leave a comment:

                        • Mac rod
                          replied to select case not working
                          in Access
                          Yes, but showing other values. like if it should be "normal" it would show "big" or "short" vice versa. And the weight textbox at first it may show for example "low" but if i again click the button it shows "big". and with some values like "60.3" it just won't show anything.
                          See more | Go to post

                            Leave a comment:

                          • Mac rod
                            replied to select case not working
                            in Access
                            where do i see the results? after running the code step by steps up to the End sub nothing happens.
                            See more | Go to post

                              Leave a comment:

                            • Mac rod
                              replied to select case not working
                              in Access
                              How will i know that its the wrong code? most of them turns yellow when i press F8.
                              See more | Go to post

                                Leave a comment:

                              • Mac rod
                                replied to select case not working
                                in Access
                                Hi!
                                What we have done before solves the problem that i have with the combo box. My problem now is that its not returning the correct values that i set. maybe it have something to do with the code being long and almost the same? about the single step, i don't know how to do that either.
                                See more | Go to post

                                  Leave a comment:

                                • Mac rod
                                  replied to select case not working
                                  in Access
                                  hi again, i think this may be a related question since its still the combo box, because when i tested it, the results where all over the place like it would say normal when it shouldn't and sometimes one text box won't display any value at all. i checked the code but it's ok the values are the way they should be. please help.
                                  See more | Go to post

                                    Leave a comment:

                                  • Mac rod
                                    replied to select case not working
                                    in Access
                                    Yes! A really big thanks to you!!! You have been very helpful!
                                    See more | Go to post

                                      Leave a comment:

                                    • Mac rod
                                      replied to select case not working
                                      in Access
                                      This is embarrassing...
                                      actually it might be the answer! it was unbound and nothing is written in the control source. it's working now. thank you very much!
                                      See more | Go to post

                                        Leave a comment:

                                      • Mac rod
                                        replied to select case not working
                                        in Access
                                        yup, still no values and the message box displays "[]"
                                        See more | Go to post

                                          Leave a comment:

                                        • Mac rod
                                          replied to select case not working
                                          in Access
                                          If it is of any help, i made the combo box by choosing the 2nd option in the wizard something like "i will type the values that i want". then typed it in the form view.
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...