Search results

  1. T

    taking code from txtbox/lstbox and inserting into record set.

    Option Compare Database Private Sub btnNewRace_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("tbl_Race", dbOpenDynaset) rs.AddNew !RaceName = Me.txt_RaceName !Season = Me.lst_Season !SchemeID = Me.lst_SchemeID rs.Update rs.Close Set rs =...
  2. T

    Multiple criteria to lookup value.

    Hi, In essence what I am trying to do is to create a lookup in SQL that will look at two fields in a query (qry_RaceResultsWithRankandRaceType) the fields are Rank and SchemeID. Then the lookup will look into the table (tbl_PosistionPoints) and find a record where Posistion is equal to rank and...
  3. T

    Finding a Value based on two Criteria.

    Hi, I have a query that contains two fields that are used to calculate points from another table and add a new field in the query called GamePoints. Here are the relevent entities: qry_GameResults PlayerID Player Rank GameID GameTypeID GamePoints tbl_PosistionandPoints GameTypeID...
  4. T

    Appending a group of players to enter a game.

    Hi, What I essentially am trying to do is to select a group that contains players, then assign that group to a game, the players will all then be assigned using a seperate entry ID to the game instead of one group entry ID, reason being is that each player has their own respective result. In a...
  5. T

    Assigning a value based on a points system

    Hi, I'm making a database for a local remote control car club, What I want to do is to automatically assign points to drivers based on their posistion and different points schemes. For example in Point sceme 1, there would be 5 points for coming first, 3 points for second, 2 points for third...
  6. T

    Problems normalising some data

    Hi guys, Hopefully you can help me with this. I have the following data which I have normalised into what I beleive is 1st,2nd and 3rd normal form. The Problem occurs for me (I think) when I get to third normal form, as you can see I make a new table (RaceEntry) with a compound key comprised...
  7. T

    Question Problem: I need a choice of data to effect another set of data.

    Hi, Ok so I struggled to describe the problem in the thread title so I'll explain it in more detail here. I am making an access database for kart race scenario. The drivers can register for races and track their results for a particular race or agregate races. A driver can have points allocated...
Back
Top Bottom