Search results

  1. M

    Referential integrity and forms

    Hi all, Many thanks for all the help thus far with my Scout Database :) I have a problem with referential integrity, I am getting errors. In my form 'frmHeader' , when I select a member, and click achievements (a command button in top right corner) i always have to enter a date, it never...
  2. M

    Referential integrity - help required

    Hi, I'm making a database with frontend and backend. I have one form, called frmHeader, for PersonalName data. (shown in screenshot080.jpg) you click achievements, to get another form to enter achievement data, based on the member's section. How should i establish referential integrity...
  3. M

    Paremeter value problem - any help appreciated

    Hi all, I am a novice with Microsoft Access, and any help would be appreciated :) This is my Database "Forms.frmMemberSelect.IDNo" is set as the criteria for the ID field in all of the "QryRecordCards..." queries. This sets the Members ID to a Public Integer called "IDNo" in...
  4. M

    CheckBoxes

    I am trying to use check boxes as a yes/no answer about whether members have completed training modules, and bind them to a table. I get this error when tick the boxes, and try to close the form; "The changes you requested to the table were not successful because they would create duplicate...
  5. M

    Transfer Age problems

    Many thanks for previous help I have been given Here is a link to my database: Database I want to calculate the Transfer Age of a member to the next section, from his/her Date Of Birth. DateOfBirth is a textbox where the Date of Birth of the member is entered, on the Personal tab of...
  6. M

    Is it possible to make a table replicable thats already been created

    I have tables in a database that are not ticked replicable at present (tick button is greyed out), this is causing the records in the table to become scrambled when we attemp to replicate the database. Any advice please, with over 50 tables in the database we don't feel inclined to start from...
  7. M

    Can somebody help me debug a problem?

    -------------------------------------------------------------------------------- Hi guys, I have a database made with Access, have uploaded here: http://www.scoutingtimaru.org.nz/dbtest/Training.mdb (8.9MB) When I create a new user, the programs creates two blank users. Can anybody help...
  8. M

    Database entry problem

    Have created database with Access 2003 , every time I create a new person (new record), the database creates 2 new blank members (blank records), can anybody help. :confused: Can upload the database (7MB) if anybody prepared to help debug the problem. Thanks in advance :) Matt
Back
Top Bottom