User Profile

Collapse

Profile Sidebar

Collapse
dlowry
dlowry
Last Activity: Jan 10 '07, 03:24 PM
Joined: Oct 16 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dlowry
    replied to Error!
    in Access
    Right ok - I've now changed the values in tblcontacts. ContactID still exists with new entries.What was MJW is now changed to williams, michael. This now displays the form in full (frmcontacts). I would like to keep my ContactID as MJW. Any chance ?
    See more | Go to post

      Leave a comment:

    • dlowry
      replied to Error!
      in Access
      Unfortunately this still doesnt pick any information up.... any other ideas ?
      See more | Go to post

        Leave a comment:

      • dlowry
        started a topic Error!
        in Access

        Error!

        When clicking a name in my list box i get the following....

        Run time error 3075
        Syntax Error (comma) in query expression 'contactID=will iams, michael'.

        Private Sub LstCName_DblCli ck(Cancel As Integer)
        Dim stDocName As String
        Dim stLinkCriteria As String

        stDocName = "frmcontact s"
        stLinkCriteria = "ContactID= " & Me.LstCName

        DoCmd.OpenForm...
        See more | Go to post
        • dlowry
          replied to list box probs
          in Access
          i'll keep it simple for now...

          ContactID
          FirstName
          LastName
          See more | Go to post

            Leave a comment:

          • dlowry
            replied to list box probs
            in Access
            Appreciate your help.... from what you've given me it now opens the form fine.....but no data within. Any ideas ?
            See more | Go to post

              Leave a comment:

            • dlowry
              started a topic list box probs
              in Access

              list box probs

              I need help here...
              I have created a list box (LstCName) from a form named (contactlist) that picks up employee names from a query named (lkpcontacts). The employee names are displayed fine but when i click on a name, i want it to take me to that persons details which are stored in (frmcontacts). At the moment it's not doing it... can you help.




              Private Sub LstCName_DblCli ck(Cancel As Integer)
              '...
              See more | Go to post
              • dlowry
                started a topic List box and command button.
                in Access

                List box and command button.

                I've created a list box with employee names in it. when highlighting and clicking the search command button i've created it does nothing... can someone give me a code to use so when selecting the employee and hitting search it goes to that users information.
                See more | Go to post
                • dlowry
                  started a topic tab control.
                  in Access

                  tab control.

                  Can anyone help... i've created a new tab control with several pages and want to know how i can use information from one table on one page and and information from another table on another page... doe this make sense ?

                  Thanks
                  See more | Go to post
                  • dlowry
                    replied to Searching records using a list box.
                    in Access
                    Option Compare Database
                    Option Explicit
                    Private Function basOrderby(col As String, xorder As String) As Integer
                    Dim strSQL As String

                    'Clear captions from command buttons
                    ClearCaptions

                    'Set row source for list box
                    strSQL = "SELECT DISTINCTROW AssetID, AssetsFirstName , AssetsLastName, PCNumber "
                    strSQL = strSQL & "FROM Assets "
                    strSQL...
                    See more | Go to post

                      Leave a comment:

                    • dlowry
                      started a topic Searching records using a list box.
                      in Access

                      Searching records using a list box.

                      I'm currently using access 97. I'm relatively new to all this, so have attempted to create a company Asset Register when i've come across a problem im unsure of. I'm trying to create some sort of search finder that enables me to navigate to the fields i require quickly.
                      I've done this using a list box with FirstName, LastName and PCNumber as the search headings. Above that are a set of command buttons that search both ascending and descending....
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...