User Profile

Collapse

Profile Sidebar

Collapse
RyanT
RyanT
Last Activity: Mar 31 '08, 01:28 PM
Joined: Mar 18 '08
Location: South-Central PA
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • RyanT
    started a topic Execute Command Button click event when pressing ENTER in a text box
    in Access

    Execute Command Button click event when pressing ENTER in a text box

    Access 2000
    Windows XP

    I have a small form with two text boxes:
    - User ID
    - Password

    The form also has two command buttons:
    - Login
    - Cancel

    I would like to set things up so the user can type in his/her ID, click Tab and enter his/her password, then simply press ENTER to login. Right now, when I press ENTER the form sets the focus on the Login button, but I have to press...
    See more | Go to post
    • RyanT
      replied to Merging 2 databases in Access 2007 with auto number in both table
      in Access
      Do the autonumbers have any significance? Are they foreign keys for another table? If not, do exactly as you said and insert the records from A and B into C (records 1-10 on table B will now be 11-20). If the keys do have significance, you may have to look into creating duplicate records in one of the tables, then updating the FK on the child records to point to the duplicate records.
      See more | Go to post

        Leave a comment:

      • RyanT
        replied to Access Report Question
        in Access
        I may not be completely understanding your problem, but it sounds like it would make more sense if you would create a query that summarizes your data. Then, use that query as the source for your report.

        Sorry if I oversimplified this.
        See more | Go to post

          Leave a comment:

        • RyanT
          replied to Make procedure wait for closure of a form to proceed
          in Access
          I believe I just answered my own question....I opened the form in acDialog mode and my problem seems to be solved.
          See more | Go to post

            Leave a comment:

          • RyanT
            started a topic Make procedure wait for closure of a form to proceed
            in Access

            Make procedure wait for closure of a form to proceed

            I am trying to enhance an existing process where the user currently inputs his/her user ID and password in two separate InputBoxes. I created a form with a UserID field and a Password field (with Password input mask). I would like to minimize the impact to the application, so I would like to use this form instead of the InputBoxes.

            The oversimplified version of my process is below. The MainProcess calls the EnterCredential s proc....
            See more | Go to post
            No activity results to display
            Show More
            Working...