I have an Access database with three tables, Family, Clients and Sessions. The Family table has an autonumber field, F_ID that identifies a particular family. The Clients table has an autonumber field C_ID that identifies all members of the family and includes sex, age, race etc. for each. The...
I am developing or rather amending an existing database for a non-profit and I am having difficulty visualizing table relationships
The agency wants one master database. It has 12 programs (may add more) that serve families to prevent child abuse/neglect. Families can have members that are...
Posted initially in other forum but this seems more appropriate. I have an Access 2003 database with about 10,000 records. On a network and used by several employees. The database has not been split. When attempting to amend or change data to one form, it won't accept changes and when I try to...
I have an Access 2003 database with about 10,000 records. On a network and used by several employees. The database has not been split. When attempting to amend or change data to one form, it won't accept changes and when I try to close the form I get a message saying "The command or action 'Save...
When I enter a value in a textbox such as "129" the value displayed on the form, after I tab to a new field, changes to "1.29E+02". The value recorded in my table is "129". Why is my form displaying this odd value? Howcan i make it display the entered value?
Thank you
I have a form for a 75-item psychological test. I need to calculate totals for the entire test and also totals for subscales. The test is a true-false test with data entered as 0 or 1. I have made calculated fields that will score some of the subscales but I need the results to be saved in the...
This may help or maybe not. You may have a corrupt record. The database will not compact if a record is corrupted. I have found corrupted records by going to my main table selecting a group of records and then right click and copy. I dont paste them anywhere, I just keep selecting records and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.