Recent content by stevegee76

  1. S

    Re-ranking records in tables

    Hi, thanks for replying. I have found a way to do this also using queries and following the example in MS Supports 'Northwind' example database. It also uses queries. This method also uses queries which is where I was having trouble finding information as I was trying to simply do some coding...
  2. S

    Re-ranking records in tables

    Hi. I'm not sure what I'm about to describe can actually be done(easily) but here goes anyway. I have a db which has a form - frmMainForm - bound to a table - SWDataT. In this table are what I refer to as the static values for the condition of roads in an area. Each road has a static value...
  3. S

    Question how to find if a value in one field is also in a field in a different table

    Thanks for your reply and help and sorry for not replying to you sooner. I have had to shelve the project I was working on that would need this functionality for now. Timelines got brought forward and we have had to go with the clunky old manual way for now. Hopefully I will get to re-visit...
  4. S

    Question how to find if a value in one field is also in a field in a different table

    Thanks for your reply, I am aware of the difference between access and excel as you point out. It seems that I may not have been able to communicate exactly what it is I am trying to do. For us amateurs it seems that you need a degree just to ask a question about something like this! At...
  5. S

    Question how to find if a value in one field is also in a field in a different table

    Hi everyone, i have a database where users enter a code for a record into a form which populates a field in one table but I want to now only allow further information about that record to be entered if the code is within a field in another table. I am setting up a database where users will...
Back
Top Bottom