User Profile

Collapse

Profile Sidebar

Collapse
Techie1201
Techie1201
Last Activity: May 6 '10, 02:23 PM
Joined: Apr 21 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Techie1201
    replied to Single lstbox with 3 text boxes
    in Access
    Thanks for the reply, but I couldn't get that to work. I copied your example in, changed it to my values and got compile error. Doesn't like this.

    '" & strValue1 & "'

    I will play with it some more. Just learning so forgive me if I am missing the obvious.
    See more | Go to post

      Leave a comment:

    • Techie1201
      started a topic Single lstbox with 3 text boxes
      in Access

      Single lstbox with 3 text boxes

      Hi all,

      Still trying to get a grip on lstboxes. This is my latest syntax error.

      Form is setup this way.

      one unbound multi-select lstbox (lsttechnique) populates correctly set to extended column count 1 bound column 1.

      3 unbound txtboxes as follows:

      txtbrfid dtatype number
      txtfreq datatype number
      txttotdur datatype number

      brfid is pulled from form...
      See more | Go to post
      • Techie1201
        replied to Getting data from second list box into table
        in Access
        Thanks to both Adezii and Neopa for your help. The form works perfectly.

        Russ
        See more | Go to post

          Leave a comment:

        • Techie1201
          replied to Getting data from second list box into table
          in Access
          Morning,

          NeoPa-you are correct with the no need for the extra validation in a perfect world but with the environment I work in and the reports that are generated form this DB going to State Agencies, I want to give the end user every chance not to mess up.

          With that said, there is one part more I need to do with this form. beisdes the 2 list boxes there is a textbox (unbound) named (brfid)(number) that pulls information...
          See more | Go to post
          Last edited by NeoPa; Apr 22 '10, 12:47 PM. Reason: Please use the [CODE] tags provided.

            Leave a comment:

          • Techie1201
            replied to Getting data from second list box into table
            in Access
            Thank you all for your responses. I am going to try what ADezii suggested.

            To answer your question about one lstbox using multi-select-that is how I set up the form originally. The issue we had was the end-user was sometimes adding the wrong staff.

            Me being new to this-was able to figure out how to use suggested code posted in forums, reading the Access Bible, and access help menues. What I didn't do is put in some...
            See more | Go to post

              Leave a comment:

            • Techie1201
              started a topic Getting data from second list box into table
              in Access

              Getting data from second list box into table

              I have a form with 2 listboxes. lst1 is populated with staff names (first and last concatenated) from a query. Ii is set to mutli-select.

              lst2 is populated with selections from lst1 (it is set to valuelist) using a cmd button with the following code:
              Code:
              Public Sub CopySelected(ByRef frm As Form)

Dim ctlSource As Control
Dim ctlDest As Control
Dim strItems As String
Dim intCurrentRow As Integer
              ...
              See more | Go to post
              Last edited by NeoPa; Apr 21 '10, 04:54 PM. Reason: Please use the [CODE] tags provided.
              No activity results to display
              Show More
              Working...