User Profile

Collapse

Profile Sidebar

Collapse
Jaroslavu
Jaroslavu
Last Activity: Aug 31 '12, 12:23 AM
Joined: Dec 22 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jaroslavu
    replied to If function problem
    in Access
    Sorry for annoying you..and Thanks for help. But to be honest I don't have any patience any more to work on this code..its jus driving me crazy
    See more | Go to post

      Leave a comment:

    • Jaroslavu
      replied to If function problem
      in Access
      Hmm, maybe you have suggestions how I could solve this problem?
      See more | Go to post

        Leave a comment:

      • Jaroslavu
        replied to If function problem
        in Access
        NeoPa,

        Sorry probably you did get me wrong. The problem is that I did debug and it does not show any errors at all. Everything seems to work fine, but at the end - when i chose the options..no matter what options I chose 10 or 120credits it shows the same message that is on the line 77

        Code:
        "Each semester should consist of 30 credits."
        See more | Go to post

          Leave a comment:

        • Jaroslavu
          replied to If function problem
          in Access
          Dear NeoPa,

          Sorry for misunderstandin g, I am beginner at VBA for Access. The code that I have written is the one that goes on button. There is a Form where a user can tick the boxes and select modules he do want to study. After a selection of boxes user presses button and the IF function that I have written above should state whether 60credits in total (30 1semester and 30 2semester) were selected. I tried different approached to code...
          See more | Go to post

            Leave a comment:

          • Jaroslavu
            replied to If function problem
            in Access
            Dear Mihail,

            Thank for your time, but your solution does not solve my problem. I tried to use brackets in my if statements and it still does not calculate the variables..

            Jaroslav ;(
            See more | Go to post

              Leave a comment:

            • Jaroslavu
              started a topic If function problem
              in Access

              If function problem

              Hello everyone, I got some problems with one of my codes. I am making a database where a person can tick boxes and chose 60credits from existing 120. But somehow my if function does not calculate the total..and at the end I get Message "Please chose 30credits per semester"

              I would appreciate some help! Thank you :)

              Code:
              
Option Compare Database

Private Sub ModuleOptions_Click()
              ...
              See more | Go to post
              No activity results to display
              Show More
              Working...