User Profile

Collapse

Profile Sidebar

Collapse
3338761
3338761
Last Activity: Feb 4 '08, 09:47 PM
Joined: Jan 16 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • 3338761
    started a topic Setting the default value in a subform
    in Access

    Setting the default value in a subform

    I have a 'Creator' form, and within this is a 'Reports' subform where you can scroll through all of the reports that the creator has made.

    On my reports form I have a button that opens another 'Change' form that allows you to change the creator of the current report. However, I cannot get this 'Change' form to display the report that is currently open when it loads.

    In the 'Change' form I have a textbox which I want...
    See more | Go to post
    • 3338761
      started a topic Disabling mouse wheel in a subform
      in Access

      Disabling mouse wheel in a subform

      I fished through previous posts and found this link to microsoft's site for the code and steps to disable the mousewheel from scrolling through records:

      http://support.microso ft.com/defaul...kb;en-us;278379

      It worked for my main form (Creator) with no problems. I copied the 3rd section of code (please refer to link) which is form-specific to the subform (Reports). When i open the subform (Reports) on its own, the msgbox...
      See more | Go to post
      • 3338761
        replied to Hiding a form: If conditions
        in Visual Basic
        Thanks for all of the help guys, input from both of you helped me solve the problem. To get it all to work, and in the same condition it ended up looking like this, in case somebody in the future has the same problem:

        Code:
        Employee_First_Name.SetFocus
    If Employee_First_Name.Text = "" Then
        Me.Report_Sub.Visible = False
    ElseIf Employee_First_Name.Text <> "" Then
        ...
        See more | Go to post

          Leave a comment:

        • 3338761
          replied to Hiding a form: If conditions
          in Visual Basic
          Ok now it's getting more interesting...

          I added the setfocus control, and have the following code:

          Employee_Last_N ame.SetFocus
          If Employee_Last_N ame.Text = "" Then
          Me.Report_Sub.V isible = False
          Else: Employee_Last_N ame.Text = ""
          Me.Report_Sub.V isible = True
          End If


          For some reason, when i scroll through my records,...
          See more | Go to post

            Leave a comment:

          • 3338761
            replied to Hiding a form: If conditions
            in Visual Basic
            I tried this code, and still got the same error as before:

            "You can't reference a property or method for a control unless the control has the focus."

            I have no idea what this means. Also, I am using Access 2000 and I assume an older version of VB as well because there is no 'SelectedValue' for my combobox, only 'SelLength' 'SelStart' and 'SelText'. I obviously used 'SelText' and get the same error as I did...
            See more | Go to post

              Leave a comment:

            • 3338761
              started a topic Hiding a form: If conditions
              in Visual Basic

              Hiding a form: If conditions

              I'm a beginner programmer so bear with me if this seems very simple...

              I have a subform which I don't want to have displayed until the user has entered first name, last name, extension, and chose a dept. from a combobox.

              The If condition I tried for the first name was:

              If Me.Employee_Fir st_Name.Value = Null Then
              Me.Report_Sub.V isible = False
              Else
              Me.Report_Sub.V isible...
              See more | Go to post
              No activity results to display
              Show More
              Working...