Search results

  1. S

    Table Structure help

    Thanks for all your suggestions. You are all definitely much more skilled than me at Access. I haven't had the time to try the suggestions yet but I think I can make it work with a little time. Thanks again!!
  2. S

    Table Structure help

    I need some help trying to setup tables on a new database. I want to setup a house analysis database where I can evaluate each room for it’s condition broken down by feature. I can’t seem to figure out a good way to tie all the rooms and evaluations back to that house’s address (primary key)...
  3. S

    How to calculate the previous age of a record

    You fixed it! That works! Thanks a Ton for your Access knowledge! You saved me a lot of aggrevation.
  4. S

    How to calculate the previous age of a record

    :confused: I am trying write a select query to find the past age of the records based on a dated field "consigned date" and select only those records over 10 days old. I would like the user to input the date in time that will be used for the calculation reference. When I try this Access tells...
  5. S

    Help with the "On Key Press" function

    I am trying to get an action to take place when the "enter" key is pressed. The code I have does not recognize the "enter" key. When I put in the "a" key the code works. Can someone please look at the code below and tell me what I need to put in place of "a" to get the code to work with...
  6. S

    Update query to fill in multiple blank fields

    I am having problems trying to structure an update query to look at 4 fields in a table and when a blank space is found in any of the fields to update that blank field and not overwrite any fields that currently have data in that record. Please help show me how to set the criteria to accomplish...
Top Bottom