User Profile

Collapse

Profile Sidebar

Collapse
NMarks
NMarks
Last Activity: Apr 8 '08, 12:58 PM
Joined: Feb 11 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • NMarks
    replied to Search Form using Option Buttons
    in Access
    Alright I finally got it.

    This is the end result of my code ...

    Code:
    Private Sub SearchFor_AfterUpdate()
On Error GoTo Err_SearchFor_AfterUpdate
    Dim MySQL As String
    
    MySQL = "SELECT KeyNumber, KeyCode, KeyName "
    MySQL = MySQL & "FROM tKey "
    
    If InStr(1, Me.SearchFor) Then
        MsgBox "Do not use quotes"
    ...
    See more | Go to post

      Leave a comment:

    • NMarks
      replied to Search Form using Option Buttons
      in Access
      The unique Key Number field is a letter/numeric value. It contains 2 letters followed by 6 numbers manually entered by us, the user.

      An example is "HB123456".

      The KeyCode and DoorNumber fields are also setup the same way. Just less letters and numbers....
      See more | Go to post

        Leave a comment:

      • NMarks
        replied to Search Form using Option Buttons
        in Access
        I will have to edit this then.

        The majority of my Access experience has been via Google and a guy I work with. He uses the Chr(34) a lot and I picked it up along the way.

        Thank you for the advice....
        See more | Go to post

          Leave a comment:

        • NMarks
          replied to Search Form using Option Buttons
          in Access
          In order to get all the forms to display in a tabular format like I wanted, and linked together, I had to create the form, then the "main" subform labeled sfKeyList.

          The 2 additional subforms are sfDoorList and sfStaffList which are both subforms of sfKeyList.
          See more | Go to post

            Leave a comment:

          • NMarks
            started a topic Search Form using Option Buttons
            in Access

            Search Form using Option Buttons

            Hello all,

            I have created a database for my work that stores information for keys/locks, doors and employees.

            Specifically the database contains all the information of our lock system, which doors certain locks are attached to and what employees have keys to certain locks.

            The form has 3 subforms, 1 is the Key List which is basically the master subform as the other 2 subforms are a Door List and Staff...
            See more | Go to post
            • NMarks
              replied to How do I print a report based off of a continous form's search results?
              in Access
              The Search is actually done by an On-Click Command.

              I have multiple text boxes allowing a user to search by 4 different items as well as by date range.
              See more | Go to post

                Leave a comment:

              • NMarks
                started a topic How do I print a report based off of a continous form's search results?
                in Access

                How do I print a report based off of a continous form's search results?

                Hello,

                I currently have a continous form that has a search field in the header. The search works without issue, but I want to be able to print a report based off the search results.

                All the records have there own unique Record ID and they are all pulled from the same table.

                I know how to print a report based off 1 record, but I can't for the life of me figure out the above problem.

                Any...
                See more | Go to post
                No activity results to display
                Show More
                Working...