User Profile

Collapse

Profile Sidebar

Collapse
DarrenOxley
DarrenOxley
Last Activity: Jul 30 '07, 08:26 AM
Joined: Jul 11 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DarrenOxley
    replied to displaying search result in an excel format or else
    in Access
    Hi

    Have to make this quick as I have a train to catch!

    Use the Column function

    Code:
    public vValArray ()

Redim vValArray(me.ListBox.ListCount)

For vloop 0 to ListBox.Listcount
vValArray(vloop) = ListBox.Column(Column,vloop) ' (vloop is each row in the 
listbox)
Netx vloop
    vValArray(n) now contains each value, if you want...
    See more | Go to post

      Leave a comment:

    • DarrenOxley
      replied to List Box Counter of Items Selected
      in Access
      Hi Schmidt
      Yep its dead easy try this

      [Code]

      Private Sub List0_AfterUpda te()

      For loop1 = 0 To Me.List0.ListCo unt
      If Me.List0.Select ed(loop1) = True Then vCounter = vCounter + 1
      Next loop1

      Me.Text2 = vCounter


      End Sub

      List0 is my list box, Text2 is the name of my text box.
      You can also use this...
      See more | Go to post

        Leave a comment:

      • DarrenOxley
        replied to Record Number retrieval
        in Access
        Use the CurrentRecord function.

        for example

        Private Sub Form_DblClick(C ancel As Integer)

        MsgBox CurrentRecord

        End Sub
        See more | Go to post

          Leave a comment:

        • DarrenOxley
          replied to How to compare two or more preceding cells in ms acess
          in Access
          Hi there, I only joined this site about 2 mins ago so your my first point of contact. I think I can help you.

          1) Open a query in Access
          2) Only bring in the fields that make the record a duplicate, except for the UniqueID for each record (bring this is twice)
          3) click the totals button in the toolbar (looks like a backwards E)
          4) The first UniqueID, select First from the grouping options.
          5) The second...
          See more | Go to post

            Leave a comment:

          No activity results to display
          Show More
          Working...