User Profile

Collapse

Profile Sidebar

Collapse
opmandrake
opmandrake
Last Activity: Mar 2 '10, 12:14 AM
Joined: Feb 16 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • opmandrake
    replied to VBA - Changing subform field's property from mainform button
    in Access
    Alright, I'll try to as soon as possible...I think I'll have to start it from scratch as there's too much company information, even in the descriptions and code. Thanks for the help, though!
    See more | Go to post

      Leave a comment:

    • opmandrake
      replied to VBA - Changing subform field's property from mainform button
      in Access
      Thanks mshmyob, I tried it though I seem to get a slightly different error:

      "Run-time error '2465': Mainform can't find the field 'frmProductData ' referred to in your expression."

      Of course "frmProductData " is the name of the form...and it still can't find it! How weird is that?

      Oh, I also know that the subforms are each in their own controls, I checked their names and they match the ones...
      See more | Go to post

        Leave a comment:

      • opmandrake
        started a topic VBA - Changing subform field's property from mainform button
        in Access

        VBA - Changing subform field's property from mainform button

        Evening guys.

        Here something that's been driving me nuts for the past couple of hours.

        I have a mainform and in it, two subforms. Normally I'd like the fields to be read-only, but if a user has the right password he'd be able to click on a button on the mainform and turn the "locked" property on all the fields to FALSE.

        Code:

        Code:
        Private Sub cmdEdit_Click()

Dim strPasswd
        ...
        See more | Go to post
        • opmandrake
          replied to Have a combo box list Field captions
          in Access
          Hi ADezii , thanks for the reply.

          Hmm I tried that...no luck though, sorry. The list is then populated with all the values of those particular fields (Joe;Steve;etc) what I have in mind is more like a list of all the fields themselves (Name/Age/Address/etc) instead of the field names (fldName/fldAge/fldAddress...)

          For reference I'm using it as a part of a filter...the user selects the field he wants on the first combo box,...
          See more | Go to post

            Leave a comment:

          • opmandrake
            started a topic Have a combo box list Field captions
            in Access

            Have a combo box list Field captions

            Heya guys. Might be a simple question, but for the life of me I couldn't hit the right search string in google and find what I'm looking for, so I guess I'll bother all of you instead :p

            Alright, the thing is I'd like to create a combo box who's got a table as a source for its Field List. So far so good - the drop-down options are showing up as "fldName", "fldAddress ", etc, cuz I'm a good little boy and set my db...
            See more | Go to post
            No activity results to display
            Show More
            Working...