Search results

They're hidden :) Goto Tools - Options - View - Hidden Objects

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...

Thank-you!!! :eek: :D Here it is now! :) I added to your Reputation ;) Matthew

Relationships - Referential Integrity Is this better?

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...

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...

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...

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...

Bob, Thanks for the help, will putting in a auto number field with primary key work do you think, into each of the LUtables? Matthew

I followed your instructions, and the data is still scrambled (record order changed), any other suggestions? Matthew

Part of the database was already bult by somebody else, tables were not made replacable and a design master was not made. Here is link to the database, not sure if anybody can help...

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...

RuralGuy Have followed your instructions, the zipped database file is available here: http://www.scoutingtimaru.org.nz/dbtest/Access%202000%20Training.zip Thanks for any help you can give. Matt

Thanks Ruralguy, will do. and post again when done, Matt

Ruralguy, Have converted to run with Access 2000, and has been uploaded to http://www.scoutingtimaru.org.nz/dbtest/ Thanks for the replies. Matt

-------------------------------------------------------------------------------- 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...

Dtabase help needed, can somone debug please? 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 debug the problem, would very...

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