Search results

  1. K

    Desciptions don't show on report

    well you have to create queries joining your child tables to its master tables and use that query as your recordsource on your report :)
  2. K

    Return Most Recent Date

    SELECT Table1.a_id, Max(Table1.date) AS MaxOfdate, Sum(Table1.points) AS SumOfpoints FROM Table1 GROUP BY Table1.a_id;
  3. K

    Maybe ive over complicated this database.

    why dont yuo just do it this way soldier(SoldierID, SSN, LastName, FirstName.....) soldier_phone(SoldierID, PhoneID, Number, Type (cell or home)) maybe you did complicate it a bit :)
  4. K

    how to check if a record is currently edited by another user?

    yes this is what i did i already solved the problem, i created a function that would edit the table (actually i just issue a .edit then .update simultaneously) if an error occured the function will send a flag. the table is not that big anyway (max 20 records). thanks pat
  5. K

    assigning a number to a record

    try to use your_field = format(your_number,"000")
  6. K

    how to check if a record is currently edited by another user?

    im running access97 on an NT environment using DAO my question is this - is there a way to check in code whether a record is currently edited by another user. my problem is this i have table A with 2 fields bank# and date. users always edit the date field in table A. now in other modules there...
Top Bottom