User Profile

Collapse

Profile Sidebar

Collapse
Rick Shores
Rick Shores
Last Activity: Oct 13 '06, 08:51 PM
Joined: Oct 9 '06
Location: Austin, TX
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Rick Shores
    replied to Problem with MS ACCESS and Excel
    in Access
    We had a slightly similar problem, probably not related. The user who was having this problem was not very experienced, and would hold down the shift key for too long, and sticky keys would turn on, which would keep the shift key held indefinately.

    Long shot, but you may want to look at it, if you haven't got any other ideas!...
    See more | Go to post

      Leave a comment:

    • Rick Shores
      replied to Add a new field into existing database
      in Access
      Kate,

      I PM'd you some click by click instructions.
      See more | Go to post

        Leave a comment:

      • Rick Shores
        replied to Add a new field into existing database
        in Access
        You may have created the field in the table, and the table is working properly, but when you go back to what you're used to looking at, it's not actually the table, but a form that's based on the table. If that's the case, you'll need to add that field into the form as well, which will display records from the table and allow you to choose assessors.

        That may have confused you even more, but here's a general guideline... forms are pretty,...
        See more | Go to post

          Leave a comment:

        • Rick Shores
          replied to Add a new field into existing database
          in Access
          Your database sounds like it's got at least 1 table. When you start your database, hold down the "Shift" key on your keyboard, and the application should open without any default forms opening. That may be causing some confusion. Then, if you go to the main window of your database, you should see (on the left hand side, depending on your version of Access) 'Tables', 'Queries', etc. If you click on 'Tables' you'll see the tables that exist...
          See more | Go to post

            Leave a comment:

          • Rick Shores
            replied to Add a new field into existing database
            in Access
            I'd like to think it would be as simple as opening a table in design mode (by right-clicking on it) and adding an additional row at the end for an additional field. Is that what you're looking for, or is there additional info that we need to have? Are you trying to add it via query, etc? If that's what you're looking for, run with it! If there's something else, post some more info....
            See more | Go to post
            Last edited by Rick Shores; Oct 11 '06, 01:56 PM. Reason: Clarifing instructions

              Leave a comment:

            • Rick Shores
              started a topic Multi-level Access SQL query:
              in Access

              Multi-level Access SQL query:

              Stupid question...

              I have a database, and sometimes it's necessary to move a record from one table to another. I'd like to find a way to (within AccesSQL) to perform the following actions (within 1 query)...

              Select a record from table A based on user input. Accept input from the user for two other fields to be used later.
              Create a record in table B with 3 values from the record in table A. Add the additional info...
              See more | Go to post
              No activity results to display
              Show More
              Working...